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

[millers]

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

 

 

 

[Aya]

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

[millers]

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

[Furiosus]

Problem Resolved  you can lock it

 

Locked.