{"action":"created","issue":{"url":"https://api.github.com/repos/Program-O/Program-O/issues/451","repository_url":"https://api.github.com/repos/Program-O/Program-O","labels_url":"https://api.github.com/repos/Program-O/Program-O/issues/451/labels{/name}","comments_url":"https://api.github.com/repos/Program-O/Program-O/issues/451/comments","events_url":"https://api.github.com/repos/Program-O/Program-O/issues/451/events","html_url":"https://github.com/Program-O/Program-O/issues/451","id":356579521,"node_id":"MDU6SXNzdWUzNTY1Nzk1MjE=","number":451,"title":"Several times the same entries in \"SRAI Lookup\" after pressing the link \"Fill Lookup Table\".","user":{"login":"Josef-Meier","id":40842710,"node_id":"MDQ6VXNlcjQwODQyNzEw","avatar_url":"https://avatars1.githubusercontent.com/u/40842710?v=4","gravatar_id":"","url":"https://api.github.com/users/Josef-Meier","html_url":"https://github.com/Josef-Meier","followers_url":"https://api.github.com/users/Josef-Meier/followers","following_url":"https://api.github.com/users/Josef-Meier/following{/other_user}","gists_url":"https://api.github.com/users/Josef-Meier/gists{/gist_id}","starred_url":"https://api.github.com/users/Josef-Meier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Josef-Meier/subscriptions","organizations_url":"https://api.github.com/users/Josef-Meier/orgs","repos_url":"https://api.github.com/users/Josef-Meier/repos","events_url":"https://api.github.com/users/Josef-Meier/events{/privacy}","received_events_url":"https://api.github.com/users/Josef-Meier/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-09-03T18:33:37Z","updated_at":"2018-09-05T01:13:33Z","closed_at":null,"author_association":"NONE","body":"Version 2.6.10\r\nHello,\r\nHave no idea if this is only a blemish, or if it also has other effects, such as an impact on performance.\r\n![srai_lookup_2_6_10_duplicates](https://user-images.githubusercontent.com/40842710/44998647-8761a700-afb7-11e8-945a-72cdd12ebfc3.png)\r\n\r\nA section of the table \"srai_lookup\":\r\n![srai_lookup_451](https://user-images.githubusercontent.com/40842710/45048870-4c29ab80-b07d-11e8-870f-e21abe5d4b5d.png)\r\n\r\nWith a few SQL commands you can reduce the rows in table \"srai_lookup\" so that there are no duplicate entries.\r\nSo I was able to reduce the number of lines from 1634 to 179 in table \"srai_lookup\" of my Program-O environment.\r\nBest Regards\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Program-O/Program-O/issues/comments/418566905","html_url":"https://github.com/Program-O/Program-O/issues/451#issuecomment-418566905","issue_url":"https://api.github.com/repos/Program-O/Program-O/issues/451","id":418566905,"node_id":"MDEyOklzc3VlQ29tbWVudDQxODU2NjkwNQ==","user":{"login":"OverlanAI","id":36704725,"node_id":"MDQ6VXNlcjM2NzA0NzI1","avatar_url":"https://avatars1.githubusercontent.com/u/36704725?v=4","gravatar_id":"","url":"https://api.github.com/users/OverlanAI","html_url":"https://github.com/OverlanAI","followers_url":"https://api.github.com/users/OverlanAI/followers","following_url":"https://api.github.com/users/OverlanAI/following{/other_user}","gists_url":"https://api.github.com/users/OverlanAI/gists{/gist_id}","starred_url":"https://api.github.com/users/OverlanAI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/OverlanAI/subscriptions","organizations_url":"https://api.github.com/users/OverlanAI/orgs","repos_url":"https://api.github.com/users/OverlanAI/repos","events_url":"https://api.github.com/users/OverlanAI/events{/privacy}","received_events_url":"https://api.github.com/users/OverlanAI/received_events","type":"User","site_admin":false},"created_at":"2018-09-05T01:13:33Z","updated_at":"2018-09-05T01:13:33Z","author_association":"NONE","body":"Okay i did this for now in my php.ini\r\n`; Maximum input variable nesting level\r\n; http://php.net/max-input-nesting-level\r\nmax_input_nesting_level = 512\r\nxdebug.max_nesting_level=512`\r\n\r\nAccording to what i read doing that is not the best idea and is most likely masking an underlying problem with recursion.\r\n\r\nAnyway after doing that it build the SRAI table without triggering JIT.\r\nAfter that i pulled up php_my admin to have a look at the srai table and there were no dupes.\r\nI have not added your patch yet but i will keep an eye out any dupes.\r\nI have been fooled to many times by SRAI so one step at a time.\r\nThe main thing here maybe a diff in LAMP vrs WAMP setups where i am not getting the dupes like you did.\r\nWe will see what shows up since i still have a lot of concerns about the recursion.\r\nTNX"}}
{"actor":{"display_login":"OverlanAI"}}