Couple of Issues

[Furinex]

I had a computer crash recently, im out on a deployment (Navy) and my personal computer doesnt have access to the internet. Now, my problem is two fold.

First of all... When I was setting up the server again, I installed pear as per the set up wikki, and did install dbd-mysql and the other two, and it basically tells me that it cant find the website to look for those packages (Considering im not on the internet, I can see why). My question is, is there a way I can DL those seperately and then load them in pearl offline?

2nd of all... When I load the world, I load up Minilogin first, and thats fine, then I do the start batch file which loads world.exe and the zones.. It would pop up for a split second and then disapear. So I loaded world.exe in the command prompt, and i found this error:

Failed to open log file: logs/eqemu_debug_world_2396.log
[Debug] [WORLD__INIT] Loading server configuration..
Unable to load 'eqemu_config.xml': Failed to open file
[Debug] [WORLD__INIT_ERR] Loading server configuration failed.

the file is there, and in the right place, i tried to open it in IE and It wouldnt open it, said something like it couldnt read the xml, yet when I open it in Notepad, its fine... I can see all of it... anythign I can do to fix this?

[LostZaphod]

From my unserstanding the perl items are no longer necessary. For example, in Linux I have never run them and all of the quests work.

The issuse with the xml file is syntax. XML is very sensitive to nodes. If there is "<xxx>" there must be "</xxx>" .
Make sure you have a beginning and a ending for each sub item, items can have items for example server has world and database (world has shortname, longname loginserver.... ).
Another solution is to extract the file again and make the modifications needed.
If not here is a copy...
<?xml version="1.0">
<server>
<world>
<shortname>minilogin</shortname>
<longname>My Minilogin</longname>

<!-- Only specify these two if you really think you need to. -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>
</server>

[Furinex]

ok so I got the server up and running again, but now i have a new set of issues... Now when I create a new character and log in with him, I only get a backpack and a starting note, no weapon or food... here's the error in the logs..

[Debug] [WORLD__CLIENT] Furinex: Bind location: qeynos2 168.00, 31.00, -29.56
[Error] Starting Log: logs/eqemu_error_world_2532.log
[Error] StoreCharacter inventory failed. Query '(null)' #1264: Out of range val
ue adjusted for column 'color' at row 1
[Error] StoreCharacter inventory failed. Query '(null)' #1264: Out of range val
ue adjusted for column 'color' at row 1
[Error] StoreCharacter inventory failed. Query '(null)' #1264: Out of range val
ue adjusted for column 'color' at row 1
[Error] StoreCharacter inventory failed. Query '(null)' #1264: Out of range val
ue adjusted for column 'color' at row 1

The next problem I have is with the character backup i made... the table loads in alright. But when i log in, I have no characters, and the world log indicates something like

Account is trying to load Bogus Characters (Name of character)
and it repeats for all my characters.. it also says something like pp=0 when it should be 12345 or some number, and I looked in the account table, character table, character backup table... and inventory and I found no field named pp.

[cavedude]

You installed MySQL in strict mode. Run this query to correct it and you'll be fine:

SET @@global.sql_mode= '';

As for the toons, you probably lost your pp data which means those toons are done for, sadly.

[Furinex]

Thank you CD, you're thoughts are always appreciated. Its a shame, I had about 2000 fixes give or take for ya to add to peq, and one little worm took care of 2 terrabytes of info on my computer... :(

[Furinex]

Ok, so Ive come to accept the character loss... But now I would really like to get past some of the other errors I got. Here's the lastest one. (Note that the server still runs normally, and I can log in and such, this is just a picky error solving tendancy... plus I would love to get the rule sets to work) Anyways, My rules in the rule sets table dont seem to be properly loading, or recognized... Here's what I got in my world.exe for errors...

[Debug] [RULES__CHANGE] Loading rule set 'default' (1)
[Debug] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 250
[Debug] [RULES__CHANGE] Set rule Character:MaxLevel to value 70
[Debug] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
[Debug] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value true
[Debug] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 0.750000000000
0
[Debug] [RULES__CHANGE] Set rule Character:DeathExpLossLevel to value 10
[Debug] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 86400000
[Debug] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[Debug] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100

[Debug] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[Debug] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[Debug] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000
000
[Debug] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 120000
[Debug] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 95000
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:PetSpellAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:PetSpellAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:SongAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:SongAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:SpellAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:SpellAggroMod
[Debug] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[Debug] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.03000000
00000
[Debug] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0600000
000000
[Debug] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
[Debug] [RULES__CHANGE] Set rule Character:ConsumptionMultiplier to value 200
[Debug] [RULES__CHANGE] Set rule Spells:AutoResistDiff to value 15
[Debug] [RULES__CHANGE] Set rule Spells:ResistChance to value 2.0000000000000
[Debug] [RULES__CHANGE] Set rule Spells:ResistMod to value 0.4000000000000
[Debug] [RULES__CHANGE] Set rule Spells:PartialHitChance to value 0.700000000000
0
[Debug] [RULES__CHANGE] Set rule Combat:ClientBaseCritChance to value 0.00000000
00000
[Debug] [RULES__CHANGE] Set rule Zone:NPCGlobalPositionUpdateInterval to value 6
0000
[Debug] [RULES__CHANGE] Set rule NPC:MinorNPCCorpseDecayTimeMS to value 600000
[Debug] [RULES__CHANGE] Set rule NPC:MajorNPCCorpseDecayTimeMS to value 1200000
[Debug] [RULES__CHANGE] Set rule Zone:GraveyardTimeMS to value 1200000
[Debug] [RULES__CHANGE] Set rule Zone:EnableShadowrest to value true
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZWhenLoading'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZWhenLoading
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZAtWaypoints'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZAtWaypoints
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZWhenMoving'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZWhenMoving
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZOnSendTo'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZOnSendTo
[Debug] [RULES__CHANGE] Set rule Zone:ClientLinkdeadMS to value 180000
[Debug] [RULES__CHANGE] Set rule NPC:UseItemBonusesForNonPets to value true
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZMaxDeltaSendTo'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZMaxDeltaSendTo
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZMaxDeltaLoading'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZMaxDeltaLoading
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZMaxDeltaMoving'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZMaxDeltaMoving
[Debug] [RULES__ERROR] Unable to find rule 'Map:FixPathingZMaxDeltaWaypoint'
[Debug] [RULES__ERROR] Unable to interpret rule record for Map:FixPathingZMaxDeltaWaypoint
[Debug] [RULES__ERROR] Unable to find rule 'Character:HealOnLevel'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:HealOnLevel

[Debug] [RULES__ERROR] Unable to find rule 'Character:FeignKillsPet'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:FeignKillsPet
[Debug] [RULES__ERROR] Unable to find rule 'Character:ItemManaRegenCap'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:ItemManaRegenCap
[Debug] [RULES__ERROR] Unable to find rule 'Character:ItemHealthRegenCap'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:ItemHealthRegenCap
[Debug] [RULES__ERROR] Unable to find rule 'Combat:UseIntervalAC'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:UseIntervalAC
[Debug] [RULES__ERROR] Unable to find rule 'Combat:PetAttackMagicLevel'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:PetAttackMagicLevel
[Debug] [RULES__ERROR] Unable to find rule 'NPC:SayPauseTimeInSec'
[Debug] [RULES__ERROR] Unable to interpret rule record for NPC:SayPauseTimeInSec

[Debug] [RULES__ERROR] Unable to find rule 'NPC:OOCRegen'
[Debug] [RULES__ERROR] Unable to interpret rule record for NPC:OOCRegen
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:SmartAggroList'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:SmartAggroList
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:SittingAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:SittingAggroMod

[Debug] [RULES__ERROR] Unable to find rule 'Aggro:MeleeRangeAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:MeleeRangeAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:CurrentTargetAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:CurrentTargetAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:CriticallyWoundedAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:CriticallyWoundedAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:SlowAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:SlowAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:IncapacitateAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:IncapacitateAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Aggro:MovementImpairAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Aggro:MovementImpairAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'NPC:BuffFriends'
[Debug] [RULES__ERROR] Unable to interpret rule record for NPC:BuffFriends
[Debug] [RULES__ERROR] Unable to find rule 'Character:DeathItemLossLevel'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:DeathItemLossLevel
[Debug] [RULES__ERROR] Unable to find rule 'Watermap:CheckWaypointsInWaterWhenLoading'
[Debug] [RULES__ERROR] Unable to interpret rule record for Watermap:CheckWaypointsInWaterWhenLoading
[Debug] [RULES__ERROR] Unable to find rule 'Watermap:CheckForWaterAtWaypoints'
[Debug] [RULES__ERROR] Unable to interpret rule record for Watermap:CheckForWaterAtWaypoints
[Debug] [RULES__ERROR] Unable to find rule 'Watermap:CheckForWaterWhenMoving'
[Debug] [RULES__ERROR] Unable to interpret rule record for Watermap:CheckForWaterWhenMoving
[Debug] [RULES__ERROR] Unable to find rule 'Watermap:CheckForWaterOnSendTo'
[Debug] [RULES__ERROR] Unable to interpret rule record for Watermap:CheckForWaterOnSendTo
[Debug] [RULES__ERROR] Unable to find rule 'Watermap:CheckForWaterWhenFishing'
[Debug] [RULES__ERROR] Unable to interpret rule record for Watermap:CheckForWaterWhenFishing
[Debug] [RULES__ERROR] Unable to find rule 'Watermap:FishingRodLength'
[Debug] [RULES__ERROR] Unable to interpret rule record for Watermap:FishingRodLength
[Debug] [RULES__ERROR] Unable to find rule 'Watermap:FishingLineLength'
[Debug] [RULES__ERROR] Unable to interpret rule record for Watermap:FishingLineLength

Any advice on how to fix this?

[cavedude]

It looks like you are using an older version of EQEmu that didn't support those rules. Make sure you are using 1102 from the downloads page and try it again.

[Furinex]

That Definately worked, thank you cave dude.... Now on to the next problem ( I know im full of em!!!) Anyways, whenever I create a guild with #guild it gives me an error saying "unable to set guild leader's guild into database. You're going to have to use #guild set" (It does infact create the guild however, when I look into the database...) Then it tells me to use #guild set so I do that, #guild set kenji 1, that is the correct code, I checked. And it gives me an error again saying "Error: Unable to set kenji to guild 1". Now, Maybe Im way off but is the guild table in the database supposed to be called "guilds" or "guild" or is that not even the issue....

[Furinex]

Fixed my own problem, Didnt have the public notes field in the guild_members table set to null.