PEQDB Error??

[ardianko]

Hi guys im getting this error when i try to source my sql file that i extracted right after with winrar. any suggestions on how i can fix this?



Thanks in advance

[ardianko]

Ive also realized that this may be because my path was C:\Peqdb_Peq_Db , i had ran those commands when there 2 peqdb folders inside eachother, copied the files into one folder and it became C:\peqdb , and its still giving me the same thing now, mabye its because i created database peq; when i had those 2 folders in eachother ?

[erik_llewellyn]

Try typing in the whole address of "source c:\peqdb\peqdb_1106.sql". Just because you \u in mysql, doesn't change the directory for when you try and open files, it just changes the DB.

[ardianko]

god bless you ;p works now thanks alot hehe

[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 ;

[erik_llewellyn]

Your address line is wrong. how you have it now would be if you were using minilogin, but your loginserver is listed as eqemulator.net. If you are trying to host it via public login server, then the address line MUST be the IP your cable/dsl modem is using, NOT a private IP such as 192.168.xxx.xxx.

Example:
<address>12.345.6.78</address>
<localaddress>192.168.5.15</localaddress>

[ardianko]

how would i figure out the IP my cable/dsl modem is using then? is my localaddress correct? Will this correct my sourcing problem ?

[dierks]

Not sure if this will help, but I ran across a similar issue with the variables table not being there. When I sourced load_player.sql MySQL errored on me. I checked my PEQ database and noticed it didn't follow through all the source files listed in load_player.sql. I matched up and found that it had stopped on name_filter.sql. I then removed this from load_player.sql and re-sourced it with no error.