Problem with every buffer i download

[guana]

[Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO `npc` VALUES (555, 36562, 'Buffer', 1, 'Buffer', 1, 'LineageNPC2.garrison_of_insurgents', '10.00', '23.75', 86, 'male', 'L2Npc', 40, '32490', '1712', '56.86', '3.09', 40, 43, 30, 21, 20, 20, 145669, 15182, 10203, 1024, 7022, 1022, 230, 0, 253, 0, 0, 0, 73, 191, 0, 1);

[Msg] Finished - Unsuccessfully

 

i've already tryed to enter by hand and this is the first one that i can spawn in game but it just says "i have nothing to say to you/ quest"

i open the sql and it had hundreds of lines is there something i'm doing wrong i'm executing the batch file into my navicat and this is the error i get on EVERY one i try

i've tryed a least 5 different buffers for freya and none have worked so i'm guessing it's me. any help would be greatly appriciated

[Dradden]

[Err] 1136 - Column count doesn't match value count at row 1

this error shows that one column has changed its data type for ex. from text to longint.

 

change each insert to:

INSERT INTO `custom_npc` ('id', 'idtemplate', 'name', 'serversidename', 'title', 'serversidetitle', 'class', 'collision_radius', 'collision_height', 'level', 'sex','type') VALUES ('90100', '30181', 'Aramiss', '1', 'Weapon Shop', '1', 'NPC.a_traderA_MHuman', '10.00', '24.00', '80', 'male', 'L2Merchant');

But beware of the Values. remove all values after the type of the npc. that should work if they are merchants or npc not monsters.

 

[Matim]

Wrong Section.

 

Read Our Forum Rules.

 

You should post it here [Request] Dev Help [L2J] En.

 

Before posting also check Rules of this Section.

 

Topic Locked.