PEQ Server Problems

kiirdiir · #1 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 · #2 12-21-2008, 11:49 PM

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

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

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

1magus · #4 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 · #5 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 · #6 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 · #7 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.