Tobias Solem

Error 'invalid default value' when importing default database 0.9.4

13 posts in this topic

It's possible to use MySQL 5.5 for Exile 0.9.4, but you have to do much more work.

I couldn't update my server that easily to a newer MySQL Version, so i found a workaround with triggers and correct use of 5.5 Syntax.

You need to edit the .sql file before importing, so that you can use it with 5.5 and then you have to create triggers for each table, which will do the same as the 5.6 Syntax

 

If you want you can download my modified .sql here:

https://github.com/Jenartor/Exile_sql

It's all ready to import with any tool you want, even from the console. For now it's working fine on my Server with mysql5.5. 

 

Edited by Jenartor

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.