Problems I ran into and resolutions.

[kai4785]

$ mysql --version
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i386) using readline 5.0

5.0.45 it looks like.

I think I caught it. It looks like zones are crashing, and when they get restarted, they wipe out their log files. I started the world, let it sit for about 10 minutes, and didn't try to do anything. When I logged into the server, and tried to zone in, I got the following:

==> eqemu_debug_world.log <==
32336 [10.12. - 18:04:44] [WORLD__CLIENT] kai4785: Attempting autobootup of rivervale (19)
32336 [10.12. - 18:04:44] [WORLD__CLIENT_ERR] kai4785: No zoneserver available to boot up.

==> eqemu_debug_32351.log <==
[10.12. - 18:04:55] [LAUNCHER__STATUS] Zone dynamic_01 has gone down. Restart timer started.

==> eqemu_debug_world.log <==
32336 [10.12. - 18:04:55] [WORLD__LAUNCH] zones: dynamic_01 reported state STOPPED (2 starts)

==> eqemu_debug_zone.log <==
32366 [10.12. - 18:04:55] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> zone-dynamic_01.log <==
[Debug] [ZONE__INIT] Loading npc faction lists
Error: EMuShareMem: DLLLoadNPCFactionLists: !NPCFactionListsMMF.IsLoaded() (timeout)
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> eqemu_debug_32351.log <==
[10.12. - 18:05:07] [LAUNCHER__STATUS] Starting zone dynamic_01
[10.12. - 18:05:07] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[10.12. - 18:05:07] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.

==> eqemu_debug_world.log <==
32336 [10.12. - 18:05:07] [WORLD__LAUNCH] zones: dynamic_01 reported state STARTED (3 starts)

==> eqemu_debug_zone.log <==
---------------------------------------------
32492 [10.12. - 18:05:07] Starting Log: logs/eqemu_debug_zone.log
32492 [10.12. - 18:05:07] [RULES__CHANGE] Resetting running rules to default values
32492 [10.12. - 18:05:07] [ZONE__INIT] Loading server configuration..
32492 [10.12. - 18:05:07] [ZONE__INIT] Log settings loaded from log.ini
32492 [10.12. - 18:05:07] [ZONE__INIT] Connecting to MySQL...
32492 [10.12. - 18:05:07] [COMMON__THREADS] Starting DBAsyncLoop with thread ID -1211192432
32492 [10.12. - 18:05:07] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
32492 [10.12. - 18:05:07] [ZONE__INIT] Log settings loaded from ./log.ini
32492 [10.12. - 18:05:07] [ZONE__INIT] Mapping Incoming Opcodes
32492 [10.12. - 18:05:07] [ZONE__INIT] Loading Variables
32492 [10.12. - 18:05:07] [ZONE__INIT] Loading zone names
32492 [10.12. - 18:05:07] [ZONE__INIT] Loading items

==> eqemu_zone.log <==
---------------------------------------------
32492 [10.12. - 18:05:07] Starting Log: logs/eqemu_zone.log
32492 [10.12. - 18:05:07] Using database 'peq' at localhost:3306
32492 [10.12. - 18:05:07] libEMuShareMem.so loaded
tail: zone-dynamic_01.log: file truncated

==> eqemu_debug_zone.log <==
32492 [10.12. - 18:05:07] [ZONE__INIT] Loading npc faction lists

==> eqemu_debug_32351.log <==
[10.12. - 18:05:15] [LAUNCHER__STATUS] Zone dynamic_02 has gone down. Restart timer started.

==> eqemu_debug_world.log <==
32336 [10.12. - 18:05:15] [WORLD__LAUNCH] zones: dynamic_02 reported state STOPPED (1 starts)

==> eqemu_debug_zone.log <==
32376 [10.12. - 18:05:15] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> zone-dynamic_02.log <==
[Debug] [ZONE__INIT] Loading npc faction lists
Error: EMuShareMem: DLLLoadNPCFactionLists: !NPCFactionListsMMF.IsLoaded() (timeout)
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> eqemu_debug_32351.log <==
[10.12. - 18:05:17] [LAUNCHER__STATUS] Zone dynamic_03 has gone down. Restart timer started.

==> eqemu_debug_world.log <==
32336 [10.12. - 18:05:17] [WORLD__LAUNCH] zones: dynamic_03 reported state STOPPED (1 starts)

==> eqemu_debug_zone.log <==
32380 [10.12. - 18:05:17] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> zone-dynamic_03.log <==
[Debug] [ZONE__INIT] Loading npc faction lists
Error: EMuShareMem: DLLLoadNPCFactionLists: !NPCFactionListsMMF.IsLoaded() (timeout)
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> eqemu_debug_32351.log <==
[10.12. - 18:05:19] [LAUNCHER__STATUS] Zone dynamic_04 has gone down. Restart timer started.

==> eqemu_debug_world.log <==
32336 [10.12. - 18:05:19] [WORLD__LAUNCH] zones: dynamic_04 reported state STOPPED (1 starts)

==> eqemu_debug_zone.log <==
32383 [10.12. - 18:05:19] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> zone-dynamic_04.log <==
[Debug] [ZONE__INIT] Loading npc faction lists
Error: EMuShareMem: DLLLoadNPCFactionLists: !NPCFactionListsMMF.IsLoaded() (timeout)
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> eqemu_debug_32351.log <==
[10.12. - 18:05:21] [LAUNCHER__STATUS] Zone dynamic_05 has gone down. Restart timer started.

==> eqemu_debug_world.log <==
32336 [10.12. - 18:05:21] [WORLD__LAUNCH] zones: dynamic_05 reported state STOPPED (1 starts)

==> eqemu_debug_zone.log <==
32387 [10.12. - 18:05:21] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> zone-dynamic_05.log <==
[Debug] [ZONE__INIT] Loading npc faction lists
Error: EMuShareMem: DLLLoadNPCFactionLists: !NPCFactionListsMMF.IsLoaded() (timeout)
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

==> eqemu_debug_32351.log <==
[10.12. - 18:05:27] [LAUNCHER__STATUS] Starting zone dynamic_02
[10.12. - 18:05:27] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[10.12. - 18:05:27] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.

==> eqemu_debug_world.log <==
32336 [10.12. - 18:05:27] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (2 starts)

==> eqemu_debug_zone.log <==
---------------------------------------------
32503 [10.12. - 18:05:27] Starting Log: logs/eqemu_debug_zone.log
32503 [10.12. - 18:05:27] [RULES__CHANGE] Resetting running rules to default values
32503 [10.12. - 18:05:27] [ZONE__INIT] Loading server configuration..
32503 [10.12. - 18:05:27] [ZONE__INIT] Log settings loaded from log.ini
32503 [10.12. - 18:05:27] [ZONE__INIT] Connecting to MySQL...
32503 [10.12. - 18:05:27] [COMMON__THREADS] Starting DBAsyncLoop with thread ID -1211274352
32503 [10.12. - 18:05:27] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
32503 [10.12. - 18:05:27] [ZONE__INIT] Log settings loaded from ./log.ini
32503 [10.12. - 18:05:27] [ZONE__INIT] Mapping Incoming Opcodes
32503 [10.12. - 18:05:27] [ZONE__INIT] Loading Variables
32503 [10.12. - 18:05:27] [ZONE__INIT] Loading zone names
32503 [10.12. - 18:05:27] [ZONE__INIT] Loading items

==> eqemu_zone.log <==
---------------------------------------------
32503 [10.12. - 18:05:27] Starting Log: logs/eqemu_zone.log
32503 [10.12. - 18:05:27] Using database 'peq' at localhost:3306
32503 [10.12. - 18:05:27] libEMuShareMem.so loaded

[Angelox]

I ment what database as in PEQ (and version or where you got it), AX_CLASSIC, EQ

[kai4785]

peq-luclin-release
From http://projecteq.net/downloads.php
I've also tried the peq-ykesha-beta1 database. both are behaving identically.

[Angelox]

Use the newest, I think is peq-ykesha-beta1 database then get the newest source, and read the logs posted there, there's still at least one update you have to make, I think;

Required SQL:

alter table npc_faction add column ignore_primary_assist tinyint(3) not null default 0;

And don't forget to use the newest opcodes

[kai4785]

Where did you find the updates? I don't see where you want me to go get new opcodes either...

I got further though. It doesn't pop the error right away, and it looks like my client is busy loading, but logs show:

[Status] Booting rivervale
Map header: 21658 faces, 217 nodes, 29875 facelists
Loaded map: 64974 vertices, 21658 faces
Map BB: (-673.72 -> 203.91, -431.81 -> 511.78, -47.97 -> 599.75)
Map ./Maps/rivervale.map loaded.
Path File ./Maps/rivervale.path not found.
[Debug] The next weather check for zone: rivervale will be in 5660 seconds.
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.trackable' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for rivervale ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Error] Error in GetAASkillVars 'SELECT cost, max_level, hotkey_sid, hotkey_sid2, title_sid, desc_sid, type, prereq_skill, prereq_minpoints, spell_type, spell_refresh, classes, berserker,spellid,class_type,name,cost_inc FROM altadv_vars WHERE skill_id=2': #1054: Unknown column 'cost_inc' in 'field list'
tail: zone-dynamic_05.log: file truncated

Then it spits the same error to my client again.

[kai4785]

http://projecteq.net/phpBB2/viewtopi...9ca262804e9b8d

This is exactly my problem here as well.

Do you have a link for me to download your Database Angelox? I tried looking, but couldn't find the link.

[kai4785]

http://projecteq.net/phpBB2/viewtopi...9ca262804e9b8d

found it here....

I'm in!

alter table altadv_vars add column cost_inc tinyint(4) not null default 0;

Needed to run just that one sql statement.

Ok I'm going to rebuild from source and write up a walkthrough.