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]

  On 1/5/2014 at 6:08 PM, ^Wyatt said:

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]

  On 1/5/2014 at 6:12 PM, AsatruStaff said:

No,i bought the files.

xD Then ask to the seller ^^

[AsatruStaff]

  On 1/5/2014 at 6:15 PM, ^Wyatt said:

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]

  On 1/5/2014 at 6:31 PM, SweeTs said:

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.