Trouble with zones

[ghanja]

Originally Posted by trevius

Also, you increased your zone count in your launcher table and forwarded the ports in your router, but did you also increase your port range in your server config file to match?

To add to that, once you ensure the following:

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

Port range allows for enough ports are open to match the number of zones being used (or planned to be used), I personally wouldn't forward any more ports than necessary. You stated you had set ports 7000-8000 in your port forwarding.. that's excessive, unless of course you plan to have 1000 zones open.

Reduce the security risk, 100 ports (i.e. open zones & instanced zones) should very likely be plenty. (7000-7099 for example)

[Bandor]

my config has 400 ports set aside for zones

<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->
<!-- <ports low="7000" high="7100"/> -->
<ports low="7000" high="7400"/>
</zones>

Also will close un-needed ports when issue is resolved,mainly opened them to try to figure this out

World.exe said everything was up to date. Wife decided to restart the pc while I was sleeping and now I can No longer connect to mysql or load the server for whatever reason.

[Bandor]

Ok fixed the DB connection issue,world.exe is saying the following upon boot up

[Status] Using database 'peq' at 127.0.0.1:3306

[MYSQL ERR] 1050: Table 'character_corpse_items' already exists [Query]:
CREATE TABLE `character_corpse_items` (   `corpse_id` int(11) unsigned NOT NULL,
                  `equip_slot` int(11) unsigned NOT NULL,         `item_id` int(
11) unsigned DEFAULT NULL,        `charges` int(11) unsigned DEFAULT NULL,
  `aug_1` int(11) unsigned DEFAULT '0',           `aug_2` int(11) unsigned DEFAU
LT '0',           `aug_3` int(11) unsigned DEFAULT '0',           `aug_4` int(11
) unsigned DEFAULT '0',           `aug_5` int(11) unsigned DEFAULT '0',
  `aug_6` int(11) unsigned DEFAULT '0',           `attuned` smallint(5) NOT NULL
 DEFAULT '0',  PRIMARY KEY(`corpse_id`, `equip_slot`)             ) ENGINE = Inn
oDB DEFAULT CHARSET = latin1;


[MYSQL ERR] 1050: Table 'character_corpses' already exists [Query]:
RENAME TABLE `player_corpses` TO `character_corpses`


[MYSQL ERR] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses' [Query]
:
 ALTER TABLE `character_corpses`


 ADD COLUMN `is_locked`                    tinyint(11) NULL DEFAULT 0 AFTER `Was
AtGraveyard`,
 ADD COLUMN `exp`                              int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `size`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `level`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `race`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `gender`                int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `class`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `deity`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `texture`               int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `helm_texture`          int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `copper`                int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `silver`                int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `gold`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `platinum`              int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `hair_color`            int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `beard_color`           int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `eye_color_1`           int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `eye_color_2`           int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `hair_style`            int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `face`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `beard`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `drakkin_heritage`      int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `drakkin_tattoo`        int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `drakkin_details`       int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `wc_1`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_2`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_3`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_4`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_5`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_6`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_7`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_8`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_9`                         int(11) UNSIGNED NULL DEFAULT 0,


 CHANGE COLUMN `zoneid` `zone_id`  smallint(5) NOT NULL DEFAULT 0 AFTER `charnam
e`,
 CHANGE COLUMN `instanceid` `instance_id`  smallint(5) UNSIGNED NOT NULL DEFAULT
 0 AFTER `zone_id`,
 CHANGE COLUMN `timeofdeath` `time_of_death`  datetime NOT NULL DEFAULT '0000-00
-00 00:00:00' AFTER `data`,
 CHANGE COLUMN `rezzed` `is_rezzed`  tinyint(3) UNSIGNED NULL DEFAULT 0 AFTER `t
ime_of_death`,
 CHANGE COLUMN `IsBurried` `is_buried`  tinyint(3) NOT NULL DEFAULT 0 AFTER `is_
rezzed`;



[MYSQL ERR] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses' [Query]
:
 ALTER TABLE `character_corpses`


 CHANGE COLUMN `WasAtGraveyard` `was_at_graveyard`  tinyint(3) NOT NULL DEFAULT
0 AFTER `is_buried`


Pulling down automatic database upgrade script...

No update necessary
Perl Version is 5.12.3
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
============================================================
           EQEmu: Automatic Database Upgrade Check
============================================================
        Operating System is: MSWin32
        (Windows) MySQL is in system path
        Path = C:\xampp\mysql\bin/mysql
============================================================
        Binary Database Version: (9066)
        Local Database Version: (9066)

        Database up to Date: Continuing World Bootup...
============================================================

[MYSQL ERR] 1932: Table 'peq.group_leaders' doesn't exist in engine [Query]:
DELETE from group_leaders

Unable to clear group leaders: #1932: Table 'peq.group_leaders' doesn't exist in
 engine

Was not getting the table errors before the DB connection issue so not sure what is going on there now. When I updated my source I did select option 3,two times once to check for updates then to update. That is all I did,was I suppose to source anything in? Everything was working fine when I first updated.

[trevius]

I am not sure what happened when you PC was restarted, but it looked like your DB has some major issues with missing tables and such. If you have a full DB backup from before the updates, I would suggest reverting to it. Otherwise, it may be a pain to get whatever is missing in your tables restored manually.

[Bandor]

Would u suggest reudating after I revert to the old DB? Really dont wanna have to abandon ornaments and such.... Have done quit a good bit of db work that I would really prefer not to loose lol....didn't have any missing tables until I installed the repack (apearntly I had screwed up SQL somehow),installing a fresh repack fixed that problem but now the missing fields and the zone problem still remains.

[Bandor]

Its just odd,when I check Heidi for the stuff that is claimed to be missing,i see all the rows and columns that are 'missing' so it seems its getting a miss connection somewhere. The initial cmd prompt (win32 -standard cmd prompt) Says something about a missing string in MariaDB or something,It just fades so fast its hard to get a copy before it poofs. So it appears,to my very very limited knowledge,to be a syncing issue or something of the sort.

[Scorpious2k]

Maybe you should try repairing the tables before going for a restore.

[Bandor]

Issues getting worse,wont even let me source my latest backups,going to attempt to recover atleast a piece of the server will see what happens lol.

[Scorpious2k]

Did you run a repair on all the tables? I've found that often when the server can't "find" a table and it shows in other places as being there, it is broken and the server just can't get to it until it is repaired. That's why I suggested it above.

[Bandor]

Got a ton of errors,says it wont allow command access.

[Bandor]

Reran from different account now getting a few errors,stuff saying curropt or doesnt exist in engine,missing string,etc. Most files look fine though

SQL Error (1030): Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM

SQL Error (1932): Table 'peq.player_corpses' doesn't exist in engine

Seems those are the problems. Wont let me repair them either.