{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15125","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15125/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15125/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15125/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15125","id":95944421,"number":15125,"title":"[6.x]DB errors: Fixing some errors related to SAI","user":{"login":"Killyana","id":6587064,"avatar_url":"https://avatars.githubusercontent.com/u/6587064?v=3","gravatar_id":"","url":"https://api.github.com/users/Killyana","html_url":"https://github.com/Killyana","followers_url":"https://api.github.com/users/Killyana/followers","following_url":"https://api.github.com/users/Killyana/following{/other_user}","gists_url":"https://api.github.com/users/Killyana/gists{/gist_id}","starred_url":"https://api.github.com/users/Killyana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Killyana/subscriptions","organizations_url":"https://api.github.com/users/Killyana/orgs","repos_url":"https://api.github.com/users/Killyana/repos","events_url":"https://api.github.com/users/Killyana/events{/privacy}","received_events_url":"https://api.github.com/users/Killyana/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Branch-6.x","name":"Branch-6.x","color":"188846"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Comp-Database","name":"Comp-Database","color":"FF6600"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Feedback-PatchFix","name":"Feedback-PatchFix","color":"d7e102"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Invalid-IncompleteData/NotTrinityCore","name":"Invalid-IncompleteData/NotTrinityCore","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-19T20:07:49Z","updated_at":"2015-07-19T20:07:52Z","closed_at":null,"body":"``` sql\r\nUPDATE `smart_scripts` SET `action_type`=11, `action_param1`=108013, `action_param2`=0, `action_param3`=0 WHERE `entryorguid` IN (-370665,-370584, -370561,-370552) AND `source_Type`=0 AND `id`=0;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `Entry` IN (51717, 51936, 12369, 40503);\r\nUPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=2287 AND `source_type`=0 AND `id`=3;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=2287 AND `source_type`=0 AND `id`=4;\r\nUPDATE `smart_scripts` SET `event_param3`=3000 WHERE `entryorguid`=5328 AND `source_type`=0 AND `id`=0;\r\nUPDATE `smart_scripts` SET `event_param2`=20 WHERE `entryorguid`=5328 AND `source_type`=0 AND `id`=1;\r\nUPDATE `smart_scripts` SET `action_type`=11, `action_param1`=32581, `action_param2`=0, `action_param3`=0  WHERE `entryorguid`=21352 AND `source_type`=0 AND `id`=0;\r\nUPDATE `smart_scripts` SET `action_type`=11, `action_param1`=36977, `action_param2`=0, `action_param3`=0, `action_param4`=0 WHERE `entryorguid`=21352 AND `source_type`=0 AND `id`=2;\r\nUPDATE `smart_scripts` SET `action_type`=11, `action_param1`=34631, `action_param2`=0, `action_param3`=0, `action_param4`=0 WHERE `entryorguid`=21498 AND `source_type`=0 AND `id`=0;\r\nUPDATE `smart_scripts` SET `action_type`=11, `action_param1`=36885, `action_param2`=0, `action_param3`=0, `action_param4`=0 WHERE `entryorguid`=21498 AND `source_type`=0 AND `id`=1;\r\nUPDATE `smart_scripts` SET `action_type`=85, `action_param1`=95006, `action_param2`=2 WHERE `entryorguid`=30698 AND `source_type`=0 AND `id`=7;\r\nUPDATE `smart_scripts` SET `event_param2`=20 WHERE `entryorguid`=40969 AND `source_type`=0 AND `id`=4;\r\nUPDATE `smart_scripts` SET `action_type`=85 WHERE `entryorguid`=47707 AND `source_type`=0 AND `id`=1;\r\nUPDATE `smart_scripts` SET `action_type`=85 WHERE `entryorguid`=46293 AND `source_type`=0 AND `id`=0;\r\nUPDATE `smart_scripts` SET `target_type`=19, `target_param1`=0, `target_param2`=30 WHERE `entryorguid`=73452 AND `source_type`=0 AND `id`=1;\r\nUPDATE `smart_scripts` SET `action_type`=85 WHERE `entryorguid`=230700 AND `source_type`=9 AND `id` IN (0,1,2);\r\nUPDATE `gameobject_template` SET `AIName`=\"SmartGameObjectAI\" WHERE `Entry` IN (164819, 177673, 190549);\r\nUPDATE `smart_scripts` SET `action_type`=85, `action_param1`=91874 WHERE `entryorguid`=3889500 AND `source_type`=9 AND `id` IN (1);\r\nUPDATE `smart_scripts` SET `action_type`=85, `action_param1`=91873 WHERE `entryorguid`=4923000 AND `source_type`=9 AND `id` IN (1);\r\nUPDATE `smart_scripts` SET `action_type`=85, `action_param1`=91876 WHERE `entryorguid`=4923100 AND `source_type`=9 AND `id` IN (1);\r\nUPDATE `smart_scripts` SET `action_type`=11, `action_param1`=91945 WHERE `entryorguid`=4934000 AND `source_type`=9 AND `id` IN (1);"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/122698667","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15125#issuecomment-122698667","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15125","id":122698667,"user":{"login":"TrinityCoreBot","id":8673985,"avatar_url":"https://avatars.githubusercontent.com/u/8673985?v=3","gravatar_id":"","url":"https://api.github.com/users/TrinityCoreBot","html_url":"https://github.com/TrinityCoreBot","followers_url":"https://api.github.com/users/TrinityCoreBot/followers","following_url":"https://api.github.com/users/TrinityCoreBot/following{/other_user}","gists_url":"https://api.github.com/users/TrinityCoreBot/gists{/gist_id}","starred_url":"https://api.github.com/users/TrinityCoreBot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TrinityCoreBot/subscriptions","organizations_url":"https://api.github.com/users/TrinityCoreBot/orgs","repos_url":"https://api.github.com/users/TrinityCoreBot/repos","events_url":"https://api.github.com/users/TrinityCoreBot/events{/privacy}","received_events_url":"https://api.github.com/users/TrinityCoreBot/received_events","type":"User","site_admin":false},"created_at":"2015-07-19T20:07:51Z","updated_at":"2015-07-19T20:07:51Z","body":"This issue is not considered valid because of the following reasons:\n- No proper commit hash (revision)\n\nPlease read http://bit.ly/tc-issuetracker-and-you . Thanks."}}