Skip to content

Teleport

Featured Replies

Hello,im getting an error when im trying to teleport,any solution?

Jan 05, 2014 7:20:15 PM com.l2jserver.gameserver.datatables.TeleportLocationTable reloadAll
SEVERE: 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:3562)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at com.l2jserver.gameserver.datatables.TeleportLocationTable.reloadAll(TeleportLocationTable.java:59)
	at com.l2jserver.gameserver.datatables.TeleportLocationTable.<init>(TeleportLocationTable.java:47)
	at com.l2jserver.gameserver.datatables.TeleportLocationTable.<init>(TeleportLocationTable.java:34)
	at com.l2jserver.gameserver.datatables.TeleportLocationTable$SingletonHolder.<clinit>(TeleportLocationTable.java:142)
	at com.l2jserver.gameserver.datatables.TeleportLocationTable.getInstance(TeleportLocationTable.java:42)
	at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:290)
	at com.l2jserver.gameserver.GameServer.main(GameServer.java:496)

Your script is trying to get info from a non-existent column of one table. Did you update the source and not the dp or something like that? :D

  • Author

Nop..

Edited by AsatruStaff

So you just downloaded some L2jserver rev and installed it and you have problems? Seems weird. Explain what did you do.

  • Author

So you just downloaded some L2jserver rev and installed it and you have problems? Seems weird. Explain what did you do.

No,i bought the files.

  • Author

xD Then ask to the seller ^^

Is possible to be a mysql error?

The error is somewhere in the files.. the sql file..

 

Dejm, don't buy files from random ppl..

 

Btw, the error happen before or after reload, since as I see you reloaded teleports ? Shut down server, launch it and try again.

Edited by SweeTs

  • Author

The error is somewhere in the files.. the sql file..

 

Dejm, don't buy files from random ppl..

 

Btw, the error happen before or after reload, since as I see you reloaded teleports ? Shut down server, launch it and try again.

:/ where is possible to be the "error" into the "files"?

  • Author

By the way,the "Teleport" table into the database doesnt have fornoble option,it only have

 

name id locx locy locz price

 

shouldnt it be like "name id locx locy locz price fornoble"?

Edited by AsatruStaff

Ye the table is missing that column, but we dunno if its just missing coz your "reload" script isn't well done or is the table that's wrong, get it? Ask to the seller.

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.