GM commands not working
-
- Posts: 8
- Joined: Sat Dec 20, 2014 10:19 am
Re: GM commands not working
Thank you. I will check my tables and see if this works.
Re: GM commands not working
No problem, but remember, there are more than just the chars table in the example.
You should do a comparison of all tables that you do not replace with the updated tables from DSP.
Normally those tables will be the ones listed here: https://wiki.dspt.info/index.php/Buildi ... e_Database
But, since I assume you manually back up or script the back up, you should probably know which tables you exported and then imported to the new server update.
You should do a comparison of all tables that you do not replace with the updated tables from DSP.
Normally those tables will be the ones listed here: https://wiki.dspt.info/index.php/Buildi ... e_Database
But, since I assume you manually back up or script the back up, you should probably know which tables you exported and then imported to the new server update.
-
- Posts: 8
- Joined: Sat Dec 20, 2014 10:19 am
Re: GM commands not working
I fixed the issue by adding the missing column to the chars table. I use command line for everything so it took some research.
The fix command:
ALTER TABLE chars ADD COLUMN ('nnameflags' int(10) UNSIGNED NOT NULL DEFAULT '0');
Thank you for pointing me in the right direction.
The fix command:
ALTER TABLE chars ADD COLUMN ('nnameflags' int(10) UNSIGNED NOT NULL DEFAULT '0');
Thank you for pointing me in the right direction.