Help Teleport

[AsatruStaff]

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)

[^Wyatt]

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

[AsatruStaff]

Nop..

Edited January 5, 2014 by AsatruStaff

[^Wyatt]

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

[AsatruStaff]

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.

[^Wyatt]

No,i bought the files.

xD Then ask to the seller ^^

[AsatruStaff]

xD Then ask to the seller ^^

Is possible to be a mysql error?

[SweeTs]

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 January 5, 2014 by SweeTs

[AsatruStaff]

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"?

[AsatruStaff]

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 January 5, 2014 by AsatruStaff

[^Wyatt]

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.