Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Stopped working with upgrade to latest MySQL version

Quote Reply
Stopped working with upgrade to latest MySQL version
Hello,

I ungraded my server to the latest MySQL version (5.7) and now I can't add any links. When I try to add a link i get the error " Incorrect datetime value CURRENT_TIMESTAMP". Can you tell me what files I need to edit to fix this?
Quote Reply
Re: [shimmy1] Stopped working with upgrade to latest MySQL version In reply to
Hi,

You need to convert all the 0000-00-00 00:00:00 default timestamps / date fields into proper dates. Alternativly, turn off the error message in mySQL itself (you would need root for that though)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!