L2J Server

Posted: **Fri Jul 17, 2009 10:33 am**

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 3220:
L2JDP Revision 3627:

Im using the last version of Gracia Part 2 (see revisions above), and the server will not load the XML's for the weapons. I made sure the Database table is the default one from the last datapack from Gracia part 2, and the XML's are default from the last revision of Gracia part 2 datapack also, but they wont load for the life of me... Am i missing something? Any help would be greatly appreciated. Below is an example of the errors on the server console, although im getting errors for all XML's for weapons. Wasnt sure if this was a datapack issue or a server issue so if this is in the wrong section, sry about that

:

Code: Select all

Jul 17, 2009 3:06:44 AM net.sf.l2j.gameserver.datatables.ItemTable <init>WARNING: data error on item: java.lang.NullPointerException	at net.sf.l2j.gameserver.datatables.ItemTable.readArmor(ItemTable.java:493)	at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:252)	at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:210)	at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:215)	at net.sf.l2j.gameserver.GameServer.main(GameServer.java:540)Jul 17, 2009 3:06:45 AM net.sf.l2j.gameserver.skills.DocumentBase parseSEVERE: Error in file C:\Documents and Settings\Daniel\Desktop\Sieghardt Gracia 2\gameserver\data\stats\weapon\0000-0099.xmljava.lang.IllegalStateException: No SQL data for Item ID: 1 - name: Short Sword	at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:124)	at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:98)	at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:89)	at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:156)	at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:125)	at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:354)	at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:210)	at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:215)	at net.sf.l2j.gameserver.GameServer.main(GameServer.java:540)Jul 17, 2009 3:06:45 AM net.sf.l2j.gameserver.skills.DocumentBase parseSEVERE: Error in file C:\Documents and Settings\Daniel\Desktop\Sieghardt Gracia 2\gameserver\data\stats\weapon\0100-0199.xmljava.lang.IllegalStateException: No SQL data for Item ID: 100 - name: Voodoo Doll	at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:124)	at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:98)	at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:89)	at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:156)	at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:125)	at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:354)	at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:210)	at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:215)	at net.sf.l2j.gameserver.GameServer.main(GameServer.java:540)

Posted: **Fri Jul 17, 2009 11:01 am**

you didnt load database with data or you have connection to wrong database

Posted: **Fri Jul 17, 2009 12:01 pm**

Database is pointing to the correct one since the XML's are the only error. Its loading everything else fine.

Database name = sieghardtgracia

server.properties

Code: Select all

# ---------------------------------------------------------------------------# Database# ---------------------------------------------------------------------------# Uncomment the appropriate driver and url for the database you're using. If you don't know what this is... http://www.google.comDriver = com.mysql.jdbc.Driver#Driver = org.hsqldb.jdbcDriver#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriverURL = jdbc:mysql://localhost/sieghardtgracia#URL = jdbc:hsqldb:hsql://localhost/l2jdb#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password = #Database user info (using root user is not recommended)Login = ***REMOVED***Password = ***REMOVED ***

Here is a pic of the data in the appropiate database

Posted: **Fri Jul 17, 2009 12:21 pm**

DOuble post sorry, but here goes.... The current database im working on is a upgrade from a Hellbound database with custom items and custom SQL data converted to work with Gracia Part 2.

After the last post i decided to load a clean install of the Gracia Part 2 tables (sql folder).... Started the server and it started 100% fine with no errors. The data files were not changed!! So i can guess it rule out XML problems.... Only thing that changed is the SQL database. The hellbound database i was trying to update loaded everything except the errors i posted above (Not loading any weapon XML's)... I even ran the upgraded Hellbound Server/Database with a default Weapon table, default XML files with no success and still the same XML errors..... Is there any other table besdies the weapon tables that could stop XML's file from loading? If so, please let me know. Thank you for your help.

L2J Server

XML's Not loading?

XML's Not loading?

Re: XML's Not loading?

Re: XML's Not loading?

Re: XML's Not loading?