PLUSEMU database

[JoshuaS]

So i reset my VPS and now i get these problems importing the database. Using the "Original Database from PLUSEMU on habbofiles.com Anyone know why?

 

[n4te]

So i reset my VPS and now i get these problems importing the database. Using the "Original Database from PLUSEMU on habbofiles.com Anyone know why?

Turn MySQL strict mode off when you're importing with navicat. That worked for me, atleast.

 

[JoshuaS]

Turn MySQL strict mode off when you're importing with navicat. That worked for me, atleast.

How do i turn that off?

 

[n4te]

How do i turn that off?

Spoiler: Query

SET sql_mode = '';

Run that as a query

 

[Object]

Spoiler: Query

SET sql_mode = '';

Run that as a query

In some cases u might need to turn it off globally like this SET @@global.sql_mode= '';

 

[n4te]

In some cases u might need to turn it off globally like this SET @@global.sql_mode= '';

Try running that then. I usually just run the first one I posted.

 

[Liam]

How do i turn that off?

Go to my.ini

Change this:

STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

To this:

NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Restart MySQL