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

Newbie Spellweaver
Joined
Dec 13, 2007
Messages
49
Reaction score
0
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:
 
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.
 
Back