Skip to content

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

Featured Replies

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 !!!

 

 

 

you can remove critical and field list whit values from .sql  file and everything will be ok.

  • Author

Aya no it will not help .. Problem Resolved  you can lock it :) Problem was in sql file lines .. :)

Problem Resolved  you can lock it

 

Locked.

Guest
This topic is now closed to further replies.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.