Page 2 of 2
Re: Errormessage FrontEndUsers: Incorrect datetime value
Posted: Wed Oct 18, 2006 7:20 pm
by pgoneill
calguy1000 wrote:
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.
Re: Errormessage FrontEndUsers: Incorrect datetime value
Posted: Thu Oct 26, 2006 9:23 am
by 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...
Re: Errormessage FrontEndUsers: Incorrect datetime value
Posted: Fri Oct 27, 2006 4:13 pm
by pgoneill
It worked. Nice job, Roland!
Re: Errormessage FrontEndUsers: Incorrect datetime value
Posted: Tue Nov 14, 2006 9:21 pm
by 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.
Re: Errormessage FrontEndUsers: Incorrect datetime value
Posted: Tue Dec 05, 2006 12:39 pm
by moorezilla
The "trim" fix above fixes the same problem on ubuntu linux 6.06, php5.x, mysql5.x, apache2.x as well.
Re: Errormessage FrontEndUsers: Incorrect datetime value
Posted: Tue Dec 05, 2006 1:05 pm
by jmcgin51
Works for me on Windows 2003 server and IIS 6.0. AWESOME WORK, ROLAND!!
Re: Errormessage FrontEndUsers: Incorrect datetime value
Posted: Tue Dec 05, 2006 2:28 pm
by calguy1000
This has been fixed in SVN, I just haven't cut a new release yet.