|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000253||v1.2 Release (Closed)||[All Projects] General||public||2009-09-11 18:03||2009-12-08 19:09|
|Target Version||Fixed in Version||1.2|
|Summary||0000253: Can't logon w2p !!!|
|Description||I run w2p on Zend CE on Windows. It worked right until some revision ago. Can't tell which one, something around r604. Logon screen appears, but hit error 500 with this message in the log.|
C:\Program Files\Zend\Apache2\htdocs\web2project\classes\query.class.php(1145): query failed(UPDATE `user_access_log` SET `date_time_last_action` = 'NOW()' WHERE user_access_log_id = 3173) - error was: <span style="color:red">Incorrect datetime value: 'NOW()' for column 'date_time_last_action' at row 1</span>.
I tried many things: convert again from a fresh dP database, update Zend CE. BTW, when I config, the Server API is now reported to be problematic.
Have you created a new dependency to Linux by any chance?
|Tags||No tags attached.|
egemme are you using version 1.1 of w2P?
If no, please do because I think this only existed on a particular revision, and shouldn't be happening anymore.
Cheers and let us know.
egemme, can you please try grabbing the latest revision? I believe I have this fixed there. Please let me know how you make out!
FYI, I was using r624 from trunk hence, 1.1. I updated to the head revision as per trevormorse recommendation, and this fixed the problem so far so good. I can logon again and play around again. Thanks for your prompt answer, it's always a pleasure to work with all of you!
But, I still get the message "CGI is likely to have problems" in the install checks. I believe Zend uses a FastCGI api by default. I thinks this is a false problem as far as w2p seems to work fine now.
|Glad it worked for you egemme! Please take a look at this link for a response about the FastCGI warning - http://forums.web2project.net/viewtopic.php?t=633|
|2009-09-11 18:03||egemme||New Issue|
|2009-09-12 08:11||caseydk||Status||new => assigned|
|2009-09-12 08:11||caseydk||Assigned To||=> trevormorse|
|2009-09-12 09:39||pedroa||Note Added: 0000479|
|2009-09-12 09:39||pedroa||Status||assigned => feedback|
|2009-09-12 12:12||trevormorse||Note Added: 0000480|
|2009-09-12 19:36||egemme||Note Added: 0000481|
|2009-09-13 04:24||trevormorse||Note Added: 0000484|
|2009-09-13 04:25||trevormorse||Status||feedback => resolved|
|2009-09-13 04:25||trevormorse||Resolution||open => fixed|
|2009-09-15 09:10||caseydk||Project||v1.1 Release (Closed) => v1.2 Release (Closed)|
|2009-12-08 19:09||caseydk||Status||resolved => closed|
|2009-12-08 19:09||caseydk||Fixed in Version||=> 1.2|