Tobias Solem

Error 'invalid default value' when importing default database 0.9.4

13 posts in this topic

What I did:

Dropped the old tables, imported the new default exile.sql

Expected outcome:

Database imports just fine.

Actual outcome:

ERROR 1067 (42000): Invalid default value for 'first_connect_at'

Share this post


Link to post
Share on other sites

Plausible cause, latest approved stable update for Debian "wheezy" is ver5.5.46 (using readline 6.3).

Possible solution:

Add the Repo:
wget http://repo.mysql.com/mysql-apt-config_0.2.1-1debian7_all.deb
dpkg -i mysql-apt-config_0.2.1-1debian7_all.deb

The above package will create a file /etc/apt/sources.list.d/mysql.list which will contain lines like these or similar:
deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6
deb-src http://repo.mysql.com/apt/debian/ wheezy mysql-5.6

Install mysql 5.6:
apt-get update
apt-get install mysql-server-5.6

Share this post


Link to post
Share on other sites
Advertisement
7 minutes ago, Tobias Solem said:

Plausible cause, latest approved stable update for Debian "wheezy" is ver5.5.46 (using readline 6.3).

Possible solution:

Add the Repo:
wget http://repo.mysql.com/mysql-apt-config_0.2.1-1debian7_all.deb
dpkg -i mysql-apt-config_0.2.1-1debian7_all.deb

The above package will create a file /etc/apt/sources.list.d/mysql.list which will contain lines like these or similar:
deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6
deb-src http://repo.mysql.com/apt/debian/ wheezy mysql-5.6

Install mysql 5.6:
apt-get update
apt-get install mysql-server-5.6

I think you are right because I'm running version 5.6 and it's not having issues when running the script. 

Share this post


Link to post
Share on other sites

Upgrading according to above worked.

Don't forget to stop your mysqld before you install the new version.

Share this post


Link to post
Share on other sites

Good evening.
Get the same error message and can not install the database. Can you deal without MySQL to update?
Best regards

Share this post


Link to post
Share on other sites
1 hour ago, Tobias Solem said:

What I did:

Dropped the old tables, imported the new default exile.sql

Expected outcome:

Database imports just fine.

Actual outcome:

ERROR 1067 (42000): Invalid default value for 'first_connect_at'

i have same problem

Share this post


Link to post
Share on other sites
3 minutes ago, |BoW|Tophi * said:

i have same problem

The mySQL server has to be Version 5.6 or higher because there is syntax used that only exists in that version. Please update your mySQL to version 5.6 to fix this issue. 

1 person likes this

Share this post


Link to post
Share on other sites

From what i've read on the skype chats is that 5.5 doesn't work with this new update because its missing features that 5.6 has

Share this post


Link to post
Share on other sites
Thanks thanks thanks
I had the same problem with debian 7 linux interface JSI TO DEDI
and thanks to you I spent putty by MySql 5.7.8rc
I was actually in version 5.5
Thanks again
Best regards
super comunity, Bravo for fast !!!!!!
Edited by LangeBlonds

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.