Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-10-2012, 02:10 AM
GLGanjika
Hill Giant
 
Join Date: Feb 2011
Posts: 132
Default Missing Tables.

I have missing tables now that i redid my installation - I followed this guide [click here] before and it worked, this time it didnt source right or something and i got missing tables... how can i address this?

(i do see stuff such as guilds.sql and whatnot at peqdb\player_tables though... ?)



error

Code:
[06.10. - 01:16:21] Starting Log: logs/eqemu_error_world_3876.log
[06.10. - 01:16:21] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='default': #1146: Table 'peq.rule_sets' doesn't exist
[06.10. - 01:16:21] Could not load EQTime file eqtime.cfg
[06.10. - 01:16:21] WorldDatabase::GetLauncherList: #1146: Table 'peq.launcher' doesn't exist
[06.10. - 01:16:21] Error in AdventureManager:::GetLeaderboardInfo: select ch.name, ch.id, adv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_stats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist)
DEBUG
Code:
---------------------------------------------
[06.10. - 01:16:27] Starting Log: logs/eqemu_debug_world_5932.log
[06.10. - 01:16:27] [WORLD__INIT] Loading server configuration..
[06.10. - 01:16:27] [WORLD__INIT] Log settings loaded from log.ini
[06.10. - 01:16:27] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[06.10. - 01:16:27] [WORLD__INIT] Added loginserver eqemulator.net:5998
[06.10. - 01:16:27] [WORLD__INIT] Connecting to MySQL...
[06.10. - 01:16:27] [WORLD__INIT] HTTP world service disabled.
[06.10. - 01:16:27] [WORLD__INIT] Loading variables..
[06.10. - 01:16:27] [WORLD__INIT] Loading zones..
[06.10. - 01:16:27] [WORLD__INIT] Clearing groups..
[06.10. - 01:16:27] [WORLD__INIT] Clearing raids..
[06.10. - 01:16:27] [WORLD__INIT] Loading items..
[06.10. - 01:16:41] [WORLD__INIT] Loading guilds..
[06.10. - 01:16:41] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus, motd, motd_setter,channel,url FROM guilds': #1146: Table 'peq.guilds' doesn't exist
[06.10. - 01:16:41] [WORLD__INIT] No rule set configured, using default rules
[06.10. - 01:16:41] [WORLD__INIT] Clearing temporary merchant lists..
[06.10. - 01:16:41] [WORLD__INIT] Loading EQ time of day..
[06.10. - 01:16:41] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[06.10. - 01:16:41] [WORLD__INIT] Loading launcher list..
[06.10. - 01:16:41] [WORLD__INIT] Reboot zone modes OFF
[06.10. - 01:16:41] [WORLD__INIT] Deleted -1 stale player corpses from database
[06.10. - 01:16:41] [WORLD__INIT] Deleted -1 stale player backups from database
[06.10. - 01:16:41] [WORLD__INIT] Loading adventures...
[06.10. - 01:16:41] [WORLD__INIT] Purging expired instances
[06.10. - 01:16:41] [WORLD__INIT] Loading char create info...
[06.10. - 01:16:41] [WORLD__INIT] Zone (TCP) listener started.
[06.10. - 01:16:41] [WORLD__INIT] Client (UDP) listener started.
[06.10. - 01:16:41] [NET__IDENTIFY] Registered patch 6.2
[06.10. - 01:16:41] [NET__IDENTIFY] Registered patch Titanium
[06.10. - 01:16:41] [NET__IDENTIFY] Registered patch SoF
[06.10. - 01:16:41] [NET__IDENTIFY] Registered patch SoD
[06.10. - 01:16:41] [NET__IDENTIFY] Registered patch Underfoot
[06.10. - 01:16:41] [WORLD__LS] Connecting to login server: eqemulator.net:5998
[06.10. - 01:16:41] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[06.10. - 01:16:41] [WORLD__LS] Loginserver provided 68.43.175.133 as world address

UPDATE: I got it working, i just ran load bots and not load_player.sql since the guide made it sound like i had to pick either or.
I'm still uncertain as to how o properly source stuff in.. if i source in halloween stuff... is that permanent? or can i unsource it after the holiday... thats what i wanna know... =P
__________________
"Be who you are and say what you feel because those who matter don't mind
and those who mind don't matter." - Theodore Seuss Geisel. [Dr. Seuss.]

Reply With Quote
  #2  
Old 06-10-2012, 03:33 AM
Vexyl
Hill Giant
 
Join Date: Oct 2009
Location: U.S.A.
Posts: 197
Default

You need to source load_player.sql no matter what, but load_bots.sql is only sourced if you plan on having bots (only do this if you have compiled EQEmu with bots).

Edit: You should know that all load_player.sql does is source everything in player_tables.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:20 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3