Page 2 of 2
Re: GM commands not working
Posted: Tue Jun 12, 2018 11:25 am
by darkslayer
Thank you. I will check my tables and see if this works.
Re: GM commands not working
Posted: Tue Jun 12, 2018 8:23 pm
by Delaide
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.
Re: GM commands not working
Posted: Wed Jun 27, 2018 3:57 pm
by darkslayer
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.