Thread: Mysql error: Column 'DateStarts' cannot be null

Hi there!

This seems to be the place that can actually fix stuff. And I have searched around and not even boonex had the answer. My install is pretty new and I haven't done much mod to it.

Problem:
When people sign up to my dolphin 7 and click the registration link in their mail, they arrive to the site saying:

Error
Database query error

They are actually confirmed, but this is naturally no good, and I also get the error report (I will post that in the end).

According to #1171 (Memory problem after updating promotional member to standard member) - Dolphin - Trac
The memory_limit should be the problem. But mine is already 128 M (as a max from the host). No places on the net knows what to do.


I am not the only one with this problem:
confirmation mail :: BoonEx Unity Forums

I really hope you are able to help as I can not open the community until an error like this is fixed. It is one of the first things they will meet.


Thanks!
Chrisstoffer



The email i got from the system:

Code:

Database error in

Query:

SELECT	`sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM	`sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND	(`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(-1))
AND	(`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(-1))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID
WHERE	Profiles.ID = 5
ORDER BY `sys_acl_levels_members`.DateStarts DESC
LIMIT 0, 1

Mysql error: Column 'DateStarts' cannot be null

Found error in the file '/home/www/nordicalternatives.com/inc/membership_levels.inc.php' at line 163.
Called 'fromMemory' function with erroneous argument #2.

I can send you the "Debug backtrace:" (minus passwords etc.) but it is longer than the 20000 characters allowed in the community. But let me know what you need.

Hi,

Yes - there is - but maybe not through the public forums - you may need to have buy support from someone, us (open a ticket), boonex, someone else - to access your hosting/site and check it.

Smoge

Our rate is $68/hour - not sure what BoonEx or others rates are.

Smoge