Community « Discussion forum « Installation support «

DateTime problem

West Shel -- on Jul. 21 2006

Having a problem writing to the DB... DateTime as GMT choking

Hey folks,

I've got everything installed and set up fine. It actually looks really good!

But anytime I try to add a user, add a section... anything that requires a date... I get a mySQL error saying: #1292 - Incorrect datetime value: '2006-07-22 23:15:25 GMT' for column 'create_date' at row 1

Now... if I take my sql statement, go into mySQL and input that statement, minus "GMT" it goes in just fine.

Did I miss something in my set up of mySQL? Is there a way to remove the GMT out of what's being sent to the database?

I'd be grateful for any help!

--stw

GnapZ from Caribbean 2970 posts	on Jul. 21 2006 Hello, it is the first time i see this problem. I think it is possible that it is somthing out of Yacs, maybe in PHP config or MySql. I will see my config and tell you if i find something.
Shelby T. 3 posts	inspired from GnapZ on Jul. 21 2006 GnapZ: merci beaucoup! I really appreciate the help.
Bernard from nearby-an-airport Associate, 7053 posts	on Aug. 1 2006 Which SQL version are you using?
Shelby T. 3 posts	inspired from Bernard on Aug. 2 2006 Bernard: I was in a dev set up on a laptop using mySQL 5.0.22 ... I actually found a piece of code in shared/surfer.php where (i think) it was inserting "GMT" and just snipped that part out. It worked after that on this instance. When I uploaded it to our hosted production environment, it worked beautifully out of the box. So I'm good to go. Thank you fellas, for your attention. ... by the way, I love this product!
Bernard from nearby-an-airport Associate, 7053 posts	inspired from Shelby T. on Aug. 2 2006 Shelby T.: Ok, the infamous code has been removed from core software. Thank you for your feed-back.

5 comments