absolute gm shop

[dasoldier]

when i wanna execute the sql as batch file i get an error

Query:
CREATE TABLE `teleport` (
`Description` varchar(75) default NULL,
`id` decimal(11,0) NOT NULL default '0',
`loc_x` decimal(9,0) default NULL,
`loc_y` decimal(9,0) default NULL,
`loc_z` decimal(9,0) default NULL,
`price` decimal(5,0) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-02-18 02:38:44
Line no.:22
Error Code: 1050 - Table 'teleport' already exists

Query:
CREATE TABLE `teleport` (
`Description` varchar(75) default NULL,
`id` decimal(11,0) NOT NULL default '0',
`loc_x` decimal(9,0) default NULL,
`loc_y` decimal(9,0) default NULL,
`loc_z` decimal(9,0) default NULL,
`price` decimal(5,0) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-02-18 02:41:08
Line no.:22
Error Code: 1050 - Table 'teleport' already exists

Query:
replace into spawnlist values(2554,'24_18_NPC_031201_04',1,7159,83100,148843,-3469,0,0,32500,60,0)

Error occured at:2007-02-18 03:02:28
Line no.:1819
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
replace into spawnlist values(2554,'24_18_NPC_031201_04',1,7159,83100,148843,-3469,0,0,32500,60,0)

Error occured at:2007-02-18 03:03:18
Line no.:1819
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
replace into spawnlist values(2554,'24_18_NPC_031201_04',1,7159,83100,148843,-3469,0,0,32500,60,0)

Error occured at:2007-02-18 03:04:06
Line no.:1819
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
replace into spawnlist values(2554,'24_18_NPC_031201_04',1,7159,83100,148843,-3469,0,0,32500,60,0)

Error occured at:2007-02-18 03:07:00
Line no.:1819
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
replace into spawnlist values(2554,'24_18_NPC_031201_04',1,7159,83100,148843,-3469,0,0,32500,60,0)

Error occured at:2007-02-18 03:10:33
Line no.:1819
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
replace into spawnlist values(2554,'24_18_NPC_031201_04',1,7159,83100,148843,-3469,0,0,32500,60,0)

Error occured at:2007-02-18 03:14:04
Line no.:1819
Error Code: 1136 - Column count doesn't match value count at row 1


hope u can solfe this problem for me

[Hexa]

read the error codes... they tell you exactly what is wrong