Big Problem with Msql

[Michalis]

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

Hello i have a big problem i updated my datapack to the latest revision and after that i can't login to the server please i need help because the server its live and many pepole has disapointed. here is the picture of the server



http://i47.tinypic.com/mw4p5k.jpg

[janiii]

you probably did not run the (a)utomagic updates in the database installer.

[Michalis]

please can you teach me how to resolve this problem. thank you for your fast responce

[janiii]

if you have separate database for loginserver and gameserver, run this query on 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;

if you have same database for loginserver and gameserver:

[Michalis]

ok i made it myself now i think its ok i can login in to the server, but i have 1 question please in the future not to again make the same mistake, what should I do, ie how to make the correct installation of database to the latest revision. thank you in advance

[jurchiks]

http://l2jserver.com/wiki/Manual_Upgrade