AI Data Error

[n0name12]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 4410
L2JDP Revision Number: 7664

Code: Select all

 2010.09.23 06:10:33,012    SEVERE    10    com.l2jserver.gameserver.datatables.NpcTable    NPCTable: AI Data Error with id : 15372010.09.23 06:10:33,051    SEVERE    10    com.l2jserver.gameserver.datatables.NpcTable    NPCTable: AI Data Error with id : 35860

I have done some modifications to the database so i dont expect support for this error.
But i would like someone to help me resolve this and tell me at least where does it come from.
Is it from npcaidata table ? I just want a logical explanation so i can fix it.
thank you in advance.

[jurchiks]

open that file in source code, find that error message and check what it does before it shows this.

[_DS_]

Found ai data, but no such npc.

[celestialcommunity]

If you want to try re-create the NPCs in the tables.

Delete row npcs 1537 and 35860 in tables NPC and npcaidata.

My rows for these NPCs are these:

Code: Select all

INSERT INTO `npc` (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `enchant`, `walkspd`, `runspd`, `isUndead`, `absorb_level`, `absorb_type`, `drop_herbs`) VALUES (1537, 1537, 'Gwanwoo Hwamae Agathion', 0, '', 0, 'LineageNPC2.br_agathion_hatbird', 6.01, 5.00, 55, 'male', 'L2Npc', 40, 2643, 988, 0.00, 0.00, 40, 43, 30, 21, 20, 25, 0, 0, 665, 322, 311, 262, 253, 0, 333, 0, 0, 0, 0, 60, 120, 0, 0, 'LAST_HIT', 'false');INSERT INTO `npc` (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `enchant`, `walkspd`, `runspd`, `isUndead`, `absorb_level`, `absorb_type`, `drop_herbs`) VALUES (35860, 35860, 'Guard Captain', 0, 'Bayou Fortress', 0, 'LineageNPC2.garrison_of_insurgents', 10.00, 23.75, 70, 'male', 'L2Npc', 40, 3862, 1494, 10.00, 2.00, 40, 43, 30, 21, 20, 20, 0, 0, 1303, 471, 607, 382, 253, 0, 333, 80, 641, NULL, 0, 80, 120, 0, 0, 'LAST_HIT', 'false');INSERT INTO `npcaidata` (`npc_id`, `skill_chance`, `primary_attack`, `canMove`, `minrangeskill`, `minrangechance`, `maxrangeskill`, `maxrangechance`, `soulshot`, `spiritshot`, `spschance`, `sschance`, `ischaos`, `clan`, `clan_range`, `enemyRange`, `enemyClan`, `dodge`, `ai_type`) VALUES (1537, 15, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, '', 0, NULL, NULL, NULL, 'fighter');INSERT INTO `npcaidata` (`npc_id`, `skill_chance`, `primary_attack`, `canMove`, `minrangeskill`, `minrangechance`, `maxrangeskill`, `maxrangechance`, `soulshot`, `spiritshot`, `spschance`, `sschance`, `ischaos`, `clan`, `clan_range`, `enemyRange`, `enemyClan`, `dodge`, `ai_type`) VALUES (35860, 15, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, '', 0, NULL, NULL, NULL, 'balanced'); 

[jurchiks]

Found ai data, but no such npc.

I must say, the error message is misleading...

[n0name12]

thank you very much for you answers.
i remember now what i did wrong looking at the sql files you posted.

[dinor]

i had the same error in linux
just rename the table "npcaidata" in your database to "npcAIData" (capital letters)
and it will be fixed