PUBLIC: Database 'Bug' Reports

[Etaew]

Seems to me your implementation field is set to a VALUE of NULL not to a NULL VALUE

[Tolakram]

Seems to me your implementation field is set to a VALUE of NULL not to a NULL VALUE

Ha, sure enough that's the problem.

update ability set implementation = NULL where implementation = 'NULL'

I wonder if that's a bug in the program I used to import (SQLManager)?

[mico]

Seems to me your implementation field is set to a VALUE of NULL not to a NULL VALUE

Ha, sure enough that's the problem.

update ability set implementation = NULL where implementation = 'NULL'

I wonder if that's a bug in the program I used to import (SQLManager)?

try to use the mysql command line client .

[Tolakram]

I just noticed that the world package was not updated (still the march Is there a reason it wasn't updated? Thanks.

[Etaew]

I just noticed that the world package was not updated (still the march Is there a reason it wasn't updated? Thanks.

Not sure if we changed anything, haven't really seen Overdriven online lately.

[Xiox]

yeah it is.. I think this includes the zone.sql which is nolonger needed because it's called from XML

I'm not sure if I'll be able to hit the final deadline on the fixed ItemTemplate.sql dump tonight... we'll see.

[Etaew]

Fixed the world_package release.

[sio]

So i really don`t know if this is the correct thread or if this is already fixed.

The Front AE Pulse should be instant.

http://www.camelotherald.com/spells/lin ... 4&line=127

sio

[Etaew]

Fixed the drop package release, any reason why the database team isn't doing this?

[Etaew]

Fixed the specs package.

[Deniska]

Greetings. Small report [:. Maybe it's not so important.
Problem in ItemTemplate table. "Condition" - is a reserved keyword in MySQL 5.x, that's why i got an error when importing ItemTemplate.sql from Item Package. How to fix - just replace all strings _Condition with _`Condition`, where "_" - is a space. I don't know is that word reserved in MySQL 4.x. Hope this help. Note that also exists "MaxCondition" field, that's why a space before "Condition" in replace is important(without space it will replace "MaxCondition" with "Max`Condition`").

[Tolakram]

Howdy,

thanks for the fixes to the database. Here are the problems I've run into with the latest packages:

Code: Select all

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("b236426-c325135", "Combat Awareness", "Combat Awareness", NULL, 3090, "DOL.GS.RealmAbilities.CombatAwarenessAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("525v245-v55v253", "Desperate Bowman", "Desperate Bowman", NULL, 3060, "DOL.GS.RealmAbilities.DesperateBowmanAbility");


NULL not allowed for description, change to ""

=====================================

LootTemplate

Unknown column 'Realm' in 'field list'

There is no realm column. Easiest fix is to add the realm column, run the script, and then, if you want, delete the realm column.

ALTER TABLE `daoc`.`loottemplate`
ADD COLUMN `Realm` INTEGER UNSIGNED NOT NULL DEFAULT 0
AFTER `Chance`;

=====================================

There are a few duplicate mobs. It's not easy to automagically find them but you can use the following to help:

select name, count(name) from mob
where binary name <binary> 1;

Then you can jump to the suspect mobs and if they really are bad dupes get rid of them.

[Tolakram]

My SQL got grunged, here it is again:

select name, count(name) from mob
where binary name <> binary lower(name)
group by name
having count(name) > 1;

[Tolakram]

door.sql

Door does not have the columns KeepID and Health so remove them from the insert column list and then replace all occurances of

, null, null),

with

),

then modify the last line in the file manually.

INSERT INTO `door` (`Door_ID`, `Name`, `Z`, `Y`, `X`, `Heading`, `InternalID`)
VALUES
('0007f63f-d53e-4e4c-80f1-d7b4ae59bf17', 'door', '14433', '30341', '37280', '3081', '24001901'),

etc.

[sio]

http://support.darkageofcamelot.com/kb/ ... php?id=936

- A new line of Direct Damage (DD) spells has been added to Midgard’s Suppression baseline.

Level Name Target Cast/Duration/Recast Range/Radius Effect Cost

4 Spirit Burden Enemy 2.6/0/0s 1500 range 13 (Spirit) 3
6 Spirit Curse Enemy 2.6/0/0s 1500 range 21 (Spirit) 4
9 Spirit Oppression Enemy 2.6/0/0s 1500 range 29 (Spirit) 5
12 Spirit Burial Enemy 2.6/0/0s 1500 range 37 (Spirit) 6
16 Soul Burden Enemy 2.6/0/0s 1500 range 49 (Spirit) 8
21 Soul Curse Enemy 2.6/0/0s 1500 range 64 (Spirit) 10
27 Soul Oppression Enemy 2.6/0/0s 1500 range 85 (Spirit) 14
34 Soul Burial Enemy 2.6/0/0s 1500 range 108 (Spirit) 19
43 Doom of Spirits Enemy 2.6/0/0s 1500 range 136 (Spirit) 23
48 Death of Souls Enemy 2.6/0/0s 1500 range 179 (Spirit) 30


- Two spells were removed from the baseline suppression line in order to make room for the DD spells.

4 Lesser Magic Shield
8 Disperse Strength


- The level 6 root spell, Diffuse Movement, in Midgard’s Suppression baseline has been moved to level 8.

Code: Select all

insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('spirit_burden','7500','7500','7500','Spirit Burden','Damages the target.','Enemy','1500','3','2.6','13','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('sprit_curse','7501','7501','7502','Spirit Curse','Damages the target.','Enemy','1500','4','2.6','21','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('spirit_oppression','7502','7502','7502','Spirit Oppression','Damages the target.','Enemy','1500','5','2.6','29','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('spirit_burial','7503','7503','7503','Spirit Burial','Damages the target.','Enemy','1500','6','2.6','37','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_burden','7504','7504','7504','Soul Burden','Damages the target.','Enemy','1500','8','2.6','49','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_curse','7505','7505','7505','Soul Curse','Damages the target.','Enemy','1500','10','2.6','64','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_oppression','7506','7506','7506','Soul Oppression','Damages the target.','Enemy','1500','14','2.6','85','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_burial','7507','7507','7507','Soul Burial','Damages the target.','Enemy','1500','19','2.6','108','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('doom_of_spirits','7508','7508','7508','Doom of Spirits','Damages the target.','Enemy','1500','23','2.6','136','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('death_of_souls','7509','7509','7509','Death of Souls','Damages the target.','Enemy','1500','30','2.6','179','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');


Code: Select all

insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('death_of_souls','Suppression','7509','48');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('doom_of_spirits','Suppression','7508','43');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('soul_burden','Suppression','7504','16');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('soul_burial','Suppression','7507','34');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('soul_curse','Suppression','7505','21');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_burden','Suppression','7500','4');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_burial','Suppression','7503','12');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_curse','Suppression','7501','6');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_oppression','Suppression','7502','9');


sio