PEQ Server Problems

1magus · #1 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 · #2 12-21-2008, 03:44 PM

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

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

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

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

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

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

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

1magus · #7 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 · #8 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 · #9 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