Sign in to follow this  
Klauser

mySQL error

Recommended Posts

Just tried to use mysql plugin but after that server doesnt start and say "MySQL query error: (1067) Invalid default value for 'vipexp'" just google'd and saw that is a problem with DATETIME and TIMESTAMP... but idk anything about this...

any help? Thx

Share this post


Link to post
Share on other sites

mysql columns can have default values that get filled in when a row is create if no value is put there specifically. that value is invalid for the datetime datatype apparently. 

Share this post


Link to post
Share on other sites

# changing back to the mysql version where it actually worked

or

# setting the correct flags in mysql to allow for null in dates

or

# setting the date to 0 instead of null

im just guessing here. debug your queries ^^

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this