PEQDB Error??

[ardianko]

but now ive been hit with another probem when i run my start.bat =/

[erik_llewellyn]

check your eqemu_config.xml file. It sounds like you don't have the right user/password/DB being assigned in it. If you used cavedude's installer pack4, the eqemu_config.xml file is wrong as it lists the db as "eq" by default instead of the actual database it makes which is "peq".

It should read something like:

<?xml version="1.0">
<server>
<world>
<shortname>Birthright [PEQ-Custom All Spells and Items]</shortname>
<longname>Birthright [PEQ-Custom All Spells and Items]</longname>

<address>WAN IP</address>
<localaddress>LAN IP</localaddress>

<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<key>12345678</key>

<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>what ever you made it during MySQL setup</password>
<db>peq</db>
</database>
</server>

[ardianko]

Nope did all of that stuff correctly ,but there are 2 files ... eqemu_config(XML document) and eqemu_config.xml.full (FULL document) can this be my problem?
EDIT:: deleted the eqemu full file as it had stupid unnecessary information in it. Start.bat still gives me the same errors

[ardianko]

some other logs

---------------------------------------------
[04.19. - 12:31:50] Starting Log: logs/eqemu_debug_world_3476.log
[04.19. - 12:31:50] [WORLD__INIT] Loading server configuration..
[04.19. - 12:31:50] [WORLD__INIT] Log settings loaded from log.ini
[04.19. - 12:31:50] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[04.19. - 12:31:50] [WORLD__INIT] Connecting to MySQL...
[04.19. - 12:31:50] [WORLD__INIT] Starting HTTP world service...
[04.19. - 12:31:50] [WORLD__HTTP] Loaded mime types from mime.types
[04.19. - 12:31:50] [WORLD__INIT] Loading variables..
[04.19. - 12:31:50] [WORLD__INIT] Loading zones..
[04.19. - 12:31:50] [WORLD__INIT] Clearing groups..
[04.19. - 12:31:50] [WORLD__INIT] Clearing temporary merchant lists..
[04.19. - 12:31:50] [WORLD__INIT] Loading items..
[04.19. - 12:32:20] [WORLD__INIT] Loading guilds..
[04.19. - 12:32:20] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus, motd, motd_setter FROM guilds': #1146: Table 'peq.guilds' doesn't exist
[04.19. - 12:32:20] [RULES__ERROR] Failed to find ruleset 'default' for load operation. Canceling.
[04.19. - 12:32:20] [WORLD__INIT] No rule set configured, using default rules
[04.19. - 12:32:20] [WORLD__INIT] Loading EQ time of day..
[04.19. - 12:32:20] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[04.19. - 12:32:20] [WORLD__INIT] Loading launcher list..
[04.19. - 12:32:20] [WORLD__INIT] Reboot zone modes OFF
[04.19. - 12:32:20] [WORLD__INIT] Deleted -1 stale player corpses from database
[04.19. - 12:32:20] [WORLD__INIT] Deleted -1 stale player backups from database
[04.19. - 12:32:20] [WORLD__INIT] Zone (TCP) listener started.
[04.19. - 12:32:20] [WORLD__INIT] Client (UDP) listener started.
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch 6.2
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch Titanium
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch Anniversary
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch Live
[04.19. - 12:32:20] [WORLD__LS] Connecting to login server...
[04.19. - 12:32:20] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[04.19. - 12:32:21] [WORLD__LS] Loginserver provided 69.118.154.199 as world address
[04.19. - 12:33:36] [WORLD__ZONE] New TCP connection from 127.0.0.1:2425
[04.19. - 12:33:36] [WORLD__CONSOLE] New launcher from 127.0.0.1:2425
[04.19. - 12:33:36] [WORLD__LAUNCH] Adding pending launcher 1
[04.19. - 12:33:36] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[04.19. - 12:33:36] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[04.19. - 12:33:36] [WORLD__LAUNCH] Removing launcher zone (1)
[04.19. - 12:33:51] [WORLD__ZONE] New TCP connection from 127.0.0.1:2429
[04.19. - 12:33:51] [WORLD__CONSOLE] New launcher from 127.0.0.1:2429
[04.19. - 12:33:51] [WORLD__LAUNCH] Adding pending launcher 2
[04.19. - 12:33:56] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[04.19. - 12:33:56] [WORLD__LAUNCH] Removing pending launcher 2. Adding zone to active list.
[04.19. - 12:33:56] [WORLD__LAUNCH] Removing launcher zone (2)
[04.19. - 12:34:06] [WORLD__ZONE] New TCP connection from 127.0.0.1:2441
[04.19. - 12:34:06] [WORLD__CONSOLE] New launcher from 127.0.0.1:2441
[04.19. - 12:34:06] [WORLD__LAUNCH] Adding pending launcher 3
[04.19. - 12:34:11] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[04.19. - 12:34:11] [WORLD__LAUNCH] Removing pending launcher 3. Adding zone to active list.
[04.19. - 12:34:11] [WORLD__LAUNCH] Removing launcher zone (3)
[04.19. - 12:34:21] [WORLD__ZONE] New TCP connection from 127.0.0.1:2454
[04.19. - 12:34:21] [WORLD__CONSOLE] New launcher from 127.0.0.1:2454
[04.19. - 12:34:21] [WORLD__LAUNCH] Adding pending launcher 4

[cavedude]

You're missing your player tables, be sure to source load_player.sql as well.

[ardianko]

k went back opened up mysql commandline and pathed to my peqdb folder and tried to source load_player.sql and this is what happened =/



here is a ss of what my peqdb folder contains ...

[ardianko]

also ... tried sourcing aa_timers.sql independently and this is what happened ...



and for those concerned about the wrong XML writeout ... heres mine ;