L2J Server

Posted: **Fri Feb 19, 2010 9:28 am**

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

Posted: **Fri Feb 19, 2010 9:36 am**

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

Posted: **Fri Feb 19, 2010 9:57 am**

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

Posted: **Fri Feb 19, 2010 10:07 am**

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:

Posted: **Fri Feb 19, 2010 10:41 am**

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

Posted: **Fri Feb 19, 2010 1:05 pm**

http://l2jserver.com/wiki/Manual_Upgrade

L2J Server

Big Problem with Msql

Big Problem with Msql

Re: Big Problem with Msql

Re: Big Problem with Msql

Re: Big Problem with Msql

Re: Big Problem with Msql

Re: Big Problem with Msql