Errormessage FrontEndUsers: Incorrect datetime value

[pgoneill]

it's (probably) because the database fields are of type DATE, not DATETIME.  Can you confirm this?
you should see them in cms_module_feusers_users

They are DATETIME.

[Roland]

I had the same problem...

I patched modules/FrontEndUsers/FrontEndUsers.api.php (Version 1.1.1, line 1419 to 1421 in function AddUser()) to:
 

Code: Select all

  $dbresult = $db->Execute( $q, array( $uid, $name, md5($password), 
					 trim($db->DBTimeStamp(time()),"'"),
					 trim($db->DbTimeStamp($expires),"'") ) );

without guarantee - it seems to fix this... 

[pgoneill]

It worked. Nice job, Roland!

[lizziv]

Thank you for the fix! I was experiencing the same problem on a clean install of CMSMS 1.0.2 with Front End Users 1.1.1, running on Apache 2 and MySQL 5 on a Windows 2000 server.

[moorezilla]

The "trim" fix above fixes the same problem on ubuntu linux 6.06, php5.x, mysql5.x, apache2.x as well.

[jmcgin51]

Works for me on Windows 2003 server and IIS 6.0.  AWESOME WORK, ROLAND!!

[calguy1000]

This has been fixed in SVN, I just haven't cut a new release yet.