{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16214","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16214/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16214/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16214/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/16214","id":125694814,"number":16214,"title":"Archmage Leryda `NPC_Text` fix","user":{"login":"Saben65","id":1936487,"avatar_url":"https://avatars.githubusercontent.com/u/1936487?v=3","gravatar_id":"","url":"https://api.github.com/users/Saben65","html_url":"https://github.com/Saben65","followers_url":"https://api.github.com/users/Saben65/followers","following_url":"https://api.github.com/users/Saben65/following{/other_user}","gists_url":"https://api.github.com/users/Saben65/gists{/gist_id}","starred_url":"https://api.github.com/users/Saben65/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Saben65/subscriptions","organizations_url":"https://api.github.com/users/Saben65/orgs","repos_url":"https://api.github.com/users/Saben65/repos","events_url":"https://api.github.com/users/Saben65/events{/privacy}","received_events_url":"https://api.github.com/users/Saben65/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-01-08T21:15:34Z","updated_at":"2016-01-16T17:34:05Z","closed_at":null,"body":"Rev: 53f768b \r\nTDB: TDB 335.60\r\n\r\n[Archmage Leryda](http://www.wowhead.com/npc=18253/archmage-leryda) has two entries in `NPC_Text`, one of which is filled with default/empty data thus preventing players from starting the [quests](http://www.wowhead.com/quest=10730/path-of-the-violet-restorer) to get the Karazhan rings. Other than that, the quest-line appears to work fine.\r\n\r\nSuggested Fix\r\n```SQL\r\n-- Delete unpopulated table for NPC 18253, Archmage Leryda that prevents players from interacting.\r\nDELETE FROM `npc_text` WHERE `ID`=10884;\r\n```"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/172234248","html_url":"https://github.com/TrinityCore/TrinityCore/issues/16214#issuecomment-172234248","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16214","id":172234248,"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":"2016-01-16T17:34:05Z","updated_at":"2016-01-16T17:34:05Z","body":"SQLyog Community 12.1.8 (x64) is nice to use for more than one reason. I like the GUI too. ;-)\r\n(just keep an eye out for the right-hand edge of the last column, always 2 spaces too much)"}}