{"action":"created","issue":{"url":"https://api.github.com/repos/okfn/opendatacensus/issues/644","labels_url":"https://api.github.com/repos/okfn/opendatacensus/issues/644/labels{/name}","comments_url":"https://api.github.com/repos/okfn/opendatacensus/issues/644/comments","events_url":"https://api.github.com/repos/okfn/opendatacensus/issues/644/events","html_url":"https://github.com/okfn/opendatacensus/issues/644","id":101587810,"number":644,"title":"Corrupted question dependants values in the DB","user":{"login":"vlevit","id":1190643,"avatar_url":"https://avatars.githubusercontent.com/u/1190643?v=3","gravatar_id":"","url":"https://api.github.com/users/vlevit","html_url":"https://github.com/vlevit","followers_url":"https://api.github.com/users/vlevit/followers","following_url":"https://api.github.com/users/vlevit/following{/other_user}","gists_url":"https://api.github.com/users/vlevit/gists{/gist_id}","starred_url":"https://api.github.com/users/vlevit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vlevit/subscriptions","organizations_url":"https://api.github.com/users/vlevit/orgs","repos_url":"https://api.github.com/users/vlevit/repos","events_url":"https://api.github.com/users/vlevit/events{/privacy}","received_events_url":"https://api.github.com/users/vlevit/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-08-18T07:14:00Z","updated_at":"2015-08-19T13:00:10Z","closed_at":null,"body":"We have had the global index submission pages not working because of invalid dependant values in the DB. They looked as follows\r\n\r\n           id        |        dependants         \r\n    -----------------+---------------------------\r\n     openlicense     | {licenseurl,i,c,e,n,s,e,u,r,l}\r\n     machinereadable | {format,o,r,m,a,t}\r\n     online          | {url,r,l}\r\n\r\netc. @morchickit reimported the questions but it didn't help. So I fixed them manually.\r\n\r\nI'm still not familiar with DB loading mechanism. Though we'll probably need to test on staging to avoid data corruption on the production site.\r\n\r\nUntil the issue is fixed we should probably avoid importing questions to the database."},"comment":{"url":"https://api.github.com/repos/okfn/opendatacensus/issues/comments/132582898","html_url":"https://github.com/okfn/opendatacensus/issues/644#issuecomment-132582898","issue_url":"https://api.github.com/repos/okfn/opendatacensus/issues/644","id":132582898,"user":{"login":"longhotsummer","id":4178542,"avatar_url":"https://avatars.githubusercontent.com/u/4178542?v=3","gravatar_id":"","url":"https://api.github.com/users/longhotsummer","html_url":"https://github.com/longhotsummer","followers_url":"https://api.github.com/users/longhotsummer/followers","following_url":"https://api.github.com/users/longhotsummer/following{/other_user}","gists_url":"https://api.github.com/users/longhotsummer/gists{/gist_id}","starred_url":"https://api.github.com/users/longhotsummer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/longhotsummer/subscriptions","organizations_url":"https://api.github.com/users/longhotsummer/orgs","repos_url":"https://api.github.com/users/longhotsummer/repos","events_url":"https://api.github.com/users/longhotsummer/events{/privacy}","received_events_url":"https://api.github.com/users/longhotsummer/received_events","type":"User","site_admin":false},"created_at":"2015-08-19T13:00:10Z","updated_at":"2015-08-19T13:00:10Z","body":"Yes, dependants for questions is fixed, my bad."}}