Windows Server 2012 - Printable Version

Windows Server 2012 - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Windows Server 2012 (/showthread.php?tid=488730)

Windows Server 2012 - random123 - 19.01.2014

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?

Re: Windows Server 2012 - Cole_William - 19.01.2014

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

Re: Windows Server 2012 - random123 - 19.01.2014

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

Re: Windows Server 2012 - Cole_William - 19.01.2014

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

Re: Windows Server 2012 - random123 - 19.01.2014

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

Re: Windows Server 2012 - Cole_William - 19.01.2014

How old is the sql?

Re: Windows Server 2012 - random123 - 19.01.2014

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.

Re: Windows Server 2012 - Sithis - 19.01.2014

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