L2J Server

Posted: **Sun Oct 24, 2010 3:43 pm**

Hey guys.
Im having some troubles Using gatekeeper at my server.
Any gatekeeper, from custom, to regular in any town, with any char [gm/regular] , i just cant teleport.
I try to teleport to a town and gives nothing, checking the gameserver console and it gives back:
No teleport destination with id:*******
Please guys, Im realy upset about it. It's kinda my last NPC for my server.
When i reload npc table, i get this error:

Code: Select all

Error loading Teleport Table.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'fornoble' 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:409)        at com.mysql.jdbc.Util.getInstance(Util.java:384)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.datatables.TeleportLocationTable.reloadAll(TeleportLocationTable.java:59)        at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:161)        at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:111)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:973)        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source) No teleport destination with id:1057

Posted: **Sun Oct 24, 2010 4:16 pm**

Column missing in teleport table if you take the time to read the error it tells you this

Posted: **Sun Oct 24, 2010 8:17 pm**

hope wrote:Column missing in teleport table if you take the time to read the error it tells you this

I realy cant understand it, or you.
I tried reading again and again and again, but I still have no clue :X
I attached my Teleport.sql, i hope you can help me

Posted: **Sun Oct 24, 2010 8:28 pm**

so, now we are here:

- wrong section (topic moved to support as this is not a custom mod request!)
- no info about revisions

check that you have the table for your revision installed and not an older one or from some other fork! the column fornoble is in l2j for some years already, so you messed something up or you just use some other emulator!

this is the latest teleport.sql for freya: http://svn.l2jdp.com/trunk/datapack_dev ... leport.sql

Posted: **Sun Oct 24, 2010 8:51 pm**

returNix wrote:
hope wrote:Column missing in teleport table if you take the time to read the error it tells you this
I realy cant understand it, or you.
I tried reading again and again and again, but I still have no clue :X
I attached my Teleport.sql, i hope you can help me

This is not Teleport.sql at all this is Teleport.txt

Posted: **Sun Oct 24, 2010 9:07 pm**

Hitokiri wrote:
returNix wrote:
hope wrote:Column missing in teleport table if you take the time to read the error it tells you this
I realy cant understand it, or you.
I tried reading again and again and again, but I still have no clue :X
I attached my Teleport.sql, i hope you can help me
This is not Teleport.sql at all this is Teleport.txt

Yep, a mistake.
Here is the sql.
Janii, i will try your idea.
Edit: Yanii , working perfectly! THANKS

Posted: **Sun Oct 24, 2010 9:46 pm**

returNix wrote:
hope wrote:Column missing in teleport table if you take the time to read the error it tells you this
I realy cant understand it, or you.
I tried reading again and again and again, but I still have no clue :X
I attached my Teleport.sql, i hope you can help me

If you really don't understand what I said then you really don't have a clue. I could not make it any clearer

L2J Server

Wrong Destination ID with any gatekeeper.

Wrong Destination ID with any gatekeeper.

Re: Wrong Destination ID with any gatekeeper.

Re: Wrong Destination ID with any gatekeeper.

Re: Wrong Destination ID with any gatekeeper.

Re: Wrong Destination ID with any gatekeeper.

Re: Wrong Destination ID with any gatekeeper.

Re: Wrong Destination ID with any gatekeeper.