Error 'invalid default value' when importing default database 0.9.4

[Tobias Solem 559]

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'

[Tobias Solem 559]

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

[WolfkillArcadia 758]

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. 

[Tobias Solem 559]

Upgrading according to above worked.

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

[Gotteshand 59]

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

[|BoW|Tophi * 4]

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

[WolfkillArcadia 758]

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. 

[Guest]

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

[Tobias Solem 559]

Yes. Upgrading to 5.6 fixed the problem. You can't do it without 5.6.

[LangeBlonds 17]

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 December 10, 2015 by LangeBlonds