L2J Server

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 3923:
L2JDP Revision 7052:

the error is this:
2010.02.09 13:12:34,038 WARNING 12 com.l2jserver.loginserver.LoginController Could not check password:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'userIP' in 'field list'

when exactly did this happen? does it happen for multiple chars or just this once?

you must update your accounts table in database, so it can match the new columns

Probe wrote:when exactly did this happen? does it happen for multiple chars or just this once?

Do not let anyone enter, just update and when I lifted the server, nobody can enter the login and it gives me.

update your loginserver database:

janiii wrote:update your loginserver database:

Code: Select all

ALTER TABLE `accounts` ADD  `userIP` char(15) DEFAULT NULL;ALTER TABLE `accounts` ADD  `pcIp` char(15) DEFAULT NULL;ALTER TABLE `accounts` ADD  `hop1` char(15) DEFAULT NULL;ALTER TABLE `accounts` ADD  `hop2` char(15) DEFAULT NULL;ALTER TABLE `accounts` ADD  `hop3` char(15) DEFAULT NULL;ALTER TABLE `accounts` ADD  `hop4` char(15) DEFAULT NULL;

Ty janiii

why this update not commited?

it is commited, but i think it doesnt run when loginserver has a different database than gameserver. only posted here the sql query, so that he can run it .

sorry, my fault. didn't noticed and yes it don't apply automatically.