[PlusEmu] 2017 Plus emulator R2 database failing to import

[AliTheSenpai]

When i import the plus emu db half of the database fails? Im using navicat and mysql server IIS

[MentaL]

[Aamiainen]

If you're getting errors but some of the tables get imported, then it's propably the sql-mode setting in your my.ini that is causing it. Both options, strict_all_tables and strict_trans_tables are meant to prevent invalid values from being inserted into your columns. So check your my.ini and see how it's set and try to remove strict_all_tables or strict_trans_tables part from it.

for instance if it's something like:

sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

you change it to:

sql-mode="ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

And if that doesnt work, try changing it to blank:

sql-mode=""

Oh and remember to restart your mysql after making any changes to my.ini for them to take effect. Restarting can be done by writing these commands to cmd:
net stop MySQL57
net start MySQL57
note: might not work depending on your mysql version.

[AliTheSenpai]

Thanks problem solved :)