PEQ Server Problems

1magus · #1 12-21-2008, 02:36 AM

I have tried installing my own PEQ server twice now and it has always ended up in errors.
The first time I went through it a tad speedy so this time I decided to completely remove everything and try to follow the PDF guide as slowly and closely as possible, here are the results when I hit Start.bat:

[Debug] Starting Log: logs/eqemu_debug_world_2524.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_2524.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1146: Table 'peq.variables' doesn't exist
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
Unable to clear group leaders: #1146: Table 'peq.group_leaders' doesn't exist
Unable to clear groups: #1146: Table 'peq.group_id' doesn't exist
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54307
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus
, motd, motd_setter FROM guilds': #1146: Table 'peq.guilds' doesn't exist
[Error] Starting Log: logs/eqemu_error_world_2524.log
[Error] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='de
fault': #1146: Table 'peq.rule_sets' doesn't exist
[Debug] [RULES__ERROR] Failed to find ruleset 'default' for load operation. Canc
eling.
[Debug] [WORLD__INIT] No rule set configured, using default rules
[Debug] [WORLD__INIT] Loading EQ time of day..
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Error] WorldDatabase::GetLauncherList: #1146: Table 'peq.launcher' doesn't exis
t
[Debug] [WORLD__INIT] Reboot zone modes OFF
[Debug] [WORLD__INIT] Deleted -1 stale player corpses from database
[Debug] [WORLD__INIT] Deleted -1 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Anniversary
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
[Debug] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[Debug] [WORLD__LS] Loginserver provided 76.176.21.142 as world address
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'

Any help would be appreciated, please help me set up a server I'm begging this forum for help!

ChaosSlayer · #2 12-21-2008, 03:44 AM

well does your Db contains table 'peq.variables' ?

1magus · #3 12-21-2008, 03:08 PM

I don't see any in peq_db, at least as long as they have peq in the name I don't see any.

ChaosSlayer · #4 12-21-2008, 03:44 PM

my only guess that your peq is either old version or incomplite

1magus · #5 12-21-2008, 06:49 PM

Um is there anyway to check?
Anyway to get the files I'm MOST likely missing manually?!

kiirdiir · #6 12-21-2008, 08:19 PM

Quote:

Originally Posted by 1magus

I don't see any in peq_db, at least as long as they have peq in the name I don't see any.

Peq_db? Did you install MySQL and then install the tables? There are also several other steps to get your database working, as stated in the guide.

It looks to me like your problem is that the database or tables do not exist, because you did not properly install the database, or you are not linking the database properly in your eqemu_config.xml.

1magus · #7 12-21-2008, 11:49 PM

Ok let me install these tables and see if I missed any steps.

1magus · #8 12-21-2008, 11:54 PM

I get error 2 when trying to install the tables :(

1magus · #9 12-22-2008, 12:15 AM

New Errors:

mysql> source c:\peq_db\drop_player.sql
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
mysql> \u peq
Database changed
mysql> source c:\peq_db\drop_player.sql
ERROR 1051 (42S02): Unknown table 'aa_timers'
ERROR 1051 (42S02): Unknown table 'account'
ERROR 1051 (42S02): Unknown table 'botinventory'
ERROR 1051 (42S02): Unknown table 'botleader'
ERROR 1051 (42S02): Unknown table 'botsowners'
ERROR 1051 (42S02): Unknown table 'character_'
ERROR 1051 (42S02): Unknown table 'character_backup'
ERROR 1051 (42S02): Unknown table 'commands'
ERROR 1051 (42S02): Unknown table 'eventlog'
ERROR 1051 (42S02): Unknown table 'faction_values'
ERROR 1051 (42S02): Unknown table 'guild_members'
ERROR 1051 (42S02): Unknown table 'guild_ranks'
ERROR 1051 (42S02): Unknown table 'guild_relations'
ERROR 1051 (42S02): Unknown table 'guilds'
ERROR 1051 (42S02): Unknown table 'hackers'
ERROR 1051 (42S02): Unknown table 'inventory'
ERROR 1051 (42S02): Unknown table 'launcher'
ERROR 1051 (42S02): Unknown table 'launcher_zones'
ERROR 1051 (42S02): Unknown table 'name_filter'
ERROR 1051 (42S02): Unknown table 'object_contents'
ERROR 1051 (42S02): Unknown table 'petitions'
ERROR 1051 (42S02): Unknown table 'player_corpses'
ERROR 1051 (42S02): Unknown table 'player_corpses_backup'
ERROR 1051 (42S02): Unknown table 'quest_globals'
ERROR 1051 (42S02): Unknown table 'quest_items'
ERROR 1051 (42S02): Unknown table 'rule_sets'
ERROR 1051 (42S02): Unknown table 'rule_values'
ERROR 1051 (42S02): Unknown table 'sharedbank'
ERROR 1051 (42S02): Unknown table 'timers'
ERROR 1051 (42S02): Unknown table 'variables'
ERROR 1051 (42S02): Unknown table 'zone_flags'
mysql>

kiirdiir · #10 12-23-2008, 12:30 AM

Quote:

Originally Posted by 1magus

New Errors:

mysql> source c:\peq_db\drop_player.sql
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected

That is because you did not select a database first. Follow the guide.

Quote:

Originally Posted by 1magus

mysql> \u peq
Database changed

Good. Keep following the guide.

Quote:

Originally Posted by 1magus

mysql> source c:\peq_db\drop_player.sql
ERROR 1051 (42S02): Unknown table 'aa_timers'
ERROR 1051 (42S02): Unknown table 'account'
ERROR 1051 (42S02): Unknown table 'botinventory'
ERROR 1051 (42S02): Unknown table 'botleader'
ERROR 1051 (42S02): Unknown table 'botsowners'
ERROR 1051 (42S02): Unknown table 'character_'
ERROR 1051 (42S02): Unknown table 'character_backup'
ERROR 1051 (42S02): Unknown table 'commands'
ERROR 1051 (42S02): Unknown table 'eventlog'
ERROR 1051 (42S02): Unknown table 'faction_values'
ERROR 1051 (42S02): Unknown table 'guild_members'
ERROR 1051 (42S02): Unknown table 'guild_ranks'
ERROR 1051 (42S02): Unknown table 'guild_relations'
ERROR 1051 (42S02): Unknown table 'guilds'
ERROR 1051 (42S02): Unknown table 'hackers'
ERROR 1051 (42S02): Unknown table 'inventory'
ERROR 1051 (42S02): Unknown table 'launcher'
ERROR 1051 (42S02): Unknown table 'launcher_zones'
ERROR 1051 (42S02): Unknown table 'name_filter'
ERROR 1051 (42S02): Unknown table 'object_contents'
ERROR 1051 (42S02): Unknown table 'petitions'
ERROR 1051 (42S02): Unknown table 'player_corpses'
ERROR 1051 (42S02): Unknown table 'player_corpses_backup'
ERROR 1051 (42S02): Unknown table 'quest_globals'
ERROR 1051 (42S02): Unknown table 'quest_items'
ERROR 1051 (42S02): Unknown table 'rule_sets'
ERROR 1051 (42S02): Unknown table 'rule_values'
ERROR 1051 (42S02): Unknown table 'sharedbank'
ERROR 1051 (42S02): Unknown table 'timers'
ERROR 1051 (42S02): Unknown table 'variables'
ERROR 1051 (42S02): Unknown table 'zone_flags'
mysql>

That is okay. The drop is failing because the tables do not exist (because you are starting new). If you were updating your database, you would not see the drop failings. So, ignore those errors and continue following the guide.

1magus · #11 12-23-2008, 12:41 AM

Well pretty sure this is not ok :P

mysql> source c:\peq_db\load_player.sql
ERROR:
Failed to open file 'aa_timers.sql', error: 2
ERROR:
Failed to open file 'account.sql', error: 2
ERROR:
Failed to open file 'botinventory', error: 2
ERROR:
Failed to open file 'botleader.sql', error: 2
ERROR:
Failed to open file 'botsowners.sql', error: 2
ERROR:
Failed to open file 'character_.sql', error: 2
ERROR:
Failed to open file 'character_backup.sql', error: 2
ERROR:
Failed to open file 'commands.sql', error: 2
ERROR:
Failed to open file 'eventlog.sql', error: 2
ERROR:
Failed to open file 'faction_values.sql', error: 2
ERROR:
Failed to open file 'guild_members.sql', error: 2
ERROR:
Failed to open file 'guild_ranks.sql', error: 2
ERROR:
Failed to open file 'guild_relations.sql', error: 2
ERROR:
Failed to open file 'guilds.sql', error: 2
ERROR:
Failed to open file 'hackers.sql', error: 2
ERROR:
Failed to open file 'inventory.sql', error: 2
ERROR:
Failed to open file 'launcher.sql', error: 2
ERROR:
Failed to open file 'launcher_zones.sql', error: 2
ERROR:
Failed to open file 'name_filter.sql', error: 2
ERROR:
Failed to open file 'object_contents.sql', error: 2
ERROR:
Failed to open file 'petitions.sql', error: 2
ERROR:
Failed to open file 'player_corpses.sql', error: 2
ERROR:
Failed to open file 'player_corpses_backup.sql', error: 2
ERROR:
Failed to open file 'quest_globals.sql', error: 2
ERROR:
Failed to open file 'quest_items.sql', error: 2
ERROR:
Failed to open file 'rule_sets.sql', error: 2
ERROR:
Failed to open file 'rule_values.sql', error: 2
ERROR:
Failed to open file 'sharedbank.sql', error: 2
ERROR:
Failed to open file 'timers.sql', error: 2

1magus · #12 12-23-2008, 01:26 AM

Ok about the guide umm I cannot find the peqdb_XXXXRevxxx.sql file for download anywhere its like its missing or not very clear of where it's link is located at and I still get error 2 just thought the experts would want to know.

kiirdiir · #13 12-23-2008, 06:51 AM

Quote:

Originally Posted by 1magus

Ok about the guide umm I cannot find the peqdb_XXXXRevxxx.sql file for download anywhere its like its missing or not very clear of where it's link is located

It's in the CVS. Remember this page? You need to extract the .gz file to get the peqdb_XXXXRevxxx.sql file. (If the .gz file is not there then redownload via the CVS.)

Example: extract peqdb_1129Rev233.sql.gz to peqdb_1129Rev233.sql and then source it.

Quote:

Originally Posted by cavedude

System tables - This is the actual content of the db. If you have custom changes or the like, I don't recommend using this as all of your custom data will be destroyed! First, extract peqdb_XXXXRevxxx.sql.gz with WinRAR or another compression program that supports gz into the same dir as all the other sqls. (If you get a corrupt SQL or an error message while extracting, then your program DOES NOT properly support it!) Then, at the mysql command prompt do source drop_system.sql and then source peqdb_XXXXRevxxx.sql. This can take some time so be patient.

Follow the guide and all of it's relevant notes and links.

1magus · #14 12-23-2008, 08:03 AM

Ok lets pretend I'm a supernoob because there is something I'm not getting.

The file I need to download DOES NOT come in any CVS download I get, it just comes with 2 install files.

If I'm suppose to download it WITH CVS than there is no guide that tells you how to do so, it just tells you how to download the DB and QUests and if the DB is the file than it obviously does not work because I still get errors in Start.bat!

1magus · #15 12-23-2008, 08:18 AM

Ok I finnaly found the file and did the CMD commands and everything but it gave me tons of erros in my SYNTAX and Start.bat is still giving me errors :(

Using:
peqdb_1129Rev245.sql
On the latest EQEmu PEQ