LoginServer Error

[DeVe]

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'

[Probe]

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

[BiggBoss]

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

[DeVe]

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.

[janiii]

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;

[DeVe]

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

[denser]

why this update not commited?

[janiii]

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 .

[denser]

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