[Ascent] Character SQL not working

Results 1 to 4 of 4
  1. #1
    Newbie Gfrins is offline
    MemberRank
    Dec 2007 Join Date
    2Posts

    [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?


  2. #2
    Newbie AceTaylor is offline
    MemberRank
    Dec 2007 Join Date
    11Posts

    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.

  3. #3
    Newbie Gfrins is offline
    MemberRank
    Dec 2007 Join Date
    2Posts

    Re: [Ascent] Character SQL not working

    What was the solution?

  4. #4
    Elite Member Shadei is offline
    Member +Rank
    Dec 2005 Join Date
    174Posts

    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



Advertisement