-
Newbie
[Ascent] Character SQL not working
Okay. I click 'execute batch file' and set 'character.sql' as the file and it comes up with this:
[Err] 1050 - Table 'account_data' already exists
[Err] -- ----------------------------
-- Table structure for account_data
-- ----------------------------
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`),
UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Help?
-
-
Newbie
Re: [Ascent] Character SQL not working
I'm not 100% sure, but I think that it is already updated. I had a similar error last night and that was it.
-
Newbie
Re: [Ascent] Character SQL not working
-
Elite Member
Re: [Ascent] Character SQL not working
you are running character sql on a database that's already like that, you will probably need to back up your old character database, drop it, and make a new one with the character.sql or just make a new database with different name and run character.sql on it