[Help] Need help on SQL Syntax error L2J

[Aibu]

I keep getting error as shown in the picture while building a table from
SQL quarry file. L2J version is Kamael 19 version released couple of
weeks ago, and name of the file causing error is "castle_siege_guards.sql"
I believe it's for positioning NPC guards in castles, but not for sure.
Everything work like charm, except for this.
Btw, I'm using mysql 5.0.


Structuring codes are as follow
====================================

-- ---------------------------------------
-- Table structure for castle_siege_guards
-- ---------------------------------------
DROP TABLE IF EXISTS `castle_siege_guards`;
CREATE TABLE IF NOT EXISTS `castle_siege_guards` (
`castleId` INT NOT NULL default 0,
`id` int(11) NOT NULL auto_increment,
`npcId` INT NOT NULL default 0,
`x` INT NOT NULL default 0,
`y` INT NOT NULL default 0,
`z` INT NOT NULL default 0,
`heading` INT NOT NULL default 0,
`respawnDelay` INT NOT NULL default 0,
`isHired` INT NOT NULL default 1,
PRIMARY KEY (`id`),
KEY `id` (`castleId`)
) DEFAULT CHARSET=utf8;
-- -------------------------------------
-- Records for table castle_siege_guards
-- -------------------------------------

-- Gludio Castle
REPLACE INTO `castle_siege_guards` (`castleId`, `id`, `npcId`, `x`, `y`, `z`, `heading`, `respawnDelay`, `isHired`) VALUES
(1,1,35085,-18460,113107,-2759,15608,10800,0),
(1,2,35085,-18432,113107,-2759,15608,10800,0),
(1,3,35085,-18404,113107,-2759,15608,10800,0),
(1,4,35085,-18376,113107,-2759,15608,10800,0),
(1,5,35085,-18348,113107,-2759,15608,10800,0),
(1,6,35085,-18320,113107,-2759,15608,10800,0),

.
.
.
.
.


-- Devastated Castle (NPC Clanhall siege)
//Error starts from here to the end.
(id,2910,35413,178222,-14944,-2200,6320,10800,0),
(id,2911,35413,178255,-14944,-2200,6320,10800,0),
(id,2912,35413,178288,-14944,-2200,6320,10800,0),
(id,2913,35413,178321,-14944,-2200,6320,10800,0),
(id,2914,35413,178354,-14944,-2200,6320,10800,0),
(id,2915,35413,178387,-14944,-2200,6320,10800,0),
(id,2916,35413,178420,-14944,-2200,6320,10800,0),
(id,2917,35413,178454,-14944,-2200,6320,10800,0),
(id,2918,35413,178222,-14924,-2200,6320,10800,0),
(id,2919,35413,178255,-14924,-2200,6320,10800,0),
(id,2920,35413,178288,-14924,-2200,6320,10800,0),
(id,2921,35413,178321,-14924,-2200,6320,10800,0),
(id,2922,35413,178354,-14924,-2200,6320,10800,0),
(id,2923,35413,178387,-14924,-2200,6320,10800,0),
(id,2924,35413,178420,-14924,-2200,6320,10800,0),
(id,2925,35413,178454,-14924,-2200,6320,10800,0),
(id,2926,35412,178222,-14904,-2200,6320,10800,0),
(id,2927,35412,178255,-14904,-2200,6320,10800,0),
(id,2928,35412,178288,-14904,-2200,6320,10800,0),
(id,2929,35412,178321,-14904,-2200,6320,10800,0),
(id,2930,35412,178354,-14904,-2200,6320,10800,0),
(id,2931,35412,178387,-14904,-2200,6320,10800,0),

.
.
.
.

=======================================

I really don't know anything about SQL so plz help me out in plain
english. Thanks =)

 

[tristaina]

Can you show us some line just BEFORE the error please ?

I guess there is an error just before, cause the line you show in red don't seem to be bugged.

EDIT : I didn't see the "id" in the red line the first time I read that. What the hell are those "id" ???
I don't know the "castle_id" of devastated clan hall, maybe it's its clan_hall_id. Try it and look if that solve your problem.

 

[Aibu]

Problem probably solved.
I presume those parts with "id" intagged causing SQL error,
were for future update, or left out on purpose.