L2J Server

Posted: **Wed May 27, 2009 8:12 pm**

L2J Revision 3074:
L2JDP Revision 6133:

Okay, if i'm trying to connect to my server, i can see Bartz on login screen. But can't log into the server from there.

Every GameGuard-realtet thing is False, ByPass validation on True ( maybe a security thing ..)

There is no error-msg relatet to this, just something about a 'time' - column, for me without infos^^
Maybe someone can get the problem with it:

Code: Select all

May 27, 2009 7:51:07 PM net.sf.l2j.gameserver.model.itemcontainer.ItemContainer restoreWARNING: could not restore container:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'time' in 'field list'    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)    at com.mysql.jdbc.Util.getInstance(Util.java:381)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)    at net.sf.l2j.gameserver.model.itemcontainer.ItemContainer.restore(ItemContainer.java:603)    at net.sf.l2j.gameserver.model.L2Clan.<init>(L2Clan.java:180)    at net.sf.l2j.gameserver.datatables.ClanTable.<init>(ClanTable.java:90)    at net.sf.l2j.gameserver.datatables.ClanTable.getInstance(ClanTable.java:64)    at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:256)    at net.sf.l2j.gameserver.GameServer.main(GameServer.java:544)

Posted: **Wed May 27, 2009 8:45 pm**

because of the 'time' column - update your database.. probably your server files are not from the same date as datapack files and db installation.

Posted: **Wed May 27, 2009 9:14 pm**

Okay, no Startup-errors anymore. But still noone can Login :S

Anyone an idea?

Posted: **Thu May 28, 2009 9:22 am**

Gameserver send to login wrong address. Clients unable to connect on this address.

Posted: **Thu May 28, 2009 11:12 am**

I have a similar problem. I enter my account id and password and when I press login it gives me the following error

Code: Select all

Account is already in use. Unable to log in,

Posted: **Thu May 28, 2009 12:47 pm**

You can logon again after this. I get the same error if i retry anything.

I'll re-check the IPs again. The Serber seems to be online with a Ping of 9999 .. But noone can say why :S

Posted: **Thu May 28, 2009 6:54 pm**

Well that's what I thought as well, but no matter how many times I try to log in, I get the same error again and again...

Posted: **Sat May 30, 2009 1:18 pm**

ok first of all run this sql query:

UPDATE `Characters` set `online` = 0 WHERE `online` = 1;

So now we are sure that the Server mustn't think someone is online.

register new Gameserver to login (Bartz)
be sure to have entered the right Ips in right place:

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
# Common settings...
# 127.0.0.1 - If you are playing alone on a test server
# 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect
# x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server.
# If this IP is resolvable by the Login Server, just leave *.
# ---------------------------------------------------------------------------
# Default: *
ExternalHostname = *

go to http://www.whatismyip.com and enter the ip shown there to:

ExternalHostname = *

and forward port 777 to server machine (Router config)

Posted: **Tue Jun 02, 2009 3:50 am**

Already done, thanks for the help, but i had messed the login files while updating my server... All ok now.

L2J Server

Login-failutr without error

Login-failutr without error

Re: Login-failutr without error

Re: Login-failutr without error

Re: Login-failutr without error

Re: Login-failutr without error

Re: Login-failutr without error

Re: Login-failutr without error

Re: Login-failutr without error

Re: Login-failutr without error