PEQ Server Problems

[kiirdiir]

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.

Originally Posted by 1magus

mysql> \u peq
Database changed

Good. Keep following the guide.

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]

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]

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]

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.

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]

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]

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

[kiirdiir]

My only recommendation is to uninstall everything, reboot, and start again: and this time follow the guide carefully and step-by-step with noting the several mentioned notes on the wiki's playguide page, and using the proper Perl version (version 5.8.8.822), and be sure to use the matching peqdb and projecteqemu revisions.

Good luck. It works, so there should be no reason you can not get it to work if you follow the guide (*almost) exactly.

*noting the changes, notes, and updates.