Jump to content
  • 0

[help]Freya Unknown error (Unknown column 'can_move' , 'critical' )


Question

Posted

Hello i  tried to import npc buffer but i get this error

 

 

 

2011.17.2 02:46:40 com.l2jserver.gameserver.datatables.NpcTable restoreNpcData
SEVERE: NPCTable: Error creating custom NPC table.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'critical' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.l2jserver.gameserver.datatables.NpcTable.restoreNpcData(NpcTable.java:104)
at com.l2jserver.gameserver.datatables.NpcTable.<init>(NpcTable.java:64)
at com.l2jserver.gameserver.datatables.NpcTable.<init>(NpcTable.java:49)
at com.l2jserver.gameserver.datatables.NpcTable$SingletonHolder.<clinit>(NpcTable.java:919)
at com.l2jserver.gameserver.datatables.NpcTable.getInstance(NpcTable.java:57)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:259)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:485)
2011.17.2 02:46:41 com.l2jserver.gameserver.datatables.NpcTable restoreNpcData
SEVERE: NPCTable: Error reading NPC Custom AI Data: Unknown column 'can_move' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'can_move' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.l2jserver.gameserver.datatables.NpcTable.restoreNpcData(NpcTable.java:423)
at com.l2jserver.gameserver.datatables.NpcTable.<init>(NpcTable.java:64)
at com.l2jserver.gameserver.datatables.NpcTable.<init>(NpcTable.java:49)
at com.l2jserver.gameserver.datatables.NpcTable$SingletonHolder.<clinit>(NpcTable.java:919)
at com.l2jserver.gameserver.datatables.NpcTable.getInstance(NpcTable.java:57)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:259)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:485)

 

Edited in General.properties :

# Default: False

CustomNpcBufferTables = True

 

# Default: False

CustomNpcTable = True

 

and mysql table custom_npcaidata is empty

why i get this error ?

 

here is the part from npctable.java

		//-------------------------------------------------------------------
		//NPC AI Attributes & Data ...

		try
		{
			PreparedStatement statement10 = con.prepareStatement("SELECT " + L2DatabaseFactory.getInstance().safetyString(new String[] {"npc_id", "primary_attack","skill_chance","can_move","soulshot","spiritshot","sschance","spschance","minrangeskill","minrangechance","maxrangeskill","maxrangechance","ischaos","clan","clan_range","enemyClan","enemyRange","ai_type","dodge"}) + " FROM npcaidata ORDER BY npc_id");
			ResultSet NpcAIDataTable = statement10.executeQuery();
			L2NpcAIData npcAIDat = null;
			L2NpcTemplate npcDat = null;
			int cont=0;
			while (NpcAIDataTable.next())
			{
				int npc_id = NpcAIDataTable.getInt("npc_id");
				npcDat = _npcs.get(npc_id);
				if (npcDat == null)
				{
					_log.severe("NPCTable: AI Data Error with id : " + npc_id);
					continue;
				}
				npcAIDat = new L2NpcAIData();

				npcAIDat.setPrimaryAttack(NpcAIDataTable.getInt("primary_attack"));
				npcAIDat.setSkillChance(NpcAIDataTable.getInt("skill_chance"));
				npcAIDat.setCanMove(NpcAIDataTable.getInt("can_move"));
				npcAIDat.setSoulShot(NpcAIDataTable.getInt("soulshot"));
				npcAIDat.setSpiritShot(NpcAIDataTable.getInt("spiritshot"));
				npcAIDat.setSoulShotChance(NpcAIDataTable.getInt("sschance"));
				npcAIDat.setSpiritShotChance(NpcAIDataTable.getInt("spschance"));
				npcAIDat.setIsChaos(NpcAIDataTable.getInt("ischaos"));
				npcAIDat.setShortRangeSkill(NpcAIDataTable.getInt("minrangeskill"));
				npcAIDat.setShortRangeChance(NpcAIDataTable.getInt("minrangechance"));
				npcAIDat.setLongRangeSkill(NpcAIDataTable.getInt("maxrangeskill"));
				npcAIDat.setLongRangeChance(NpcAIDataTable.getInt("maxrangechance"));
				//npcAIDat.setSwitchRangeChance(NpcAIDataTable.getInt("rangeswitchchance"));
				npcAIDat.setClan(NpcAIDataTable.getString("clan"));
				npcAIDat.setClanRange(NpcAIDataTable.getInt("clan_range"));
				npcAIDat.setEnemyClan(NpcAIDataTable.getString("enemyClan"));
				npcAIDat.setEnemyRange(NpcAIDataTable.getInt("enemyRange"));
				npcAIDat.setDodge(NpcAIDataTable.getInt("dodge"));
				npcAIDat.setAi(NpcAIDataTable.getString("ai_type"));
				//npcAIDat.setBaseShldRate(NpcAIDataTable.getInt("baseShldRate"));
				//npcAIDat.setBaseShldDef(NpcAIDataTable.getInt("baseShldDef"));


				//npcDat.addAIData(npcAIDat);
				npcDat.setAIData(npcAIDat);
				cont++;
			}

			NpcAIDataTable.close();
			statement10.close();
			_log.info("NPC AI Data Table: Loaded " + cont + " AI Data.");
		}
		catch (Exception e)
		{
			_log.log(Level.SEVERE, "NPCTable: Error reading NPC AI Data: " + e.getMessage(), e);
		}

 

I'm Using l2jserver !!!

 

 

 

3 answers to this question

Recommended Posts

Guest
This topic is now closed to further replies.


  • Posts

    • Looking a datapack developer for 'Essence' - needs to be good with Mobius structure,  Project is using old fork (I think base from crusader). Write Discord to PM.
    • We are not back on 2005, life in our days is harder than before, in complection with other things yes, L2 has not the same look.
    • 🌍 https://l2origins.org/ 🛡️ LINEAGE II ORIGINS — SEASON 1 🛡️ 🌑 High Five Classic | True Old-School Experience 🌑 ⚠️ Opening on March 6th at 16:00 Welcome back to the origins of Lineage II. ⚔️ ABOUT THE SERVER Lineage2 Origins is built for players who miss the true retail feeling. Classic progression, real challenges, fair competition — enhanced only with carefully selected QoL features, never breaking the original gameplay. 🌿 PHASED GEAR PROGRESSION 🟢 Month 1: Vesper max 🟢 Month 2: Vorpal unlocked 🟢 Month 3+: Top-grade & Elegia released 🚫 NO AUTO-FARM ✔️ External auto-clicker allowed (1 per client, download page only) ❌ Bots & illegal automation forbidden 🛡️ Strong anti-bot + captcha system ⚠️ AFK players will be punished — stay active or logout 📊 RATES & CORE SETTINGS 🔹 Adena: x5 🔹 Drop / Spoil: x5 🔹 Skill EXP: x15 🔹 Max Windows: 2 per PC 🔹 Subclass: Lv 85 (no quest required) 🔹 Party Level Diff: 30 (55–85) 🔹 No custom items (armors / weapons / jewelry) 🔥 FEATURES ✨ Global & Raid Teleport ✨ NPC Buffer (34 buffs) ✨ Auto Events & PvP Zones ✨ Ranking & Clan Progression ✨ GM Shop & Premium System ✨ All-In-One Community Board ✨ Party & Solo Instances ✨ Siege & Territory War Rewards ✨ RaidBoss Kill Rewards ✨ Lucky Creature Event ✨ Daily Login Rewards ✨ Advanced DDoS Protection & Backups ⚔️ ENCHANTMENTS 🔸 Safe: +3 🔸 Max: +12 (Month 2: +14 | Month 3: +16) 🔸 Blessed: 50% (Premium 65%) 🔸 Normal: 45% (Premium 60%) 🏟️ OLYMPIAD 🔹 Max Enchant: +6 🔹 Start Players: 4 🔹 Period: 1st & 15th 🏰 SIEGE & TW 🔹 Siege Time: 16:00 & 20:00 🔹 Territory War: 20:00 🔹 Max Wards: 3 per Castle 🌌 Lineage2 Origins Fair. Competitive. Nostalgic. A true return to the origins of Lineage II.
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..