Switched VPS now emulator randomly gives error(s)

JayC

Always Learning
Aug 8, 2013
5,493
1,398
First problem, run this query: create a backup first just in case it deletes too many rows

Code:
DELETE FROM catalog_items WHERE `item_ids' NOT IN(Select ID from Furniture)
Post automatically merged:

Second problem: Did you import your room models table? What emulator did you switch to?
 

Millzeeg

New Member
Apr 4, 2018
11
0
I didn't switch emulator everything is the exact same which is why I don't understand how anything can be broken. I think Navicat is fucked when you make a backup and then try add that backup to Navicat, it doesn't save all the tables smh.
 

Millzeeg

New Member
Apr 4, 2018
11
0
Can't go back to the old VPS, it's gone forever. I dumped the sql and when I add that db to my Navicat it says error and unsuccessful but it adds some of the tables but not the room models or anything smh.
 

airil96

New Member
Jul 19, 2010
14
0
Have you tried to disable the MySQL Strict Mode before importing the sql into navicat? That might cause the issues you're having with.

If not, try the code below:
SQL:
SET GLOBAL sql_mode='';

If this fail, that means you're having a corrupted database dump.
 

Users who are viewing this thread

Top