GM commands not working

darkslayer
Posts: 8
Joined: Sat Dec 20, 2014 10:19 am

Re: GM commands not working

Post by darkslayer » Tue Jun 12, 2018 11:25 am

Thank you. I will check my tables and see if this works.

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: GM commands not working

Post by Delaide » Tue Jun 12, 2018 8:23 pm

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.

darkslayer
Posts: 8
Joined: Sat Dec 20, 2014 10:19 am

Re: GM commands not working

Post by darkslayer » Wed Jun 27, 2018 3:57 pm

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.

Post Reply