On the issue of SQL updates. I went through these one at a time on Sunday.
Quote:
Originally Posted by Huppy
In the window that pops up, click on the little square with 3 dots [...] to navigate to
the following folder(on your C-Drive: /source/trunk/EQEmuServer/utils/sql/svn/
*Note*
You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)
|
The 1711_account_restricted.sql is the only one with a rev prior to the DB (1751) that you need to source in. And as Huppy noted you need to remove the first line. So your file should look like this.
Code:
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
After going through them all one at a time and figuring out that I only needed 1711, I dropped the database and resourced and only ran 1711 + >1751 updates and the server seems to be running fine.