confirmation mail

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.

Quote · 23 Jan 2010

anyone? experts? agents?

Quote · 23 Jan 2010

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

Quote · 23 Jan 2010

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/terms
Quote · 25 Jan 2010

hi,

Thank you for all help

but This problem is still active

Quote · 3 Feb 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.