QuoteJan 23, 2010 05:580 people like thisLike
 

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.

QuoteJan 23, 2010 08:030 people like thisLike
 

anyone? experts? agents?

QuoteJan 23, 2010 08:200 people like thisLike
 

Hello,


See the following ticket on trac. Some one else had the same problem. If you read the ticket history it should indicate how to resolve the issue.

http://www.boonex.com/trac/dolphin/ticket/1171

QuoteJan 24, 2010 18:300 people like thisLike
 

It seems that this error is depending on some particular MySQL version, or some particular MySQL setting option. Can you provide access to your server (phpMyAdmin) vi PM to check this problem ?

Rules: http://www.boonex.com/unity/txt/terms
QuoteFeb 03, 2010 08:430 people like thisLike
 

hi,

Thank you for all help

but This problem is still active