PEQ Server Problems
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! |
well does your Db contains table 'peq.variables' ?
|
I don't see any in peq_db, at least as long as they have peq in the name I don't see any.
|
my only guess that your peq is either old version or incomplite
|
Um is there anyway to check?
Anyway to get the files I'm MOST likely missing manually?! |
Quote:
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. |
Ok let me install these tables and see if I missed any steps.
|
I get error 2 when trying to install the tables :(
|
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> |
Quote:
Quote:
Quote:
|
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 |
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.
|
Quote:
Example: extract peqdb_1129Rev233.sql.gz to peqdb_1129Rev233.sql and then source it. Quote:
|
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! |
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 |
All times are GMT -4. The time now is 12:18 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.