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.