[Errors] I don't understand? [Archive]

View Full Version : [Errors] I don't understand?

seridium

02-18-2009, 04:39 AM

I am getting these errors and have no clue as to what they mean I am hoping a expert can help.

this one too has rule errors I Can see the crushbone quest error at the end I Can get that but why all the rule errors?

[Debug] [ZONE__INIT] 202 commands loaded
[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 90
[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.7500000000000
[Debug] [RULES__CHANGE] Set rule Character:DeathExpLossLevel to value 0
[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.0000000000000
[Debug] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 120000
[Debug] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 95000
[Debug] [RULES__CHANGE] Set rule World:UseBannedIPsTable to value true
[Debug] [RULES__CHANGE] Set rule World:MaxClientsPerIP to value -1
[Debug] [RULES__CHANGE] Set rule World:ExemptMaxClientsStatus to value -1
[Debug] [RULES__CHANGE] Set rule Aggro:PetSpellAggroMod to value 10
[Debug] [RULES__CHANGE] Set rule Aggro:SongAggroMod to value 33
[Debug] [RULES__CHANGE] Set rule Aggro:SpellAggroMod to value 100
[Debug] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[Debug] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.0299999993294
[Debug] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0599999986589
[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.4000000059605
[Debug] [RULES__CHANGE] Set rule Spells:PartialHitChance to value 0.6999999880791
[Debug] [RULES__CHANGE] Set rule Combat:ClientBaseCritChance to value 0.0000000000000
[Debug] [RULES__CHANGE] Set rule Zone:NPCGlobalPositionUpdateInterval to value 60000
[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__CHANGE] Set rule Map:FixPathingZWhenLoading to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZAtWaypoints to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZWhenMoving to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZOnSendTo to value false
[Debug] [RULES__CHANGE] Set rule Zone:ClientLinkdeadMS to value 180000
[Debug] [RULES__CHANGE] Set rule NPC:UseItemBonusesForNonPets to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaSendTo to value 20.0000000000000
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaLoading to value 20.0000000000000
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaMoving to value 20.0000000000000
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaWaypoint to value 20.0000000000000
[Debug] [RULES__CHANGE] Set rule Character:HealOnLevel to value false
[Debug] [RULES__CHANGE] Set rule Character:FeignKillsPet to value false
[Debug] [RULES__CHANGE] Set rule Character:ItemManaRegenCap to value 15
[Debug] [RULES__CHANGE] Set rule Character:ItemHealthRegenCap to value 15
[Debug] [RULES__CHANGE] Set rule Combat:UseIntervalAC to value true
[Debug] [RULES
[Debug] [RULES__CHANGE] Set rule NPC:SayPauseTimeInSec to value 10
[Debug] [RULES__CHANGE] Set rule NPC:OOCRegen to value 0
[Debug] [RULES__CHANGE] Set rule Aggro:SmartAggroList to value true
[Debug] [RULES__CHANGE] Set rule Aggro:SittingAggroMod to value 35
[Debug] [RULES__CHANGE] Set rule Aggro:MeleeRangeAggroMod to value 20
[Debug] [RULES__CHANGE] Set rule Aggro:CurrentTargetAggroMod to value 0
[Debug] [RULES__CHANGE] Set rule Aggro:CriticallyWoundedAggroMod to value 100
[Debug] [RULES__CHANGE] Set rule Aggro:SlowAggroMod to value 450
[Debug] [RULES__CHANGE] Set rule Aggro:IncapacitateAggroMod to value 500
[Debug] [RULES__CHANGE] Set rule Aggro:MovementImpairAggroMod to value 175
[Debug] [RULES__CHANGE] Set rule NPC:BuffFriends to value true
[Debug] [RULES__CHANGE] Set rule Character:DeathItemLossLevel to value 10
[Debug] [RULES__CHANGE] Set rule Watermap:CheckWaypointsInWaterWhenLoading to value true
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterAtWaypoints to value true
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenMoving to value true
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterOnSendTo to value false
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenFishing to value true
[Debug] [RULES__CHANGE] Set rule Watermap:FishingRodLength to value 30.0000000000000
[Debug] [RULES__CHANGE] Set rule Watermap:FishingLineLength to value 40.0000000000000
[Debug] [RULES__CHANGE] Set rule Character:ItemDamageShieldCap to value 30
[Debug] [RULES__CHANGE] Set rule Character:ItemAccuracyCap to value 150
[Debug] [RULES__CHANGE] Set rule Character:ItemAvoidanceCap to value 100
[Debug] [RULES__CHANGE] Set rule Character:ItemCombatEffectsCap to value 100
[Debug] [RULES__CHANGE] Set rule Character:ItemShieldingCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemSpellShieldingCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemDoTShieldingCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemStunResistCap to value 35
[Debug] [RULES__CHANGE] Set rule Character:ItemStrikethroughCap to value 35
[Debug] [RULES__CHANGE] Set rule Spells:PartialHitChanceFear to value 0.2500000000000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:MQZoneExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:MQGateExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:MQGhostExemptStatus to value -1
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQWarpDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQZoneDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQGateDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQGhostDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpDetectorDistance to value 4900.0000000000000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpLagThreshold to value 140.0000000000000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpThresholdTimer to value 90000.0000000000000
[Debug] [RULES__CHANGE] Set rule Combat:EnableFearPathing to value true
[Debug] [RULES__CHANGE] Set rule Combat:FleeHPRatio to value 22
[Debug] [RULES__CHANGE] Set rule Combat:FleeIfNotAlone to value false
[Debug] [RULES__ERROR] Unable to find rule 'NPC:EnableNPCQuestJournal'
[Debug] [RULES__ERROR] Unable to interpret rule record for NPC:EnableNPCQuestJournal
[Debug] [RULES__ERROR] Unable to find rule 'Character:SkillUpModifier'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:SkillUpModifier
[Debug] [RULES__ERROR] Unable to find rule 'NPC:CorpseUnlockTimer'
[Debug] [RULES__ERROR] Unable to interpret rule record for NPC:CorpseUnlockTimer
[Debug] [RULES__ERROR] Unable to find rule 'NPC:EmptyNPCCorpseDecayTimeMS'
[Debug] [RULES__ERROR] Unable to interpret rule record for NPC:EmptyNPCCorpseDecayTimeMS
[Debug] [RULES__ERROR] Unable to find rule 'World:ClearTempMerchantlist'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:ClearTempMerchantlist
[Debug] [RULES__ERROR] Unable to find rule 'World:Addr
[Debug] [RULES__ERROR] Unable to find rule 'World:AddMaxClientsStatus'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:AddMaxClientsStatus
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskSystem'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTaskSystem
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:PeriodicCheckTimer'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:PeriodicCheckTimer
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedTasks'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordCompletedTasks
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedOptionalActivities'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordCompletedOptionalActivities
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:KeepOneRecordPerCompletedTask'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:KeepOneRecordPerCompletedTask
[Debug] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskProximity'
[Debug] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTaskProximity
[Debug] [RULES__ERROR] Unable to find rule 'World:EnableTutorialButton'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:EnableTutorialButton
[Debug] [RULES__ERROR] Unable to find rule 'World:EnableReturnHomeButton'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:EnableReturnHomeButton
[Debug] [RULES__ERROR] Unable to find rule 'World:MaxLevelForTutorial'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:MaxLevelForTutorial
[Debug] [RULES__ERROR] Unable to find rule 'World:MinOfflineTimeToReturnHome'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:MinOfflineTimeToReturnHome
[Debug] [RULES__ERROR] Unable to find rule 'Zone:AutoShutdownDelay'
[Debug] [RULES__ERROR] Unable to interpret rule record for Zone:AutoShutdownDelay
[Debug] [RULES__ERROR] Unable to find rule 'Character:MaxExpLevel'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:MaxExpLevel
[Debug] [RULES__ERROR] Unable to find rule 'Combat:AdjustProcPerMinute'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:AdjustProcPerMinute
[Debug] [RULES__ERROR] Unable to find rule 'Combat:AvgProcsPerMinute'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:AvgProcsPerMinute
[Debug] [RULES__ERROR] Unable to find rule 'Combat:ProcPerMinDexContrib'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:ProcPerMinDexContrib
[Debug] [RULES__ERROR] Unable to find rule 'Combat:BaseProcChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:BaseProcChance
[Debug] [RULES__ERROR] Unable to find rule 'Combat:ProcDexDivideBy'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:ProcDexDivideBy
[Debug] [RULES__ERROR] Unable to find rule 'Chat:ServerWideOOC'
[Debug] [RULES__ERROR] Unable to interpret rule record for Chat:ServerWideOOC
[Debug] [RULES__ERROR] Unable to find rule 'Chat:ServerWideAuction'
[Debug] [RULES__ERROR] Unable to interpret rule record for Chat:ServerWideAuction
[Debug] [RULES__ERROR] Unable to find rule 'Spells:BaseCritChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:BaseCritChance
[Debug] [RULES__ERROR] Unable to find rule 'Spells:BaseCritRatio'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:BaseCritRatio
[Debug] [RULES__ERROR] Unable to find rule 'Spells:WizCritLevel'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritLevel
[Debug] [RULES__ERROR] Unable to find rule 'Spells:WizCritChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritChance
[Debug] [RULES__ERROR] Unable to find rule 'Spells:WizCritRatio'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritRatio
[Debug] [RULES__ERROR] Unable to find rule 'Character:SharedBankPlat'
[Debug] [RULES__ERROR] Unable to interpret rEUnable to find rule 'Spells:ResistPerLevelDiff'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:ResistPerLevelDiff
[Debug] [RULES__ERROR] Unable to find rule 'Combat:BaseHitChance'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:BaseHitChance
[Debug] [RULES__ERROR] Unable to find rule 'Combat:HitPerLevelDiff'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:HitPerLevelDiff
[Debug] [RULES__ERROR] Unable to find rule 'Combat:AgiHitFactor'
[Debug] [RULES__ERROR] Unable to interpret rule record for Combat:AgiHitFactor
[Debug] [RULES__ERROR] Unable to find rule 'Character:UseDeathExpLossMult'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:UseDeathExpLossMult
[Debug] [RULES__ERROR] Unable to find rule 'Character:DeathExpLossMultiplier'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:DeathExpLossMultiplier
[Debug] [RULES__ERROR] Unable to find rule 'Character:BindAnywhere'
[Debug] [RULES__ERROR] Unable to interpret rule record for Character:BindAnywhere
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:AuditTrail'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:AuditTrail
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:MaxSearchResults'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:MaxSearchResults
[Debug] [RULES__ERROR] Unable to find rule 'World:TutorialZoneID'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:TutorialZoneID
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:EnableWarpToTrader'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:EnableWarpToTrader
[Debug] [RULES__ERROR] Unable to find rule 'Bazaar:MaxBarterSearchResults'
[Debug] [RULES__ERROR] Unable to interpret rule record for Bazaar:MaxBarterSearchResults
[Debug] [RULES__ERROR] Unable to find rule 'World:AccountSessionLimit'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:AccountSessionLimit
[Debug] [RULES__ERROR] Unable to find rule 'World:ExemptAccountLimitStatus'
[Debug] [RULES__ERROR] Unable to interpret rule record for World:ExemptAccountLimitStatus
[Debug] [RULES__ERROR] Unable to find rule 'Mail:EnableMailSystem'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:EnableMailSystem
[Debug] [RULES__ERROR] Unable to find rule 'Mail:ExpireTrash'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireTrash
[Debug] [RULES__ERROR] Unable to find rule 'Mail:ExpireRead'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireRead
[Debug] [RULES__ERROR] Unable to find rule 'Mail:ExpireUnread'
[Debug] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireUnread
[Debug] [RULES__ERROR] Unable to find rule 'Channels:RequiredStatusAdmin'
[Debug] [RULES__ERROR] Unable to interpret rule record for Channels:RequiredStatusAdmin
[Debug] [RULES__ERROR] Unable to find rule 'Channels:RequiredStatusListAll'
[Debug] [RULES__ERROR] Unable to interpret rule record for Channels:RequiredStatusListAll
[Deb[Debug] [WORLD__CLIENT] New connection from 69.11.123.2:2435
[Quest] Useless use of a constant in void context at quests/crushbone/Skills .pl line 24.
[Debug] [NET__IDENT_TRACE] 69.11.123.2:2435: First opcode 0x7752 did not match expected 0x2792
[Debug] [NET__IDENT_TRACE] 69.11.123.2:2435: Tried patch 6.2_world, and it did not match.
[Debug] [NET__IDENT_TRACE] 69.11.123.2:2435: First opcode 0x7213 did not match expected 0x2ec9
[Debug] [NET__IDENT_TRACE] 69.11.123.2:2435: Tried patch 6.2_zone, and it did not match.
[Debug] [NET__IDENT_TRACE] 69.11.123.2:2435: First opcode 0x7752 did not match expected 0x4dd0
[Debug] [NET__IDENT_TRACE] 69.11.123.2:2435: Tried patch Titanium_world, and it did not match.
[Debug] [NET__IDENT_TRACE] 69.11.123.2:2435: First opcode matched 0x7213 and length matched 68
[Debug] [NET__IDENTIFY] Identified stream 69.11.123.2:2435 with signature Titanium_zone
[Debug] [WORLD__CLIENT] New client from 69.11.123.2:2435
[Quest] Unable to read perl file 'quests/crushbone/player.pl'

Any advice would be appreciated.

seridium

02-18-2009, 04:41 AM

couldnt post this in first window too many smiliey's

value 140.0000000000000
[02.17. - 02:22:02] [RULES__CHANGE] Set rule Zone:MQWarpThresholdTimer to value 90000.0000000000000
[02.17. - 02:22:02] [RULES__CHANGE] Set rule Combat:EnableFearPathing to value true
[02.17. - 02:22:02] [RULES__CHANGE] Set rule Combat:FleeHPRatio to value 22
[02.17. - 02:22:02] [RULES__CHANGE] Set rule Combat:FleeIfNotAlone to value false
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'NPC:EnableNPCQuestJournal'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for NPC:EnableNPCQuestJournal
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Character:SkillUpModifier'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Character:SkillUpModifier
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'NPC:CorpseUnlockTimer'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for NPC:CorpseUnlockTimer
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'NPC:EmptyNPCCorpseDecayTimeMS'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for NPC:EmptyNPCCorpseDecayTimeMS
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:ClearTempMerchantlist'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:ClearTempMerchantlist
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:AddMaxClientsPerIP'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:AddMaxClientsPerIP
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:AddMaxClientsStatus'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:AddMaxClientsStatus
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskSystem'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTaskSystem
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'TaskSystem:PeriodicCheckTimer'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for TaskSystem:PeriodicCheckTimer
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedTasks'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordCompletedTasks
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'TaskSystem:RecordCompletedOptionalActivities'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for TaskSystem:RecordCompletedOptionalActivities
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'TaskSystem:KeepOneRecordPerCompletedTask'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for TaskSystem:KeepOneRecordPerCompletedTask
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'TaskSystem:EnableTaskProximity'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for TaskSystem:EnableTaskProximity
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:EnableTutorialButton'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:EnableTutorialButton
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:EnableReturnHomeButton'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:EnableReturnHomeButton
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:MaxLevelForTutorial'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:MaxLevelForTutorial
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:MinOfflineTimeToReturnHome'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:MinOfflineTimeToReturnHome
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Zone:AutoShutdownDelay'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Zone:AutoShutdownDelay
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Character:MaxExpLevel'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Character:MaxExpLevel
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:AdjustProcPerMinute'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:AdjustProcPerMinute
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:AvgProcsPerMinute'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:AvgProcsPerMinute
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:ProcPerMinDexContrib'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:ProcPerMinDexContrib
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:BaseProcChance'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:BaseProcChance
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:ProcDexDivideBy'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:ProcDexDivideBy
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Chat:ServerWideOOC'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Chat:ServerWideOOC
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Chat:ServerWideAuction'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Chat:ServerWideAuction
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Spells:BaseCritChance'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Spells:BaseCritChance
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Spells:BaseCritRatio'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Spells:BaseCritRatio
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Spells:WizCritLevel'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritLevel
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Spells:WizCritChance'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritChance
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Spells:WizCritRatio'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Spells:WizCritRatio
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Character:SharedBankPlat'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Character:SharedBankPlat
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Spells:ResistPerLevelDiff'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Spells:ResistPerLevelDiff
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:BaseHitChance'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:BaseHitChance
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:HitPerLevelDiff'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:HitPerLevelDiff
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Combat:AgiHitFactor'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Combat:AgiHitFactor
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Character:UseDeathExpLossMult'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Character:UseDeathExpLossMult
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Character:DeathExpLossMultiplier'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Character:DeathExpLossMultiplier
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Character:BindAnywhere'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Character:BindAnywhere
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Bazaar:AuditTrail'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Bazaar:AuditTrail
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Bazaar:MaxSearchResults'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Bazaar:MaxSearchResults
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:TutorialZoneID'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:TutorialZoneID
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Bazaar:EnableWarpToTrader'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Bazaar:EnableWarpToTrader
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Bazaar:MaxBarterSearchResults'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Bazaar:MaxBarterSearchResults
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:AccountSessionLimit'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:AccountSessionLimit
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'World:ExemptAccountLimitStatus'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for World:ExemptAccountLimitStatus
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Mail:EnableMailSystem'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Mail:EnableMailSystem
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Mail:ExpireTrash'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireTrash
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Mail:ExpireRead'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireRead
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Mail:ExpireUnread'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Mail:ExpireUnread
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Channels:RequiredStatusAdmin'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Channels:RequiredStatusAdmin
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Channels:RequiredStatusListAll'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Channels:RequiredStatusListAll
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Channels:DeleteTimer'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Channels:DeleteTimer
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Chat:EnableVoiceMacros'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Chat:EnableVoiceMacros
[02.17. - 02:22:02] [RULES__ERROR] Unable to find rule 'Spells:TranslocateTimeLimit'
[02.17. - 02:22:02] [RULES__ERROR] Unable to interpret rule record for Spells:TranslocateTimeLimit
[02.17. - 02:22:02] [ZONE__INIT] Loaded default rule set 'default'
[02.17. - 02:22:02] [ZONE__INIT] Loading embedded perl XS
[02.17. - 02:22:02] [ZONE__INIT] Lo

seridium

02-22-2009, 04:50 AM

Bump....

Are these common errors I can ignore?

trevius

02-22-2009, 05:12 AM

You can sorta ignore those, because those errors themselves won't actually break anything. But, seeing those errors means that your database version and your server code version are not anywhere near matching, which is a huge problem. You need to make sure that your database matches the same revision of the source code you are running. It looks like your source is very old. I am guessing you are trying to run the base 1129 version from the downloads page? You need to be using the SVN to get the newer revisions. The 1129 version is very far behind at this point. We are 355 revisions after that right now which includes hundreds to thousands of changes.

seridium

02-22-2009, 05:33 AM

I did a export in sql mode and when i try and source the character_.sql I get a error

Error 1054 (42S22) : Unknown column 'instZflafNum' in 'field list'

over and over

I need help backing up the peq table files I tried exporting them as sql files but when I try to source the and I have about 100 or more accounts with allot of characters playing on it already so how would I go about backing it up so all my server users log back on after the update without them losing gear or account info?

eg. what tables? and what method so I Can just source all info back in?

seridium

02-22-2009, 08:30 AM

Ok I have backed up with navicat

Extracted the whole table.
Then Extracted just these sql's- Items list, Accounts, Character_, Character_backup Faction_List, Guild tables, Zone

I have created Custom Items and wanted to use them after updating to the peqdb_1129Rev333.sql.gz, so I have two pcs with the same server on them just incase, so I went ahead and sourced the new peqdb_1129Rev333.sql.gz and updates.

But all my custom items were gone, so I went and sourced the item file I extracted from my old DB and sourced it to the updated [peqdb_1129Rev333.sql.gz] db and I am getting this error.

---------------------------------------------
[02.22. - 06:06:48] Starting Log: logs/eqemu_debug_world_1744.log
[02.22. - 06:06:48] [WORLD__INIT] Loading server configuration..
[02.22. - 06:06:48] [WORLD__INIT] Log settings loaded from log.ini
[02.22. - 06:06:48] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[02.22. - 06:06:48] [WORLD__INIT] Connecting to MySQL...
[02.22. - 06:06:48] [WORLD__INIT] Starting HTTP world service...
[02.22. - 06:06:48] [WORLD__HTTP] Loaded mime types from mime.types
[02.22. - 06:06:48] [WORLD__INIT] Loading variables..
[02.22. - 06:06:48] [WORLD__INIT] Loading zones..
[02.22. - 06:06:49] [WORLD__INIT] Clearing groups..
[02.22. - 06:06:49] [WORLD__INIT] Clearing raids..
[02.22. - 06:06:49] [WORLD__INIT] Loading items..
[02.22. - 06:06:49] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[02.22. - 06:06:49] [WORLD__INIT] Loading guilds..
[02.22. - 06:06:49] [RULES__CHANGE] Loading rule set

And

---------------------------------------------
[02.22. - 06:06:49] Starting Log: logs/eqemu_error_world_1744.log
[02.22. - 06:06:49] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1visible,augslot2type,augslot2visible ,augslot3type,augslot3visible,augslot4type,augslot 4visible,augslot5type,augslot5visible,ldontheme,ld onprice,ldonsold,bagtype,bagslots,bagsize,bagwr,bo ok,booktype,filename,banedmgraceamt,augrestrict,lo regroup,pendingloreflag,artifactflag,summonedflag, favor,fvnodrop,endur,dotshielding,attack,regen,man aregen,enduranceregen,haste,damageshield,recastdel ay,recasttype,guildfavor,augdistiller,UNK123,UNK12 4,attuneable,nopet,UNK127,pointtype,potionbelt,pot ionbeltslots,stacksize,notransfer,stackable,UNK134 ,clickeffect,clicktype,clicklevel,clicklevel2,proc effect,proctype,proclevel,proclevel2,worneffect,wo rntype,wornlevel,wornlevel2,focuseffect,focustype, focuslevel,focuslevel2,scrolleffect,scrolltype,scr olllevel,scrolllevel2,updated from items order by id', #1054: Unknown column 'augslot1visible' in 'field list'
[02.22. - 06:06:49] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql

I tried sourcing the items-0.6.0-DR2-0.6.1-DR1-convert.sql

when I do this I get
mysql> source items-0.6.0-DR2-0.6.1-DR1-convert.sql
ERROR 1054 (42S22): Unknown column 'unknown021' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown022' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown023' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown064' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown070' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown072' in 'items'
ERROR 1054 (42S22): Unknown column 'combatskill' in 'items'
ERROR 1054 (42S22): Unknown column 'combatskilldmg' in 'items'
ERROR 1060 (42S21): Duplicate column name 'book'
ERROR 1054 (42S22): Unknown column 'unknown108' in 'items'
ERROR 1054 (42S22): Unknown column 'banedmgamt2' in 'items'
ERROR 1054 (42S22): Unknown column 'augmentrestriction' in 'items'
ERROR 1054 (42S22): Unknown column 'tribute' in 'items'
ERROR 1054 (42S22): Unknown column 'attackbonus' in 'items'
ERROR 1054 (42S22): Unknown column 'hpregen' in 'items'
ERROR 1054 (42S22): Unknown column 'hastepercent' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown125' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown126' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown127' in 'items'
ERROR 1054 (42S22): Unknown column 'distiller' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown129' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown130' in 'items'
Query OK, 62263 rows affected (18.58 sec)
Records: 62263 Duplicates: 0 Warnings: 0

ERROR 1054 (42S22): Unknown column 'unknown131' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown132' in 'items'
ERROR 1060 (42S21): Duplicate column name 'UNK121'
ERROR 1060 (42S21): Duplicate column name 'pointtype'
ERROR 1060 (42S21): Duplicate column name 'potionbelt'
ERROR 1060 (42S21): Duplicate column name 'UNK124'
ERROR 1060 (42S21): Duplicate column name 'stacksize'
ERROR 1054 (42S22): Unknown column 'hasteproclvl' in 'items'
ERROR 1054 (42S22): Unknown column 'spellid' in 'items'
ERROR 1054 (42S22): Unknown column 'focusid' in 'items'
ERROR 1054 (42S22): Unknown column 'effecttype' in 'items'
ERROR 1054 (42S22): Unknown column 'level' in 'items'
ERROR 1060 (42S21): Duplicate column name 'UNK129'
ERROR 1060 (42S21): Duplicate column name 'proceffect'
ERROR 1060 (42S21): Duplicate column name 'proctype'
ERROR 1060 (42S21): Duplicate column name 'proclevel'
Query OK, 62263 rows affected (4.81 sec)
Records: 62263 Duplicates: 0 Warnings: 0

ERROR 1060 (42S21): Duplicate column name 'worneffect'
ERROR 1060 (42S21): Duplicate column name 'worntype'
ERROR 1060 (42S21): Duplicate column name 'wornlevel'
ERROR 1060 (42S21): Duplicate column name 'UNK137'
ERROR 1060 (42S21): Duplicate column name 'focustype'
ERROR 1060 (42S21): Duplicate column name 'focuslevel'
Query OK, 62263 rows affected (4.84 sec)
Records: 62263 Duplicates: 0 Warnings: 0

ERROR 1060 (42S21): Duplicate column name 'scrolleffect'
ERROR 1060 (42S21): Duplicate column name 'scrolltype'
ERROR 1060 (42S21): Duplicate column name 'scrolllevel'
Query OK, 62263 rows affected (4.92 sec)
Records: 62263 Duplicates: 0 Warnings: 0

ERROR 1054 (42S22): Unknown column 'cost' in 'items'
ERROR 1054 (42S22): Unknown column 'casttime2' in 'items'
ERROR 1054 (42S22): Unknown column 'proc_rate_mod' in 'items'
ERROR 1054 (42S22): Unknown column 'charmformula' in 'items'
Query OK, 62263 rows affected (4.81 sec)
Records: 62263 Duplicates: 0 Warnings: 0

ERROR 1054 (42S22): Unknown column 'ldonpointtheme' in 'items'
ERROR 1054 (42S22): Unknown column 'ldonpointcost' in 'items'
ERROR 1054 (42S22): Unknown column 'gmflag' in 'items'
ERROR 1060 (42S21): Duplicate column name 'serialized'
ERROR 1060 (42S21): Duplicate column name 'verified'
ERROR 1060 (42S21): Duplicate column name 'serialization'
ERROR 1060 (42S21): Duplicate column name 'source'
ERROR 1060 (42S21): Duplicate column name 'UNK033'
ERROR 1091 (42000): Can't DROP 'charges'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'unknown001'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'collected_slot_id'; check that column/key exists

ERROR 1091 (42000): Can't DROP 'merchantprice'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'unknown004'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'collected_inst_id'; check that column/key exists

ERROR 1091 (42000): Can't DROP 'unknown006'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'spellcharges'; check that column/key exists
Query OK, 62263 rows affected (4.83 sec)
Records: 62263 Duplicates: 0 Warnings: 0

Query OK, 5 rows affected (0.67 sec)
Rows matched: 5 Changed: 5 Warnings: 0

Query OK, 0 rows affected (0.66 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.66 sec)
Rows matched: 3641 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.66 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql>

any idea's of what I am doing wrong to get my items into the mix again?

trevius

02-22-2009, 06:02 PM

I am not sure what that conversion sql stuff is, but it looks really old. It looked like you were closer before you started running those. Your first error shows this:

Unknown column 'augslot1visible' in 'field list'

Which is an issue that means you are trying to update your database with a new items table, but the existing items table is designed wrong. The augslot1visible used to be named differently until a recent change. You should just need to make sure that you run the SQL to change that field in your table before sourcing your items back in. Here is the SQL change from R292:

alter table items drop column augslot1visible;
alter table items drop column augslot2visible;
alter table items drop column augslot3visible;
alter table items drop column augslot4visible;
alter table items drop column augslot5visible;

alter table items change column `augslot1unk` `augslot1visible` tinyint(3);
alter table items change column `augslot2unk` `augslot2visible` tinyint(3);
alter table items change column `augslot3unk` `augslot3visible` tinyint(3);
alter table items change column `augslot4unk` `augslot4visible` tinyint(3);
alter table items change column `augslot5unk` `augslot5visible` tinyint(3);

seridium

02-22-2009, 09:40 PM

I have no idea how this is done?

You should just need to make sure that you run the SQL to change that field in your table before sourcing your items back in. Here is the SQL change from R292:

Guidance Please :P

Where do I find th esql to run to fix that ?

seridium

02-22-2009, 10:15 PM

trevius

02-22-2009, 11:52 PM

If you haven't already put alot of work into your database yet, then you would probably be best off just starting over with a fresh database. You can always copy in your player-related tables later if needed. Judging by the different errors you have gotten and different things it sounds like you have done, I have no idea what state your current database may be in. Did you back up your database before hand? As long as you have a backup, you can always source that back in to replace anything that has changed. Then you will just need to run any needed SQL changes from the source code to get it updated to run with the version of server code you are wanting to run.

First off, you need to figure out exactly what versions of Database and Server code you are running. Post that here and maybe we can help you. Otherwise, it seems like you may have been making things worse and not easily recoverable. Really, someone with more database experience than I would be better to help with this though, so don't take everything I say as a fact :)

If you are running a PEQ database, it should be fairly easy to get things going once you have matching versions of database and server code. I think the PEQ forums probably have more information on that subject than you will find here though.

seridium

02-23-2009, 01:42 AM

Well I have altered 5 zones with custom loot tables for every mob in featured zones, server quests, over 25 custom items, and I really don't want to do it all over again it seems the only issue I am having is with the items not laoding.

My DB is 070_pop_cvs I sourced the peqdb_1129Rev291.sql then the updates after installing emu added quests etc.

then I decided to update by sourcing the new peqdb_1129Rev333.sql and all updates, I figured I Could add all my custom db data by sourcing these files I extracted.

Files I extracted with NAvicat from my working server tables:
Account.sql
character_.sql
character_backup.sql
character_Activities.sql
character_enablestasks.sql
character_tasks.sql
inventory.sql
items-0.6.0-DR2-0.6.1-DR1-convert.sql
lootdrop.sql
lootdrop_entries.sql
lootable.sql
lootable_entries.sql
variables.sql
zone.sql

I did also make a backup of all tables in one file. so I could just source and make it back to normal.

But after trying to source character_.sql and getting an error I figured ok I will just make a sql file with what i needed into one file so I added the above files into one .sql instead of individual files and it seemed to put all my Character info back into effect levels zone flags etc were all good except the Item error?

I can re source the peqdb_1129Rev333.sql and it loads fine no errors but no items I made either :(

__________________________________________________ ______________

I am testing this on a second pc with the same server setup as the one I am running, I am doing this to avoid server downtime so its not like my server is all screwed or nothing but it would be nice to not have to make all my items all over again or my zone changes etc.

trevius

02-23-2009, 02:10 AM

To get the items you had before, you would need to source your old database again (you can even do it into a new database name so you don't have to delete the one you have now), then, run the update that I posted above to adjust the items table so it is compatible with current DBs. Then, just dump the items table alone to sql. Last, just source that items sql file you made into your existing database. It should now be updated with the new field change and be compatible with the new items table adjustment.

seridium

02-23-2009, 03:19 AM

Thanks for the info trevius but I am not sure how to run that update?

I cant find a rev292 update in the updates folder I just downloaded the peq_db too.

seridium

02-23-2009, 04:00 AM

Thanks for the info trevius but I am not sure how to run that update?

I cant find a rev292 update in the updates folder I just downloaded the peq_db too.

Ok I get it make a notepad file with info you posted and renamed it .sql sourced it trying now Thanks man...

seridium

02-24-2009, 01:46 AM

OK I have one last question regarding this matter.

Ok on my working server that is all working order atm, what would happen to my accounts characters items etc if I just updated with peqdb_1129Rev333.sql? does that delete all my server db info ?

trevius

02-24-2009, 01:52 AM

Yes, if you run any SQL updates that update full tables (like I think those do), they will delete the current table completely, rebuild the table and fill it from scratch.

seridium

02-24-2009, 02:37 AM

Well I tried to source the DB mentioned on the running server and I got a mysql disconnect error and now it wont connect to mysql :) fun fun

seridium

02-24-2009, 03:25 AM

Well I tried to source the DB mentioned on the running server and I got a mysql disconnect error and now it wont connect to mysql :) fun fun

The bad part is it dissconnects me during DB sourcing, then everytime I try and source peqdb_1129Rev333.sql I get this error
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

why would the update disconnect me, I think it has something to do with the items table.

seridium

02-24-2009, 06:05 PM

I cannot figure out why I can't update peqdb-1129Rev333.sql? anyone else had this problem?

seridium

02-25-2009, 01:05 PM

Well like I said above i load up that db and source it and mysql drops connection and I also noticed after doing this my pc wil now crash constantly is this normal? what version of MYSQL Should I use like come on no one else had this problem?

Iwasseridium

03-02-2009, 06:34 PM

Well I am still having this problem can anyone help???

Why would mysql get syntaxx errors during installation of peqdb_1129Rev333.sql was there an error with this update???

Iwasseridium

03-02-2009, 09:00 PM

trevius

03-02-2009, 09:08 PM

Sounds like you already had the update applied when you ran that SQL. That means that you already had the new fields and just removed them so you no longer have them at all.

You will either need to resource the entire items table, or add those new fields back in manually and populate them as needed (which may be a pain to get all items set correctly).

Iwasseridium

03-02-2009, 09:59 PM

What do these rules errors actually mean my server works ?

trevius

03-02-2009, 10:51 PM

As I have already said here and many other threads; If you are getting errors about rules not being found, then your server code is older than your database is and they NEED to match. The actual rules errors don't mean anything, but 99% of the time, if your source doesn't match your database, there are other SQL updates you are missing that will definitely cause major issues.

Iwasseridium

03-03-2009, 12:11 AM

I have tried updating to the newest Revisions361 with the peqdb_1129Rev360 and all updates, without installing my items and I get the server to load and it still has the errors so I am done with this install I would like to start from fresh and maybe just maybe it will work this time with no errors :)
So ya how do you uninstall this peq can I just drop_players drop_system would that be correct? or would I just delet the whole data base peq and make a fresh one then source in info?

When I reinstall the new peqdb_1129Rev360 from fresh do I Source all files in the peq_db folder that are downloaded along with the peqdb_1129Rev360.gz file such as accounts.sql etc and then source all updates?