[random123]

We are currently using windows server 2008 and mysql server version 5.6.15 everything works fine but on our newly purchased server running Windows server 2012 and mysql server version 5.6.15 whenever we make a dump from the 2008 server to run on the 2012 stats don't save on log out and the mysql logs get spammed with this.

(19/1/2014) Error: Field 'Blah' doesn't have a default value

Do I have to recreate my database and include default values or is this just an issue with windows 2012?

[Cole_William]

Did you go in the database and change values to NULL or 1/0?

[random123]

Nope, I just make a sql dump from the other server wich is running 2008

[Cole_William]

Go into the database and find the table that's need editing and edit that with NULL or 1 or 0 as default value.

[random123]

Quote:

Originally Posted by Cole_William Go into the database and find the table that's need editing and edit that with NULL or 1 or 0 as default value.

There isn't another way to do this? It is returning this error for every single field in the database and like I said before this is a dump from a working server I have running right now just that one is on windows server 2008

[Cole_William]

How old is the sql?

[random123]

Quote:

Originally Posted by Cole_William How old is the sql?

Its not old at all we bought a server last month, installed the sql on it imported the dump everything works fine there is 80 players on now with no issues. The server then started getting nailed with ddos attacks so we are moving to a better protected host that only offers windows server 2012, so we need to figure out a way to do this. I can try your method but I honestly don't think that is the issue since everything is working just fine as of right now on the 2008 server.

[Sithis]

This is certainly not an issue with Windows Server 2012, but rather an issue with your database structure. Try Googling the error.