PUBLIC: Database 'Bug' Reports

[Haji]

1062 - Duplicate entry '0' for key 1


While trying to query ability.sql

[IStandAloneToo]

Yes because these are just insert statements. They are most likely already in your table. However, it is only a few fixes which you can easily do yourself .

[Deniska]

Necrotopic O_o but..
DB 1.901 package.
Bard don't have 7 spells from Regrowth Bard Spec ( Greater Heal ).
Spell names(spellid) are: Greater Revival(4861), Greater Regeneration(4862), Greater Regrowth(4863), Greater Restoration(4864), Greater Resuscitation(4865), Greater Renascence(4866) and Greater Apotheosis(4867).
How to fix:

Code: Select all

INSERT INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) VALUES ('Regrowth_Bard_Spec_Greater_Heal1', 'Regrowth Bard Spec', '4861', '9'), ('Regrowth_Bard_Spec_Greater_Heal2', 'Regrowth Bard Spec', '4862', '14'), ('Regrowth_Bard_Spec_Greater_Heal3', 'Regrowth Bard Spec', '4863', '19'), ('Regrowth_Bard_Spec_Greater_Heal4', 'Regrowth Bard Spec', '4864', '25'), ('Regrowth_Bard_Spec_Greater_Heal5', 'Regrowth Bard Spec', '4865', '32'), ('Regrowth_Bard_Spec_Greater_Heal6', 'Regrowth Bard Spec', '4866', '41'), ('Regrowth_Bard_Spec_Greater_Heal7', 'Regrowth Bard Spec', '4867', '50');


I set Greater Revival's level to 9 because if lvl 10 is set he conflict with Minor Reconstitution(Regrowth spec, spellid 4831) ( i don't know why, they are in different spell lines /: ).

[Graveen]

Thx Deniska.

[Deniska]

Heretic
Don't have 7 spells in Heretic Rejuvenation Spec ( Heal ). Spell names(spellid) are: Major Restoration(1351), Major Recuperation(1352), Major Renewal(1353), Major Resuscitation(1355), Major Reviction(1356), Major Refection(1357) and Major Refocillation(1358).

How to fix:

Code: Select all

INSERT INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) VALUES
('Heretic_Rejuvenation_Spec_Heal1','Heretic Rejuvenation Spec', '1351', '7'),
('Heretic_Rejuvenation_Spec_Heal2','Heretic Rejuvenation Spec', '1352', '8'),
('Heretic_Rejuvenation_Spec_Heal3','Heretic Rejuvenation Spec', '1353', '11'),
('Heretic_Rejuvenation_Spec_Heal4','Heretic Rejuvenation Spec', '1355', '18'),
('Heretic_Rejuvenation_Spec_Heal5','Heretic Rejuvenation Spec', '1356', '24'),
('Heretic_Rejuvenation_Spec_Heal6','Heretic Rejuvenation Spec', '1357', '33'),
('Heretic_Rejuvenation_Spec_Heal7','Heretic Rejuvenation Spec', '1358', '43')


"Major Restoration" lvl set to 7(correct lvl is 5, but 5 and 6lvls are used for other spells from Heretic Rejuvenation Spec), "Major Reviction" lvl set to 24(correct 25, but 25 and 26 are used too).

Also, "Reanimate Corpse"(spellid 14075) from Heretic Rejuvenation Spec(Resurrection (Monster)) placed in "Heretic Enhancement Spec". In charplan 1.6.14 and on camelotherald it's in Rejuv Spec.
How to fix:

Code: Select all

UPDATE `linexspell` SET `LineName` = 'Heretic Rejuvenation Spec' WHERE CONVERT( `linexspell`.`LineXSpell_ID` USING utf8 ) = 'f252525-f25252-5f252353' LIMIT 1 ;


EDIT: Reanimate Corspe spell have duration 45s. Correct value = 20s.

Code: Select all

UPDATE `spell` set `Duration` = '20' where `SpellID` = '14075'

[Graveen]

on bard corrections i have checked official DB, it is ok.
i'll have a look for heretic.

btw thx

[Deniska]

I do not modify tables from DB 1.901.zip /:. I'll download again DB package and recheck - maybe some tables was fixed. Sorry.

[Graveen]

ok. in all cases, official DB is not public so tweaks you post here could have to be fixed into it too, this is why i check

[WisdomConners]

DBHouse

Creation date is 0-0-0 0:0:0 which is a valid MySQL date but does not convert in the latest DOL code. I fixed it by running:

update dbhouse set creationtime = now();

Is there somewhere we can download an update DBHouse.sql? I've tried using Navicat 8 to change the creation dates from 0000-00-00 00:00:00 to now() and I get a message saying: 1292 - Incorrect datetime vaule; now()' for column 'CreateTime' at row 1

[Etaew]

Code: Select all

UPDATE `house` SET `CreationDate` = NOW();

[WisdomConners]

Code: Select all

UPDATE `house` SET `CreationDate` = NOW();

Ok, so this must be something that has to be done via C#. I'm not there yet.

[Etaew]

MySQL

[WisdomConners]

Ah, it helps if I use the actual DOL database and type `CreationTime` for the field that actually exists and not `CreationDate` as you listed. Hopefully once the rest of my SQL's finish loading I'll be up and testing again.

[Merec]

General fix for SQL dumps:

Use

Code: Select all

REPLACE INTO tablename (field1, field2, field3) VALUES ('value1', 'value2', 'value3')

instead of

Code: Select all

INSERT INTO tablename (field1, field2, field3) VALUES ('value1', 'value2', 'value3')

If the primary key ist allready in the table, the entry will be replaced with the new values vom dump, otherwise the new entry will be inserted.
This will fix problems caused by double primary keys.

bye