So I sourced a fresh completely new database from the PEQ 10-11 download.
Specifically I sourced, in this order:
peqbeta_*.sql
player_*.sql
load_login.sql
source_views.sql
I updated two login tables to include the information to login.
I then started everything, when I got to world I got some messages that didn't seem to stop the server from starting but here goes:
[Status] Using database 'eq1' at 127.0.0.1:3306
Unable to clear group leaders: #1146: Table 'eq1.group_leaders' doesn't exist
Unable to clear groups: #1146: Table 'eq1.group_id' doesn't exist
Unable to clear raids: #1146: Table 'eq1.raid_members' doesn't exist
Unable to clear raid details: #1146: Table 'eq1.raid_details' doesn't exist
[Error] EQLConfig::LoadSettings: #1146: Table 'eq1.launcher_zones' doesn't exist
[Error] EQLConfig::LoadSettings: #1146: Table 'eq1.launcher_zones' doesn't exist
[Error] Error in AdventureManager:::GetLeaderboardInfo: SELECT ch.name, ch.id, adv_stats.* FROM adventure_stats AS adv_stats LEFT JOIN `character_data` AS ch ON adv_stats.player_id = ch.id; (#1146: Table 'eq1.adventure_stats' doesn't exist)
---
After this I logged in with a client, saw my server as UP. When selecting that server and loading the characters (before character select) the client just hung with no further messages.
For s* n grins I sourced drop_system.sql and re-sourced peqbeta*.sql and still get a message about missing tables.
Thanks for your attention and help Uleat.
edit: another person with the same issue several months ago:
http://www.eqemulator.org/forums/showthread.php?t=38433 (no resolution in thread)
Threaded Mode
