Startup problem - item problem?

[msknight]

Just SVN'd the latest ...
3150 and 6237

Get the following which I'm taking to mean that there isn't a field named, "handler," in the item table?...

Code: Select all

EnchantSkillTreeTable: Loaded 296 enchant skills.PledgeSkillTreeTable: Loaded 41 pledge skillsTransformSkillTreeTable: Loaded 50 transform skillsSpecialSkillTreeTable: Loaded 3 special skillsdata error on item:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'handler' in 'field list'        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:244)        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:214)        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:216)        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:543)

[_DS_]

Check etcitem table, or better just run update scripts.

[msknight]

I had worked through all the tables. On every update the main tables are just run, such as armour, etcitem, weapon, droplist, spawnlist, etc. ... they automatically drop the previous table.

I ran the last four or five update scripts and the only one that wasn't done already was to delete 426 and 427 from character_skills.

I am human ... I must have missed something .. somwhere ... I just can't work out where.

[_DS_]

Code: Select all

    /** Table of SQL request in order to obtain items from tables [etcitem], [armor], [weapon] */    private static final String[] SQL_ITEM_SELECTS =    {        "SELECT item_id, name, crystallizable, item_type, weight, consume_type, material," + " crystal_type, duration, time, price, crystal_count, sellable, dropable, destroyable, tradeable, handler, skill FROM etcitem",                "SELECT item_id, name, bodypart, crystallizable, armor_type, weight," + " material, crystal_type, avoid_modify, duration, time, p_def, m_def, mp_bonus,"                + " price, crystal_count, sellable, dropable, destroyable, tradeable, enchant4_skill, skill FROM armor",                "SELECT item_id, name, bodypart, crystallizable, weight, soulshots, spiritshots," + " material, crystal_type, p_dam, rnd_dam, weaponType, critical, hit_modify, avoid_modify,"                + " shield_def, shield_def_rate, atk_speed, mp_consume, m_dam, duration, time, price, crystal_count," + " sellable, dropable, destroyable, tradeable, skill,enchant4_skill_id,enchant4_skill_lvl, onCast_skill_id, onCast_skill_lvl,"                + " onCast_skill_chance, onCrit_skill_id, onCrit_skill_lvl, onCrit_skill_chance, change_weaponId FROM weapon"    }; 

As you can see, 'handler' used only for etcitem.

[msknight]

Thanks. Something must have gone wrong, but I don't have handler in the datapack I have. I'll try and update it again.

Michelle.