{"action":"created","issue":{"url":"https://api.github.com/repos/lingdb/Sound-Comparisons/issues/465","repository_url":"https://api.github.com/repos/lingdb/Sound-Comparisons","labels_url":"https://api.github.com/repos/lingdb/Sound-Comparisons/issues/465/labels{/name}","comments_url":"https://api.github.com/repos/lingdb/Sound-Comparisons/issues/465/comments","events_url":"https://api.github.com/repos/lingdb/Sound-Comparisons/issues/465/events","html_url":"https://github.com/lingdb/Sound-Comparisons/issues/465","id":225596649,"number":465,"title":"Mapudungun phonetic transcriptions not shown when viewing using Andean family.","user":{"login":"Linguista","id":5791472,"avatar_url":"https://avatars1.githubusercontent.com/u/5791472?v=3","gravatar_id":"","url":"https://api.github.com/users/Linguista","html_url":"https://github.com/Linguista","followers_url":"https://api.github.com/users/Linguista/followers","following_url":"https://api.github.com/users/Linguista/following{/other_user}","gists_url":"https://api.github.com/users/Linguista/gists{/gist_id}","starred_url":"https://api.github.com/users/Linguista/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Linguista/subscriptions","organizations_url":"https://api.github.com/users/Linguista/orgs","repos_url":"https://api.github.com/users/Linguista/repos","events_url":"https://api.github.com/users/Linguista/events{/privacy}","received_events_url":"https://api.github.com/users/Linguista/received_events","type":"User","site_admin":false},"labels":[{"id":133178476,"url":"https://api.github.com/repos/lingdb/Sound-Comparisons/labels/Programming:%20Bug","name":"Programming: Bug","color":"f7c6c7","default":false}],"state":"open","locked":false,"assignee":{"login":"Bibiko","id":16273,"avatar_url":"https://avatars0.githubusercontent.com/u/16273?v=3","gravatar_id":"","url":"https://api.github.com/users/Bibiko","html_url":"https://github.com/Bibiko","followers_url":"https://api.github.com/users/Bibiko/followers","following_url":"https://api.github.com/users/Bibiko/following{/other_user}","gists_url":"https://api.github.com/users/Bibiko/gists{/gist_id}","starred_url":"https://api.github.com/users/Bibiko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bibiko/subscriptions","organizations_url":"https://api.github.com/users/Bibiko/orgs","repos_url":"https://api.github.com/users/Bibiko/repos","events_url":"https://api.github.com/users/Bibiko/events{/privacy}","received_events_url":"https://api.github.com/users/Bibiko/received_events","type":"User","site_admin":false},"assignees":[{"login":"Bibiko","id":16273,"avatar_url":"https://avatars0.githubusercontent.com/u/16273?v=3","gravatar_id":"","url":"https://api.github.com/users/Bibiko","html_url":"https://github.com/Bibiko","followers_url":"https://api.github.com/users/Bibiko/followers","following_url":"https://api.github.com/users/Bibiko/following{/other_user}","gists_url":"https://api.github.com/users/Bibiko/gists{/gist_id}","starred_url":"https://api.github.com/users/Bibiko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bibiko/subscriptions","organizations_url":"https://api.github.com/users/Bibiko/orgs","repos_url":"https://api.github.com/users/Bibiko/repos","events_url":"https://api.github.com/users/Bibiko/events{/privacy}","received_events_url":"https://api.github.com/users/Bibiko/received_events","type":"User","site_admin":false},{"login":"PaulHeggarty","id":8819910,"avatar_url":"https://avatars3.githubusercontent.com/u/8819910?v=3","gravatar_id":"","url":"https://api.github.com/users/PaulHeggarty","html_url":"https://github.com/PaulHeggarty","followers_url":"https://api.github.com/users/PaulHeggarty/followers","following_url":"https://api.github.com/users/PaulHeggarty/following{/other_user}","gists_url":"https://api.github.com/users/PaulHeggarty/gists{/gist_id}","starred_url":"https://api.github.com/users/PaulHeggarty/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PaulHeggarty/subscriptions","organizations_url":"https://api.github.com/users/PaulHeggarty/orgs","repos_url":"https://api.github.com/users/PaulHeggarty/repos","events_url":"https://api.github.com/users/PaulHeggarty/events{/privacy}","received_events_url":"https://api.github.com/users/PaulHeggarty/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-05-02T05:50:58Z","updated_at":"2017-05-03T08:06:32Z","closed_at":null,"body":"When viewing Mapudungun varieties by means of the `Mapudungun` button in the top left corner, the phonetic transcriptions are shown properly, as can be seen here:\r\n\r\n![Mapudungun via Mapudungun](https://i.imgur.com/zl7Rqdl.png)\r\n\r\n\r\nHowever, if you view the same Mapudungun varieties using the `Andean` option, no transcriptions whatsoever are shown.\r\n\r\n![Mapudungun via Andean](https://i.imgur.com/li48XEP.png)\r\n\r\nNeedless to say, this isn't the expected behavior."},"comment":{"url":"https://api.github.com/repos/lingdb/Sound-Comparisons/issues/comments/298846968","html_url":"https://github.com/lingdb/Sound-Comparisons/issues/465#issuecomment-298846968","issue_url":"https://api.github.com/repos/lingdb/Sound-Comparisons/issues/465","id":298846968,"user":{"login":"Bibiko","id":16273,"avatar_url":"https://avatars0.githubusercontent.com/u/16273?v=3","gravatar_id":"","url":"https://api.github.com/users/Bibiko","html_url":"https://github.com/Bibiko","followers_url":"https://api.github.com/users/Bibiko/followers","following_url":"https://api.github.com/users/Bibiko/following{/other_user}","gists_url":"https://api.github.com/users/Bibiko/gists{/gist_id}","starred_url":"https://api.github.com/users/Bibiko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bibiko/subscriptions","organizations_url":"https://api.github.com/users/Bibiko/orgs","repos_url":"https://api.github.com/users/Bibiko/repos","events_url":"https://api.github.com/users/Bibiko/events{/privacy}","received_events_url":"https://api.github.com/users/Bibiko/received_events","type":"User","site_admin":false},"created_at":"2017-05-03T08:06:32Z","updated_at":"2017-05-03T08:06:32Z","body":"@PaulHeggarty This issue is related to the fact that the database tables are study-based. Which has advantages but only disadvantages. The missing Mapudungun transcriptions inside of the Andean study are only stored within the Mapudungun study, not within the Andean study. This leads also to another problem: please compare e.g. \r\n\r\nhttp://www.soundcomparisons.com/#/en/Mapudungun/language/Lago%20Rosario\r\n\r\nand\r\n\r\nhttp://www.soundcomparisons.com/#/en/Andean/language/Lago%20Rosario\r\n\r\nWhat should we do?\r\n1) We can merge all study-based tables into big tables. This would have the advantage that one can create studies with let's say Slavic and Malakula languages and all language data will be stored once. But this would be a deep code intrusion.\r\n2) I can try to query all tables for languages which are given for the desired study. This should be easy but won't solve the problem that language data will be stored more than once in the database (redundancy)."}}
{"actor":{"display_login":"Bibiko"}}