hi,
join goes well, but when I get confirmation mail and click on confirm link, I get database error as user.
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.