Nightly npc PROBLEM

[evolance]

Hi, I have nightly server files but i have a problem with GM Shop and every custom npc in game. When i batch files everything goes good ,but npc_ files dont work,for example npc buffer,when i batch it i get an error :

 

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

[Err] -- Oneo Dev Team Npc Buffer special thx to Panic

INSERT INTO `npc` VALUES ('40006', '30003', 'Buffer', '1', 'OneoDevTeam', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Npc', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

What can i do about that?

[takhs7]

i dont have try nightlies.. but i think the database its too old .. .so u will need to put the sql manualy..

[eKoIce]

ok..np....

 

Open your Sql file with Wordpad ....and Leave only this :

 

INSERT INTO `npc` VALUES ('40006', '30003', 'Buffer', '1', 'OneoDevTeam', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Npc', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0');

 

Cancel the header.

Then save and execute it again..It Must WORKS !

 

 

[John Lamprou]

Lol it is not nightly db.Well nightly is official l2j serverpack(mainworkers)The db you use is from l2jdb the offcial db team.And it is not old.The sql that you want to batch has not the right syntax coloums.Well it is easy to fix it because actually it is not an error.

 

Well try Ekoice code i didnt check if it is correct but it must work

[DaRkRaGe]

Try to keep your sources updated the error is that missing the last field.

 

INSERT INTO `npc` VALUES ('40006', '30003', 'Buffer', '1', 'L2JOneo', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Npc', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0', 'LAST_HIT');

[Schnappi]

I had the same problem