a zone.Exe error

Magoth78 · #1 10-03-2004, 10:47 PM

Heya there,

i've sourced any *aa*.sql and the alt_adv sql file on CVS in my DB. The zone does not crash but I get this error :

Code:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.9-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] 169 commands loaded
[Status] Loading embedded perl
[Status] Loading perlemb plugins.
Map ./Maps/rivervale.map not found.
[Status] Weather should change in 3394 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 19; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for rivervale ...
[Status] Done loading doors for rivervale ...
Petition 0 pettime = 1096744336
Petition 1 pettime = 1096750979
Petition 3 pettime = 1096775274
Petition 51 pettime = 1096870412
[Status] Zone Bootup: rivervale (19)
Connected to worldserver: localhost:9000
Assigning waypoints for grid 100 to a_rat00...
 done.
Assigning waypoints for grid 100 to a_rat01...
 done.
Assigning waypoints for grid 100 to a_rat02...
 done.
Assigning waypoints for grid 100 to a_rat03...
 done.
Assigning waypoints for grid 100 to a_rat04...
 done.
Assigning waypoints for grid 100 to a_rat05...
 done.
Assigning waypoints for grid 100 to a_rat06...
 done.
Assigning waypoints for grid 100 to a_rat07...
 done.
Assigning waypoints for grid 100 to a_rat08...
 done.
Assigning waypoints for grid 100 to a_rat09...
 done.
Assigning waypoints for grid 100 to a_rat10...
 done.
Assigning waypoints for grid 100 to a_rat11...
 done.
Assigning waypoints for grid 100 to a_rat12...
 done.
Assigning waypoints for grid 100 to a_rat13...
 done.
Assigning waypoints for grid 100 to a_rat14...
 done.
Assigning waypoints for grid 100 to a_rat15...
 done.
Assigning waypoints for grid 100 to a_rat16...
 done.
Assigning waypoints for grid 100 to a_rat17...
 done.
Assigning waypoints for grid 100 to a_rat18...
 done.
Assigning waypoints for grid 100 to a_rat19...
 done.
Assigning waypoints for grid 100 to a_rat20...
 done.
Assigning waypoints for grid 100 to a_rat21...
 done.
[Status] 37531 New client from ip:81.50.178.14 port:3147
[Status] 8. Player profile being converted from the Sep 14th patch now....
[Error] Warning: Invalid PlayerAA_Struct size found in database
DB Query Error #1146: Table 'eq.timers' doesn't exist
Client linkdead: Magoth
Dropping client: Process=false, ip=81.50.178.14, port=3147
[Status] 457672 New client from ip:81.50.178.14 port:3176
[Status] 8. Player profile being converted from the Sep 14th patch now....
[Error] Warning: Invalid PlayerAA_Struct size found in database
DB Query Error #1146: Table 'eq.timers' doesn't exist
Client linkdead: Magoth
Dropping client: Process=false, ip=81.50.178.14, port=3176

At the loading screen, after the char selection, the client gets booted to the server list.

Looks like I get 2 errors, one for the AAs struct and the second says me the timers table is missing wich is true.. I don't see any timers table on my DB...

Any idea?

Thx by advance,
Mag

Arcane · #2 10-04-2004, 12:52 PM

I may be way off on this one, considering I am having a similar issue, though not exactly the same.

Quote:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.9-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 166 commands loaded
[Status] Entering sleep mode
Connected to worldserver: faustserver:9000
Map ./Maps/neriaka.map not found.
[Status] Weather should change in 5604 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 40; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for neriaka ...
[Status] Done loading doors for neriaka ...

I believe this to be a database issue and I am currently trying to piece together an answer by searching the forums.

Malignus Wingnut · #3 10-04-2004, 01:30 PM

With regards to your above error (first post), try sourcing aa_Timers.sql (you can get this from the cvs repository)

Arcane · #4 10-04-2004, 02:47 PM

Aren't there three other sql files needed?

I started from scratch with a guide and completely wrecked my database; but the zones weren't working right from the get go.

govtcheeze · #5 10-04-2004, 06:34 PM

Quote:

DB Query Error #1146: Table 'eq.timers' doesn't exist

Read your errors...the answer is right there. Find the sql for eq.timers and source it in.