theghostgroup / trinitydb Goto Github PK

What steps will reproduce the problem?
1. Run TrinityRealm.exe
2. Run TrinityCore.exe
3. Check ../Logs/db_errors.log

What is the expected output? What do you see instead?
Expectation: no errors.
what do i see: 475 lines that all say "Table `achievement_criteria_data`
not have expected data for criteria"

What version of TDB? What version of the core (LATEST is NOT acceptable)?
TDB Version: 333.9.29_7925
Core version: Rev 8047 Release Hash: e468cdaf3fcb


Please provide any additional information below.

What steps will reproduce the problem?
Nightsabers stalkers in the Night Elf starting area are level 80. Possible
typo.

What is the expected output? What do you see instead?
They are meant to be level 7 to 8.

What version of the product are you using? On what operating system?
Rev 6928 with TDB 0.0.7 + repo updates running on Fedora 11.

Please provide any additional information below.
http://www.wowhead.com/?npc=2043
Also provided my fix.

What steps will reproduce the problem?
1. Go to Darnassus and ask a guard about Scribe trained
2. He mars in the map "Feyden Darkin"
3. Nobody in the house when you arrive to the mark.

What is the expected output? What do you see instead?
Feyden Darking (Scribe Trainer) must be in the mark location. But dont 
appear in Darnassus

What version of TDB? What version of the core (LATEST is NOT acceptable)?
TBC 333.9.29  & TC2 7965

Please provide any additional information below.
I see than Feyden Darking exists in the BD (GUID: 30715) and you can create 
it via ".npc add 30715"

I suppose than near the trainer must be a Scribe Supplier vendor too, but i 
dont have an offy account to verify that.

What steps will reproduce the problem?
1. Resistance Paladin is bugged when he use all cast spells on him get
resist from this
2.
3.

What is the expected output? What do you see instead?


What version of TDB? What version of the core (LATEST is NOT acceptable)?


Please provide any additional information below.

What steps will reproduce the problem?
1. At Last Wintergrasp Door has broken exists an invisible wall that block 
players to get relic 

What steps will reproduce the problem?
1. Have lvl 70 and high fishing skill (not sure about the skill level)
2. Go to Marcia Chase at Dalaran (npc=28742)
3. Get one of the six daily quests she offers (quest=13830, 13832, 13833, 
13834, 13836, 
24806)

What is the expected output? What do you see instead?
After completion, you receive Bag of Fishing Treasures (item=46007), which 
should contain 
some items (http://www.wowhead.com/?item=46007#contains).
The bag comes empty, however.

What version of TDB? What version of the core (LATEST is NOT acceptable)?
TDB_332.8.26_7332

TrinityCore Rev: 7537 Release Hash: 7a12de4c94b4 (Unix,little-endian) 
(core-daemon) on both 
Mac OS X and Linux.

What steps will reproduce the problem?
1. Head to the Riplash Ruins in Borean Tundra
2. Talk to Kurak and start/complete all quests till you get quest 11626, 
[The Emissary]
3. You will have to kill Leviroth and notice he's NOT spawned at all (in 
the clove underwater)

What is the expected output? What do you see instead?
Leviroth should be spawned below an iceberg close to Northern Riplash but 
he's not. He also needs a script because item 35850, [Trident of Naz'jan], 
needs to be used on him to impale him.

What version of TDB? What version of the core (LATEST is NOT acceptable)?
332.8 + all updates

Please provide any additional information below.
Also reported this issue for TrinityCore, because of the script.

What steps will reproduce the problem?
1. ghoul skill (when come out they dont fight scarlet crusader guarding
around the building
2. scarlet crusader seem like not seeing from the distance they should fire
range attack to the eye while getting near and change to malee when they
close enoughe to use malee
3. skill recall eye is not working as it should be, u need to click buff to
cancel its effect for cancelling
4. eventai seem dont happen same like blizz server
5. eye should not being attack only one hit and dismount from the eye, the
eye has some hp to hold some damage

What is the expected output? What do you see instead?
above

What version of the product are you using? On what operating system?
6862x64 tdb0.0.7 windows7 64

Please provide any additional information below.
----

The DK's pet[26125] obtained via Raise Dead[46584] has around 1300 hp at
level 80 , with glyph and talented.Without them it has ~400.
007 , up23 db

Problem description:
I'm Resto/Balance specced and geared, and found out that in cat/bear form,
some abilities do too much damage:

Rake(cat):
http://www.wowhead.com/?spell=48574

Lacerate(bear):
http://www.wowhead.com/?spell=48568

Swipe (bear):
http://www.wowhead.com/?spell=48562

Rake hits for 1.2k initially, swipe hits for 2k each target, lacerate for
1700 damage initially, then 500 damage with only 1 stack. My AP is 1000
with my gear, 500 without ANY gear. If I take it all off, the damage goes
back to a normal (ungeared) damage. Since my gear has SP, intelect and
spirit boosts, instead of AP boosts.

Also, attacking completly naked or with Titan-forged Rune of Audacity makes
the damage done change.

All this would make me think that the formula is using SP instead of AP (I
have ~2k SP).

Also, my Entangling Roots is doing too much damage. It's supposed to do
~450 damage over 27 secs, but does about that damage on EACH hit.

I did some duels with Jack (PvP) and both low and high level mobs. The
problem happens everytime.

I've been trying to test it with another resto/balance druid with SP gear,
but couldn't find any on =/

Link: All linked above.
Recent changes: 3.2.2a - I don't recall this happening before
I have Googled, searched the forums, and read the FAQ: Yes, kind of Smile


What version of TDB? What version of the core (LATEST is NOT acceptable)?
tdb 007 7282 unix tc2

What steps will reproduce the problem?
1. Head to Zeb'Hallak in Grizzly Hills and go underwater in the lake
2. Try to find the Waterweed which is spawned there on the bottom
3. Try to use it, it'll say: "This is already beging used" 

What is the expected output? What do you see instead?
The object should be useable and should give the player [Waterweed Frond] 
(I_ID: 35795). This can be fixed by putting a new spawn of object 188351 
there.

What version of TDB? What version of the core (LATEST is NOT acceptable)?
Core Rev:7736
Operating system: Windows 7 Ultimate
Database: TDB 332.8

Please provide any additional information below.
Current guid of the not working object with TDB332.8: 500681

What steps will reproduce the problem?
1. http://www.wowhead.com/?npc=25523

What is the expected output? What do you see instead?
lvl 68-69 expected but there is 1 lvl

What version of TDB? What version of the core (LATEST is NOT acceptable)?
0.0.7 updatepack 23 with Trinitycore updates (rev. 7217)

Please provide any additional information below.

UPDATE creature_template SET minlevel=68, maxlevel=69 WHERE entry=25523;

What steps will reproduce the problem?
1.some scarlet crusader are unattackable
2.some npc keep towarding to stuck and can not click to accept quest
3.

What is the expected output? What do you see instead?
scarlet should b attackable for questing
npc should fly over around spawn point and able accept the quest

What revision of the Core are you using? On what operating system?
windows 7 64 6862 tdb 0.0.7 

Please provide any additional information below.
3.1.2 works find with this problem

Trespasser! isnt working correctly on the ally place the npcs "spam" the 
spell and on the horde side you get teleported away when in the barbershop.

Tanaris Field Sampling is changed since the last patch
http://wowhead.com/quest=654

no need 8 acceptable sample for each 3 kind of items

Trinity Revision: 7782 Database Version: TDB 332.8.28 

quak

What steps will reproduce the problem?
1. Starting up the server and the errors (see attached log) appear

What is the expected output? What do you see instead?

Appeared at 0.0.7 update but removed the creature_addon errors

What version of TDB? What version of the core (LATEST is NOT acceptable)?

0.0.7 Rev 7223

Please provide any additional information below.

What steps will reproduce the problem?
1. the imp of blackrock summoner swipe?? malee swing about 200-300??
make player about level 20 died by 1 hit 
2.
3.

What is the expected output? What do you see instead?
the imp walk near the player and malee attack with swing 200-300


What version of the product are you using? On what operating system?
7055x64 windows 7x64

Please provide any additional information below.

normally imp should not use malee attack even the are run out of mana, they
use only spell

What steps will reproduce the problem?
1.Even as a warrior with .learn all_myclass , or normally assigning your 
talents as Fury , won't make Titan's Grip possible. 

What is the expected output? What do you see instead?

You get the message : This item cannot be equipped.

What version of TDB? What version of the core (LATEST is NOT acceptable)?

333.9.31 and 335.10.32 , older ones seem to work

Please provide any additional information below.

What steps will reproduce the problem?
1. fight against Herald Volazj in Ahn'kahet
2. take him down to low HP
3. let him cast Madness and spawn some adds that look like your group members

What is the expected output? What do you see instead?
Normally you should kill those Adds, but you can't attack them. And 'cose
they aren't killable, it's not possible to kill the boss.

What revision of the Core/DB are you using? On what operating system?
Core : 72xx on Debian Linux
DB: Update Pack 24

Please provide any additional information below.

I cannot deliver stolen horse to Salanar. If i use it, nothing happened.
Please fix it.

What steps will reproduce the problem?
1.get priest add Glyph of Dispel Magic
2.dispel some effect
3.watch health gained

What is the expected output? What do you see instead?
priest have to get 3% oh health from dispel, he gains 3% + spell bonus * x

What version of TDB? What version of the core (LATEST is NOT acceptable)?
8205rev, DB 9.29_7925 + core updates

Please provide any additional information below.
fix, simply adds Glyph of Dispel Magic spell to spell_bonus_data table and
sets appropriate values.
Fix:

-- 8371_world_spell_bonus_data.sql
DELETE FROM `spell_bonus_data` WHERE `entry` IN (56131,56160,52725,55533);
INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, 
`ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
(56131, 0, 0, 0, 0, 'Priest - Glyph of Dispel Magic'),
(56160, 0, 0, 0, 0, 'Priest - Glyph of Power Word: Shield'),
(52752, 0, 0, 0, 0, 'Ancestral Awakening'),
(55533, 0, 0, 0, 0, 'Shaman - Glyph of Healing Wave');

in update pack 31 it deletes the wrong entry... it delete 52725 and it should 
be 52752 for Ancestral Awakening. I verified with wowhead.com and 52752 is the 
proper number, so what is inserted is correct.


The fix:
-- 8371_world_spell_bonus_data.sql
DELETE FROM `spell_bonus_data` WHERE `entry` IN (56131,56160,52752,55533);
INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, 
`ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
(56131, 0, 0, 0, 0, 'Priest - Glyph of Dispel Magic'),
(56160, 0, 0, 0, 0, 'Priest - Glyph of Power Word: Shield'),
(52752, 0, 0, 0, 0, 'Ancestral Awakening'),
(55533, 0, 0, 0, 0, 'Shaman - Glyph of Healing Wave');

What steps will reproduce the problem?
1.Have warlock, take soulleech talent/s
2.Cast spells indicated on soulleech description
3.soulleach wont proc from some spells

What is the expected output? What do you see instead?
have to work from all indicated spells

What version of TDB? What version of the core (LATEST is NOT acceptable)?
8094 rev, DB 9.29_7925

Please provide any additional information below.
sql adds all required spells to SpellFamilyMasks.

What steps will reproduce the problem?
1. Get Bryntroll, heroic or non-heroic, on a DK
2. Get MikScrollingBattleText addon to see exactly what happens, don't say 
"can't confirm" without using this addon or any other addon like this (for 
example: Parrot).
3. Use this macro:

#showtooltip SKILL
/target YOU
/s .cool
/cast Empower Rune Weapon
/cast [@focus] SKILL

Change SKILL for the skill you want to test and YOU for your character's name.


What is the expected output? What do you see instead?
You should see Drain Life (bryntroll's proc) proccing off DK's skills like 
heart strike, blood strike, scourge strike, but it only procs off white hits, 
and warrior and paladin skills (tested Bladestorm and Divine Storm in a bunch 
of dummys to see faster results)

What version of TDB? What version of the core (LATEST is NOT acceptable)?
TDB Dreaming Murloc, Core: Rev. 8832 Windows XP SP2

Please provide any additional information below.
Wowhead links:
Non-heroic Bryntroll: http://www.wowhead.com/item=50415
Non-heroic Bryntroll proc (Drain Life): http://www.wowhead.com/spell=71838
Heroic Bryntroll: http://www.wowhead.com/item=50709
Heroic Bryntroll proc (Drain Life): http://www.wowhead.com/spell=71839

What steps will reproduce the problem?
1. When some players teleport to dalaran, wow take a fatal error

What steps will reproduce the problem?
1.Have warlock, take decimation talents
2.cast soulfire on target that is at or below 35% health
3.Decimation wont proc

What is the expected output? What do you see instead?
DEcimation has to proc and from soulfire spell

What version of TDB? What version of the core (LATEST is NOT acceptable)?
core 8094, DB 9.29_7925

Please provide any additional information below.

What steps will reproduce the problem?
1. finishing the quest and npc quest mark did not disappear after ending it
2. val,kyr battle maiden spawn position is incorrect they should fly above
ground not have body through ground
3. many useless npc in hall of command[ not blizzlike ]

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
6862x64 tdb0.0.7 windows7 64

Please provide any additional information below.

Missing ";" at end of line in 7279_world_gameobject_template.sql

What steps will reproduce the problem?
1.Use a Fish Feast
2.Check your bonus damage is increased but your bonus healing its not


What is the expected output? What do you see instead?
Since it gaves you spell power, both spell damage and bonus healing should
be increased by 46!

What revision of the Core are you using? On what operating system?
TC2 Rev 7926 on Windows Seven x64

Please provide any additional information below.
http://www.wowhead.com/item=43015/fish-feast

Hi there i use the latest trinity db and the latest trinity core.

but i cant find any herbs and veins on the server.

so what can i do??

What steps will reproduce the problem?
The spells Call of the Elements, Call of the Ancestors and Call of the
Spirits are missing from the trainers who are meant to teach them.

What version of the product are you using? On what operating system?
Rev 6928 with TDB 0.0.7 + repo updates

Please provide any additional information below.
I have provided the quick fix I used. Apply this to your world database and
reload the npc_trainer table.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


What version of TDB? What version of the core (LATEST is NOT acceptable)?


Please provide any additional information below.
In database are only added TBC and lower ranks warrior abilities threats.

sql file adds Heroic Strike (rank 13), Shield Slam (rank 8), Revenge (rank
9), Shield Bash, Cleave (rank 8) threats.

What steps will reproduce the problem?
1.go to a shaman trainer at lvl 70 and try to learn bloodlust

What is the expected output? What do you see instead?
bloodlust should be in the list and leanable

What version of TDB? What version of the core (LATEST is NOT acceptable)?
333.9.29_7925 + updates. core 8381

Please provide any additional information below.
i have a fix in my db attached below

What steps will reproduce the problem?
1.When a pally has his sacred shield up and and sacred cleansing proces it
will resist most of spells. I've made some screens for some proof (look at
combat log):
2.http://www.ipix.lt/desc/30195598/
3.http://www.ipix.lt/desc/14039425/

What is the expected output? What do you see instead?


What version of TDB? What version of the core (LATEST is NOT acceptable)?


Please provide any additional information below.

What steps will reproduce the problem?
1.installed trinitycore
2.installed trinitydatabase rev 26
3.no 3.3 items like wrathfull gear

What is the expected output? What do you see instead?
no 3.3 items

What version of TDB? What version of the core (LATEST is NOT acceptable)?
rev 26, rev 7332

Please provide any additional information below.
i installed it clean but no items. 

What steps will reproduce the problem?
1. Go to Tanks for Everything and Forge of Fate in Dalaran
2. Try to smelt something, near the forges in the wall

What is the expected output? What do you see instead?
Nothing happes, it says "forge required"

What version of TDB? What version of the core (LATEST is NOT acceptable)?
TDB 335.10.32
COre 8912

Please provide any additional information below.
Thats the dalaran forges

What steps will reproduce the problem?
The mechanical mobs, do not have a "2nd" loot. I mean salvage loot, which
engineer can loot, like miner or herbalist or skiner.

What version of TDB? What version of the core (LATEST is NOT acceptable)?
333.9.29

Please provide any additional information below.
Everything is about Jeeves bot ;)

I would take a doubt about the objects of the death knight of the city, soon 
after completing the quest http://www.wowhead.com/quest=12641 the death knight 
quest received http://www.wowhead.com/quest = 12 657, but I've been noticing 
that the death knight does not descend to the lower deck to complete the quest, 
I do not know if the the object is buggy! Thank you for your attention,

I use the TDB version 333.9.31 FULL DB and trinity core build 8761

What steps will reproduce the problem?
1.http://www.wowhead.com/?spell=47855 in warlock spellbook dont work good"
If the target is at or below 25% health, Drain Soul causes four times the
normal damage" this bonus 4x damage don't work when target is at or below
25% Health
2.
3.

What is the expected output? What do you see instead?


What version of TDB? What version of the core (LATEST is NOT acceptable)?


Please provide any additional information below.

What steps will reproduce the problem?

every cityguard havent a menue like show trainer for class.

maybe the gossip_menu_option isn't complete?

ive got the latest version of tdb

What steps will reproduce the problem?
Events begin on the wrong dates, mostly before. For example Lunar Festival 
has begun now whereas the calender says: 12/02/2010 start. Also some events 
are missing in the database such as day of the dead and Pilgrim

What is the expected output? What do you see instead?

All events start when they shouldn't including darkmoon faire

What revision of the Core are you using? On what operating system?

7223 on Win7

Please provide any additional information below.

Also Children's week quest is available when it shouldn't be meaning people 
can start and complete before or afetr may

What steps will reproduce the problem?
1. In this 2 instances in normal diff. players gets emblems. That shouldn't be 
that way.
2. In normal diff. instances can be reset easy and players can farm emblems.
3. This problem will broke the server economics.

version: TDB 335.10.32

This emblems should be drop only in heroic mode.

What steps will reproduce the problem?
1. Have high cooking skill (not sure about level)
2. Go to The Rokk (npc=24393) or Katherine Lee (npc=28705).

What is the expected output? What do you see instead?
Both of them offers some daily cooking quests. (The Rokk offers quest=11377, 
11379, 11380, 
11381. Katherine Lee offers quest=13100, 13101, 13102, 13103, 13107).
All of the quests are supposed to be available (as long as you not exceed the 
max dailies).
After getting one of the quests, the other ones become unavailable until the 
next day.

What version of TDB? What version of the core (LATEST is NOT acceptable)?
TDB_332.8.26_7332

TrinityCore Rev: 7537 Release Hash: 7a12de4c94b4 (Unix,little-endian) 
(core-daemon) on both 
Mac OS X and Linux.

This Quest can't be completed. If you emblazon your weapon it simply does 
nothing.

What steps will reproduce the problem?
Experience is quite low for quests while experience from kills are Blizz-like.

What version of the product are you using? On what operating system?
Rev 6928 with TDB 0.0.7 + repo updates

Please provide any additional information below.
Didn't have this issue with Rev 6552 with TBD 0.0.6 + repo updates.

What steps will reproduce the problem?
1. Put on 2 parts of the T7 Set ( Mage )
2. Cast a Mana gem ( as Mage )
3. Use it

What is the expected output?:
You gain 25% more mana when you use a mana gem.  In addition, using a mana gem 
grants you 225 spell power for 15 sec.

What do you see instead?
You gain 25% more mana when you use a mana gem. - no extra addmg


What version of TDB? What version of the core (LATEST is NOT acceptable)?
TrinityCore Rev: 9267 Release Hash: d52ef27366a0 (Unix,little-endian)

Please provide any additional information below.

I figured out that the T7 Mage bonus doesn't work 
I'm wearing these parts:
Gloves: http://www.wowhead.com/item=39495
Robe: http://www.wowhead.com/item=39492

as you can see the set bonus is:
(2) Set: You gain 25% more mana when you use a mana gem.  In addition, using a 
mana gem grants you 225 spell power for 15 sec.

and it doesn't work .. well only 50% of it works.

but! there's a BC Trinket with exactly the same effect, so this could be fixed 
without much work done! because the Trinket is working just fine.

you can find it here: http://www.wowhead.com/item=30720

good luck and happy fixing
Heartcookie from LandOfLegends

This issue has been fixed by db changes:
http://code.google.com/p/trinitycore/issues/detail?id=896

What steps will reproduce the problem?
1. Wintergrasp portal doesn't teleport player to wintergrasp fortress

http://paste2.org/p/651705