I have such an Error on Join

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 = 169

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1

Mysql error: Column 'DateStarts' cannot be null

Found error in the file '/var/www/web0/html/inc/membership_levels.inc.php' at line 163.
Called 'fromMemory' function with erroneous argument #2.

Quote · 13 Jan 2010

I need help, please. My users on Join get MySQL Error instead of Welcome Screen. After page refresh - is ok. But I am so confused.

Quote · 13 Jan 2010

ANYONE ??

Quote · 14 Jan 2010

I checked my site, I have the same error !! join goes well, but when I get confirmation mail and click on confirm link, I get database error as user.

Quote · 14 Jan 2010

anyone? experts? agents?

Quote · 23 Jan 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.