{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15774","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15774/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15774/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15774/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15774","id":114051288,"number":15774,"title":"DB/Error","user":{"login":"Tauriella","id":10637389,"avatar_url":"https://avatars.githubusercontent.com/u/10637389?v=3","gravatar_id":"","url":"https://api.github.com/users/Tauriella","html_url":"https://github.com/Tauriella","followers_url":"https://api.github.com/users/Tauriella/followers","following_url":"https://api.github.com/users/Tauriella/following{/other_user}","gists_url":"https://api.github.com/users/Tauriella/gists{/gist_id}","starred_url":"https://api.github.com/users/Tauriella/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Tauriella/subscriptions","organizations_url":"https://api.github.com/users/Tauriella/orgs","repos_url":"https://api.github.com/users/Tauriella/repos","events_url":"https://api.github.com/users/Tauriella/events{/privacy}","received_events_url":"https://api.github.com/users/Tauriella/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-29T13:39:14Z","updated_at":"2015-10-29T20:03:19Z","closed_at":null,"body":"TrinityCore rev. 20b4e6f03adc 2015-10-28 21:56:40 +0100 (HEAD branch)\r\n\r\nConsole Error\r\n\r\nCreature (Entry: 29999) has wrong value (0) in `InhabitType`, creature will not correctly walk/swim/fly.\r\nScript named 'boss_anubshiah' does not have a script name assigned in database.\r\nScript named 'boss_gorosh_the_dervish' does not have a script name assigned in database.\r\nScript named 'boss_grizzle' does not have a script name assigned in database.\r\n\r\nThis Error Comes after install \"2015_10_27_00_world335.sql\"\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (14338) is not using SmartAI, skipped loading.\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (14338) is not using SmartAI, skipped loading.\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (14338) is not using SmartAI, skipped loading.\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (14338) is not using SmartAI, skipped loading.\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (14338) is not using SmartAI, skipped loading.\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (14338) is not using SmartAI, skipped loading.\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (14338) is not using SmartAI, skipped loading.\r\nSmartAIMgr::LoadSmartAIFromDB: Creature entry (29999) is not using SmartAI, skipped loading."},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/152302970","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15774#issuecomment-152302970","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15774","id":152302970,"user":{"login":"tkrokli","id":4903600,"avatar_url":"https://avatars.githubusercontent.com/u/4903600?v=3","gravatar_id":"","url":"https://api.github.com/users/tkrokli","html_url":"https://github.com/tkrokli","followers_url":"https://api.github.com/users/tkrokli/followers","following_url":"https://api.github.com/users/tkrokli/following{/other_user}","gists_url":"https://api.github.com/users/tkrokli/gists{/gist_id}","starred_url":"https://api.github.com/users/tkrokli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tkrokli/subscriptions","organizations_url":"https://api.github.com/users/tkrokli/orgs","repos_url":"https://api.github.com/users/tkrokli/repos","events_url":"https://api.github.com/users/tkrokli/events{/privacy}","received_events_url":"https://api.github.com/users/tkrokli/received_events","type":"User","site_admin":false},"created_at":"2015-10-29T20:03:18Z","updated_at":"2015-10-29T20:03:18Z","body":"Creature ID/entry 29999 = 'Cave Explosion Bunny' is a Spell Bunny used near Frostgut's Altar in Storm Peaks for the quest \"A Flawless Plan\" (http://www.wowhead.com/quest=12823/a-flawless-plan). I am not sure what kind of `InhabitType` it should have, but in `creature_template` the value is 4 (Flying) in my TDB 335.59 + updates up to and including 2015_10_28_00_world.sql . This entry is not present in my DBErrors.log, maybe you should check if your DB is up to date? This entry was updated in commit https://github.com/TrinityCore/TrinityCore/commit/2aaab04 (3.3.5) on 2015-07-25, so it is odd that you still get this particular entry in your log.\r\nRead issue https://github.com/TrinityCore/TrinityCore/issues/12190 for details. You can also check your DB by running this query:\r\n```sql\r\nSELECT `entry`,`name`,`AIName`,`InhabitType`,`ScriptName`,`VerifiedBuild` FROM `creature_template` WHERE `entry`= 29999;\r\n```\r\nYou should get this output:\r\n```\r\n entry  name                  AIName   InhabitType  ScriptName  VerifiedBuild\r\n------  --------------------  -------  -----------  ----------  -------------\r\n 29999  Cave Explosion Bunny  SmartAI            4                      12340\r\n```\r\nThe rest of your list is present in my DBErrors.log and is correct regarding those entries, they don't have any C++ script names assigned in DB, but the C++ scripts still exist in the source:\r\nhttps://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/scripts/EasternKingdoms/BlackrockMountain/BlackrockDepths/\r\n- boss_anubshiah.cpp\r\n- boss_gorosh_the_dervish.cpp\r\n- boss_grizzle.cpp\r\n\r\nCreature entry 14338 Knot Thimblejack (http://www.wowhead.com/npc=14338/knot-thimblejack)\r\ncan be found in Dire Maul. (3.3.5 quest info in http://wotlk.openwow.com/npc=14338)\r\nLooking up \"Knot Timblejack\" in the TC repository gives this result:\r\nhttps://github.com/TrinityCore/TrinityCore/search?q=Knot+Thimblejack&type=Issues&utf8=✓\r\n=> https://github.com/TrinityCore/TrinityCore/commit/b96f2e1 [**DB/Misc: Knot Thimblejack**](https://github.com/TrinityCore/TrinityCore/commit/b96f2e1) [/sql/updates/world/2015_10_27_00_world335.sql](https://github.com/TrinityCore/TrinityCore/blob/b96f2e11ca76319888f641d2b38dcefce710221f/sql/updates/world/2015_10_27_00_world335.sql)\r\n\r\nRunning this query on TDB 335.59 (+ updates) on `world`.`creature_template`\r\n```sql\r\nSELECT `entry`,`name`,`gossip_menu_id`,`AIName`,`InhabitType`,`ScriptName`,`VerifiedBuild` FROM `creature_template` WHERE `entry` = 14338;\r\n```\r\ngives this result:\r\n```\r\n entry  name              gossip_menu_id  AIName  InhabitType  ScriptName  VerifiedBuild\r\n------  ----------------  --------------  ------  -----------  ----------  -------------\r\n 14338  Knot Thimblejack            5667                    3                      12340\r\n```\r\nYou can see that creature 14338 is not marked as using SmartAI in the DB table `creature_template`, but when looking in the table `smart_scripts` I find this:\r\n```sql\r\nSELECT * FROM `smart_scripts` WHERE `entryorguid` = 14338;\r\n```\r\n```\r\nentryorguid  source_type      id    link  event_type  event_phase_mask  event_chance  event_flags  event_param1  event_param2  event_param3  event_param4  action_type  action_param1  action_param2  action_param3  action_param4  action_param5  action_param6  target_type  target_param1  target_param2  target_param3  target_x  target_y  target_z  target_o  comment\r\n-----------  -----------  ------  ------  ----------  ----------------  ------------  -----------  ------------  ------------  ------------  ------------  -----------  -------------  -------------  -------------  -------------  -------------  -------------  -----------  -------------  -------------  -------------  --------  --------  --------  --------  --------------------------------------------------\r\n      14338            0       0       0          20                 0           100            1          5525             0             0             0           80        1433800              0              0              0              0              0            1              0              0              0         0         0         0         0  Knot - On Free Knot! Reward - run script\r\n      14338            0       1       0          20                 0           100            1          7429             0             0             0           80        1433800              0              0              0              0              0            1              0              0              0         0         0         0         0  Knot - On Free Knot! Reward - run script\r\n      14338            0       2       0          34                 0           100            0             0             1             0             0           41              0              0              0              0              0              0            1              0              0              0         0         0         0         0  Knot - On Point Reached - Despawn\r\n      14338            0       3       0          25                 0           100            0             0             0             0             0           50         179511          43200              0              0              0              0            8              0              0              0   581.241   524.321  -25.4027  -2.79252  Knot - On Reset - Spawn Ball and Chain\r\n      14338            0       4       6          62                 0           100            0          5667             0             0             0           85          22816              2              0              0              0              0            7              0              0              0         0         0         0         0  Knot - On Gossip Select  - Cast Gordok Ogre Suit\r\n      14338            0       5       6          62                 0           100            0          5667             1             0             0           85          22814              2              0              0              0              0            7              0              0              0         0         0         0         0  Knot - On Gossip Select  - Cast Gordok Ogre Suit\r\n      14338            0       6       0          61                 0           100            0          5667             0             0             0           72              0              0              0              0              0              0            7              0              0              0         0         0         0         0  Knot - On Gossip Select  - Close Gossip\r\n```\r\nLooking at [/sql/updates/world/2015_10_27_00_world335.sql](https://github.com/TrinityCore/TrinityCore/blob/b96f2e11ca76319888f641d2b38dcefce710221f/sql/updates/world/2015_10_27_00_world335.sql) again, I notice that @dr-j has forgotten to add this line in his SQL:\r\n```sql\r\nUPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 14338;\r\n```\r\nThis should fix your list of SmartAIMgr errors (7)."}}