Error: Could not load item data. But ignoring

[Rezbee]

Hello, I'm returning to the EQEMU community after about a 3 year hiatus. The latest software we had on our server was about 2 years old. completely started over minus quests and maps. Some of the DB's I tried to convert, did a pretty good job it seems except with the item table.

After installing the item table seems to fail to load at world boot for some reason. I gave up, created a backup table of it, and just created a brand new items table, still no luck.

I really am not sure whats going on here, but I can't find any source SQL files except for on Angelox's or Cavedude's sites; and thats not working :S. Any help would be much appreciated.

[root@cp logs]# cat eqemu_debug_world.log
---------------------------------------------
24529 [01.26. - 05:47:51] Starting Log: logs/eqemu_debug_world.log
24529 [01.26. - 05:47:51] [RULES__CHANGE] Resetting running rules to default values
24529 [01.26. - 05:47:51] [COMMON__THREADS] Starting TCPServerLoop with thread ID -1209021552
24529 [01.26. - 05:47:51] [COMMON__THREADS] Starting TCPServerLoop with thread ID -1219511408
24529 [01.26. - 05:47:51] [WORLD__INIT] Loading server configuration..
24529 [01.26. - 05:47:51] [WORLD__INIT] Log settings loaded from log.ini
24529 [01.26. - 05:47:51] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
24529 [01.26. - 05:47:51] [WORLD__INIT] Connecting to MySQL...
24529 [01.26. - 05:47:51] [WORLD__INIT] Starting HTTP world service...
24529 [01.26. - 05:47:51] [COMMON__THREADS] Starting DBAsyncLoop with thread ID -1230001264
24529 [01.26. - 05:47:51] [WORLD__HTTP] Loaded mime types from mime.types
24529 [01.26. - 05:47:51] [WORLD__INIT] Loading variables..
24529 [01.26. - 05:47:51] [WORLD__INIT] Loading zones..
24529 [01.26. - 05:47:51] [WORLD__INIT] Clearing groups..
24529 [01.26. - 05:47:51] [WORLD__INIT] Clearing temporary merchant lists..
24529 [01.26. - 05:47:51] [WORLD__INIT] Loading items..
24529 [01.26. - 05:47:51] [WORLD__INIT_ERR] Error: Could not load item data.  But ignoring
24529 [01.26. - 05:47:51] [WORLD__INIT] Loading guilds..
24529 [01.26. - 05:47:51] [RULES__CHANGE] Loading rule set 'default' (0)
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:DeathExpLossLevel to value 6
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 108000000
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value false
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 1.0000000000000
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 55
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000000
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 200
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 60000
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 65000
24529 [01.26. - 05:47:51] [RULES__ERROR] Unable to find rule 'Spells:SpellAggroModifier'
24529 [01.26. - 05:47:51] [RULES__ERROR] Unable to interpret rule record for Spells:SpellAggroModifier
24529 [01.26. - 05:47:51] [RULES__ERROR] Unable to find rule 'Spells:BardSpellAggroMod'
24529 [01.26. - 05:47:51] [RULES__ERROR] Unable to interpret rule record for Spells:BardSpellAggroMod
24529 [01.26. - 05:47:51] [RULES__ERROR] Unable to find rule 'Spells:PetSpellAggroMod'
24529 [01.26. - 05:47:51] [RULES__ERROR] Unable to interpret rule record for Spells:PetSpellAggroMod
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.0299999993294
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0599999986589
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
24529 [01.26. - 05:47:51] [RULES__CHANGE] Set rule World:UseBannedIPsTable to value false
24529 [01.26. - 05:47:51] [WORLD__INIT] Loaded default rule set 'default'
24529 [01.26. - 05:47:51] [WORLD__INIT] Loading EQ time of day..
24529 [01.26. - 05:47:51] [WORLD__INIT] Loading launcher list..
24529 [01.26. - 05:47:51] [WORLD__INIT] Reboot zone modes ON
24529 [01.26. - 05:47:51] [WORLD__INIT] Deleted 0 stale player corpses from database
24529 [01.26. - 05:47:51] [WORLD__INIT] Deleted 0 stale player backups from database
24529 [01.26. - 05:47:51] [WORLD__INIT] Zone (TCP) listener started.
24529 [01.26. - 05:47:51] [WORLD__INIT] Client (UDP) listener started.
24529 [01.26. - 05:47:51] [COMMON__THREADS] Starting EQStreamFactoryReaderLoop with thread ID -1240491120
24529 [01.26. - 05:47:51] [COMMON__THREADS] Starting EQStreamFactoryWriterLoop with thread ID -1250980976
24529 [01.26. - 05:47:51] [NET__IDENTIFY] Registered patch 6.2
24529 [01.26. - 05:47:51] [NET__IDENTIFY] Registered patch Titanium
24529 [01.26. - 05:47:51] [NET__IDENTIFY] Registered patch Anniversary
24529 [01.26. - 05:47:51] [NET__IDENTIFY] Registered patch Live
24529 [01.26. - 05:47:51] [WORLD__LS] Connecting to login server...
24529 [01.26. - 05:47:51] [COMMON__THREADS] Starting TCPConnectionLoop with thread ID -1273025648
24529 [01.26. - 05:47:51] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
24529 [01.26. - 05:47:51] [WORLD__LS] Loginserver provided 64.69.34.153 as world address
24529 [01.26. - 05:48:06] [WORLD__ZONE] New TCP connection from 127.0.0.1:54755
24529 [01.26. - 05:48:06] [WORLD__CONSOLE] New launcher from 127.0.0.1:54755
24529 [01.26. - 05:48:06] [WORLD__LAUNCH] Adding pending launcher 1
24529 [01.26. - 05:48:06] [WORLD__LAUNCH] Launcher Identified itself as 'zones2'. Loading zone list.
24529 [01.26. - 05:48:06] [WORLD__LAUNCH_TRACE] zones2: Loaded zone 'cshome' on port 0
24529 [01.26. - 05:48:06] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones2 to active list.
24529 [01.26. - 05:48:11] [WORLD__LAUNCH] zones2: cshome reported state STARTED (1 starts)

[Rezbee]

I do appologize, this was ment for Linux Servers not Spell Support :(

[Rezbee]

I think I figured this out, someone help me out there but the item names in the new database start and end with apostrophe's for some wierd reason, and the old DB (good ole' trusty) do not. Was this a change to the DB at some point or did the import screw with something?

[Rezbee]

Ok I emptied the db and it loaded lol... Did some more reading and read this wiki article. It may be a good idea for some of the authors to update their install guides

[Rezbee]

Even after loading the latest items running the load_13thfloor perl command on a Linux server it is still failing to load the item's DB. It was done exactly as that wiki page explained... What am I missing here?

[Rezbee]

Ok the problem was is the max item limit was set to 100000 in item.h. I increased that to 200000 and everything works fine.

FYI that needs to be changed in the next release =P

[AndMetal]

Originally Posted by Rezbee

Ok the problem was is the max item limit was set to 100000 in item.h. I increased that to 200000 and everything works fine.

FYI that needs to be changed in the next release =P

It was actually just updated to 120000 in SVN Rev 279.