Backup accounts help

Cyprus
Posts: 53
Joined: Sat Sep 06, 2014 10:54 pm

Re: Backup accounts help

Post by Cyprus » Sun Sep 28, 2014 9:04 pm

Yep, says:
Unknown column 'mentor" in "field list'

How do I go about fixing this without compromising everyone's characters/accounts?

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: Backup accounts help

Post by kjLotus » Sun Sep 28, 2014 9:14 pm

open a mysql terminal (mysql -u (username) -p(password) on command line)
input:

Code: Select all

use dspdb;
alter table chars add column mentor smallint(3) NOT NULL DEFAULT '0';

Cyprus
Posts: 53
Joined: Sat Sep 06, 2014 10:54 pm

Re: Backup accounts help

Post by Cyprus » Sun Sep 28, 2014 9:45 pm

Looks like I might have got it. It responded with
Database changed
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0

Gonna test it out after a server reboot.
Last edited by Cyprus on Sun Sep 28, 2014 9:51 pm, edited 1 time in total.

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: Backup accounts help

Post by kjLotus » Sun Sep 28, 2014 9:51 pm

should just need "mysql -u (username) -p(password)" on command prompt

Cyprus
Posts: 53
Joined: Sat Sep 06, 2014 10:54 pm

Re: Backup accounts help

Post by Cyprus » Sun Sep 28, 2014 9:52 pm

Ya, I typed that out then realized I was being stupid...edited my last post.

*UPDATE* That fixed it, thanks again!!

Post Reply