[SQL] Database errors #11587

Closed
Fateswhisper opened this Issue Feb 10, 2014 · 17 comments

Projects

None yet

6 participants

@Fateswhisper

rev: b722730
Errors logs: http://pastebin.com/595nJZwQ
Some fixes:

UPDATE item_template SET Material = -1 WHERE `entry` IN (52202, 50435, 49334, 46055, 46054, 44851, 43964, 43963, 43304, 43303, 43302, 42590, 41811, 41804, 40777, 40389, 40307, 38265, 37827, 37348, 37346, 37345, 37343, 37338, 37337, 37336, 37335, 37329, 37326, 37126, 36942, 35854, 34030, 33610, 33604, 33475, 33316, 33121, 31266, 30595, 29565, 29225, 29120, 29041, 28676, 27863, 27419, 25877, 23952, 23882, 23378, 23360, 23330, 23227, 23224, 23193, 23157, 22899, 22387, 22386, 21591, 21578, 21577, 21560, 21159, 21152, 21043, 20524, 20020, 20005, 20003, 19986, 18303, 18153, 16082, 15780, 11903, 11672, 11671, 11616, 11613, 11111, 8993, 6650, 5531, 5515, 5410, 5400, 5353, 4868, 4749, 4704, 4524, 4200, 3584, 3513, 3316, 3168, 3122, 2755, 2668, 2638, 2599, 1672, 1356, 1352, 996, 960, 958, 956, 900, 813, 734, 35840, 35777, 35555, 34967, 34746, 34745, 34744, 34743, 34742, 34741, 34740, 34739, 34738, 34737, 34735);
UPDATE item_template SET sheath = 0 WHERE `entry` IN (20003, 20005, 38469);
UPDATE item_template SET Material = 0 WHERE  `entry`=34187;
UPDATE item_template SET Material = 5 WHERE  `entry`=34025;
UPDATE item_template SET sheath = 1 WHERE  `entry`=36603;
UPDATE item_template SET sheath = 3 WHERE  `entry`=36561;
UPDATE item_template SET InventoryType = 12 WHERE `entry`=40727;
UPDATE item_template SET subclass = 0 WHERE `entry`=33604;

p.s. cataclysm items ... what to do with them? Why are they here?

@untaught
Contributor

Use

WHERE `entry` IN (,)```
@Aokromes
Member

What cata items?

@MrSmite
Contributor
MrSmite commented Feb 11, 2014

Question: Your revision, b722730, is from "master" which is 335a but in my DB none of the items you're fixing exist at all. Are you sure you have the correct repo / SQL?

SELECT * FROM `item_template` WHERE `entry` IN (52202, 50435, 49334, 46055, 46054, 44851, 43964, 43963, 43304, 43303, 43302, 42590, 41811, 41804, 40777, 40389, 40307, 38265, 37827, 37348, 37346, 37345, 37343, 37338, 37337, 37336, 37335, 37329, 37326, 37126, 36942, 35854, 34030, 33610, 33604, 33475, 33316, 33121, 31266, 30595, 29565, 29225, 29120, 29041, 28676, 27863, 27419, 25877, 23952, 23882, 23378, 23360, 23330, 23227, 23224, 23193, 23157, 22899, 22387, 22386, 21591, 21578, 21577, 21560, 21159, 21152, 21043, 20524, 20020, 20005, 20003, 19986, 18303, 18153, 16082, 15780, 11903, 11672, 11671, 11616, 11613, 11111, 8993, 6650, 5531, 5515, 5410, 5400, 5353, 4868, 4749, 4704, 4524, 4200, 3584, 3513, 3316, 3168, 3122, 2755, 2668, 2638, 2599, 1672, 1356, 1352, 996, 960, 958, 956, 900, 813, 734, 35840, 35777, 35555, 34967, 34746, 34745, 34744, 34743, 34742, 34741, 34740, 34739, 34738, 34737, 34735);
SQLyog:

0 row(s) returned

Execution Time : 0.002 sec
Transfer Time  : 0 sec
Total Time     : 0.002 sec
@Fateswhisper

Aokromes, I was wrong. Spell confused me.
MrSmite, error appeared after:
94b912f

@Aokromes Aokromes added a commit that referenced this issue Feb 11, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
By Fateswhisper, updates #11587
96c50c4
@MrSmite
Contributor
MrSmite commented Feb 12, 2014

I still don't understand why this is being applied to Master. The comment in 94b912f says:

the uncommented ones are the columns that are no longer in Item-sparse.db2

That is Cataclysm content but "Master" is 3.3.5a, not Cataclysm.

@untaught
Contributor

Nope, it's not a Cataclysm content.

@untaught
Contributor

12 0 must be the right combination because it's a quest item.

@Aokromes
Member

MrSmite: they exist on item.dbc, of wow 3.3.5a, so they are 3.3.5a items.

@MrSmite
Contributor
MrSmite commented Feb 12, 2014

MrSmite: they exist on item.dbc, of wow 3.3.5a, so they are 3.3.5a items.

Not necessarily. As is being discussed here, the fact they are in a DBC doesn't necessarily make them 335a content. A lot of that stuff wasn't available until 401 which makes it unnecessary to add them to 335a.

@Aokromes Aokromes referenced this issue Feb 16, 2014
Closed

START ERROR #11536

@joschiwald
Member

about creature_template stuff, no

@Aokromes Aokromes added a commit that referenced this issue Feb 20, 2014
@Aokromes Aokromes DB/Misc: Fix some startup errors
Updates #11587
419287e
@Aokromes Aokromes added a commit that referenced this issue Feb 20, 2014
@Aokromes Aokromes DB/Misc: Fix more startup errors
By Fateswhisper and me. Updates #11587
NOTE: ref "Missing WDB data." we have more of those and since i don't fill WDBVerified it's correct.
160d024
@Aokromes
Member
@Aokromes Aokromes added a commit that referenced this issue Feb 23, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
Updates #11587
392f95a
@Aokromes Aokromes added a commit that referenced this issue Feb 23, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
Updates #11587
a5d860c
@Aokromes Aokromes added a commit that referenced this issue Mar 6, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
Updates #11587
b8cfd27
@Aokromes Aokromes added a commit that referenced this issue Mar 16, 2014
@Aokromes Aokromes DB/Misc: Fix more startup errors
Updates #11587
3ce545a
@Gacko
Member
Gacko commented Mar 19, 2014
SmartAIMgr: Entry 24601 SourceType 0 Event 2 Action 33 Kill Credit: There is a killcredit spell for creatureEntry 25987 (SpellId: 46377 effect: 0)

This needs to be scripted as the credit spell should be casted by the summoned unit on its master and not by the killed creature which gets an aura from the summoned unit.

@untaught
Contributor
UPDATE `smart_scripts` SET `action_type`=86, `action_param1`=46377, `action_param2`=3, `action_param3`=19, `action_param4`=25987, `action_param5`=50, `target_type`=19, `target_param1`=25987, `target_param2`=50 WHERE `entryorguid`=24601 AND `source_type`=0 AND `id`=2 AND `link`=0; 
@Aokromes Aokromes added a commit that closed this issue Mar 22, 2014
@Aokromes Aokromes DB/SAI: Fix startup error
By untaught, closes #11587
75f16f0
@Aokromes Aokromes closed this in 75f16f0 Mar 22, 2014
@untaught
Contributor

This was fast!

@Gacko
Member
Gacko commented Mar 22, 2014

If there is a totem from an other player closer to the killed creature than the one of the player who actually killed the creature the other one will get the kill credit! The totem used to gather the energy of the killed creature periodically applies an aura which should be scripted imho.

@untaught
Contributor

Yup, you are right.

@Gacko
Member
Gacko commented Mar 23, 2014

Your fix works and "kills" the warning. I'll create a reminder issue for myself for the mentioned script ;)

@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
By Fateswhisper, updates #11587
861e67a
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/Misc: Fix some startup errors
Updates #11587
440e12d
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/Misc: Fix more startup errors
By Fateswhisper and me. Updates #11587
NOTE: ref "Missing WDB data." we have more of those and since i don't fill WDBVerified it's correct.
a0aa725
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
Updates #11587
91cb016
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
Updates #11587
b7552be
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/Items: Fix some startup errors
Updates #11587
bfe4bcc
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/Misc: Fix more startup errors
Updates #11587
66dbae2
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@Aokromes Aokromes DB/SAI: Fix startup error
By untaught, closes #11587
a5d5ca1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment