Wrong Destination ID with any gatekeeper.

[returNix]

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

[hope]

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

[returNix]

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

[janiii]

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

[Hitokiri]

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

[returNix]

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

[hope]

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