Charater error on my server (the error is posted in this msg)

Results 1 to 8 of 8
  1. #1
    Member Scrubnub is offline
    MemberRank
    Dec 2007 Join Date
    59Posts

    Charater error on my server (the error is posted in this msg)

    ok when i try and excute batch file i get this error

    Query:
    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
    Error occured at:2007-12-13 16:50:41
    Line no.:26
    Error Code: 1050 - Table 'account_data' already exists
    Query:
    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
    Error occured at:2007-12-13 16:51:15
    Line no.:26
    Error Code: 1050 - Table 'account_data' already exists
    Query:
    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
    Error occured at:2007-12-13 17:33:57
    Line no.:26
    Error Code: 1050 - Table 'account_data' already exists
    Query:
    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
    Error occured at:2007-12-13 17:34:01
    Line no.:26
    Error Code: 1050 - Table 'account_data' already exists
    Query:
    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
    Error occured at:2007-12-13 17:50:47
    Line no.:26
    Error Code: 1050 - Table 'account_data' already exists

    Plz help me plz
    :kid:


  2. #2
    Member Bobtch is offline
    MemberRank
    Oct 2007 Join Date
    60Posts

    Re: Charater error on my server (the error is posted in this msg)

    It means you don't need to execute it. These tables already exist/are updated. There is no way you can have all of the SQL updates run properly. Most of them would give you errors such as this one, because the updates are old. That's why you have revision numbers in every update's name.

  3. #3
    Member Scrubnub is offline
    MemberRank
    Dec 2007 Join Date
    59Posts

    Re: Charater error on my server (the error is posted in this msg)

    ??
    so what do i do then?

  4. #4
    Member Bobtch is offline
    MemberRank
    Oct 2007 Join Date
    60Posts

    Re: Charater error on my server (the error is posted in this msg)

    I gues... you run the updates that work and... run your server?!

  5. #5
    Member Scrubnub is offline
    MemberRank
    Dec 2007 Join Date
    59Posts

    Re: Charater error on my server (the error is posted in this msg)

    ok
    then when i do that
    i creat a charater and it doesn't show up...

  6. #6
    Member Bobtch is offline
    MemberRank
    Oct 2007 Join Date
    60Posts

    Re: Charater error on my server (the error is posted in this msg)

    Use another revision of ascent.

  7. #7
    Member Scrubnub is offline
    MemberRank
    Dec 2007 Join Date
    59Posts

    Re: Charater error on my server (the error is posted in this msg)

    What is revision ascent
    ?

  8. #8
    You don't know me. Paco44 is offline
    Grand MasterRank
    Apr 2006 Join Date
    IllinoisLocation
    1,777Posts

    Re: Charater error on my server (the error is posted in this msg)

    A newer updated core.



Advertisement