{"action":"created","issue":{"url":"https://api.github.com/repos/gltn/stdm/issues/206","repository_url":"https://api.github.com/repos/gltn/stdm","labels_url":"https://api.github.com/repos/gltn/stdm/issues/206/labels{/name}","comments_url":"https://api.github.com/repos/gltn/stdm/issues/206/comments","events_url":"https://api.github.com/repos/gltn/stdm/issues/206/events","html_url":"https://github.com/gltn/stdm/issues/206","id":193880905,"number":206,"title":"Failed to Create STR","user":{"login":"nkoech","id":8905226,"avatar_url":"https://avatars.githubusercontent.com/u/8905226?v=3","gravatar_id":"","url":"https://api.github.com/users/nkoech","html_url":"https://github.com/nkoech","followers_url":"https://api.github.com/users/nkoech/followers","following_url":"https://api.github.com/users/nkoech/following{/other_user}","gists_url":"https://api.github.com/users/nkoech/gists{/gist_id}","starred_url":"https://api.github.com/users/nkoech/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nkoech/subscriptions","organizations_url":"https://api.github.com/users/nkoech/orgs","repos_url":"https://api.github.com/users/nkoech/repos","events_url":"https://api.github.com/users/nkoech/events{/privacy}","received_events_url":"https://api.github.com/users/nkoech/received_events","type":"User","site_admin":false},"labels":[{"id":104106606,"url":"https://api.github.com/repos/gltn/stdm/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":{"login":"wondie","id":9709624,"avatar_url":"https://avatars.githubusercontent.com/u/9709624?v=3","gravatar_id":"","url":"https://api.github.com/users/wondie","html_url":"https://github.com/wondie","followers_url":"https://api.github.com/users/wondie/followers","following_url":"https://api.github.com/users/wondie/following{/other_user}","gists_url":"https://api.github.com/users/wondie/gists{/gist_id}","starred_url":"https://api.github.com/users/wondie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wondie/subscriptions","organizations_url":"https://api.github.com/users/wondie/orgs","repos_url":"https://api.github.com/users/wondie/repos","events_url":"https://api.github.com/users/wondie/events{/privacy}","received_events_url":"https://api.github.com/users/wondie/received_events","type":"User","site_admin":false},"assignees":[{"login":"wondie","id":9709624,"avatar_url":"https://avatars.githubusercontent.com/u/9709624?v=3","gravatar_id":"","url":"https://api.github.com/users/wondie","html_url":"https://github.com/wondie","followers_url":"https://api.github.com/users/wondie/followers","following_url":"https://api.github.com/users/wondie/following{/other_user}","gists_url":"https://api.github.com/users/wondie/gists{/gist_id}","starred_url":"https://api.github.com/users/wondie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wondie/subscriptions","organizations_url":"https://api.github.com/users/wondie/orgs","repos_url":"https://api.github.com/users/wondie/repos","events_url":"https://api.github.com/users/wondie/events{/privacy}","received_events_url":"https://api.github.com/users/wondie/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-12-06T20:53:11Z","updated_at":"2016-12-07T02:30:46Z","closed_at":null,"body":"The error shows up when you click the _**Next**_ button on **_STR_** wizard window in the _**Supporting Documents**_ section. \r\n\r\n![str_error_1](https://cloud.githubusercontent.com/assets/8905226/20942962/bd7dd14a-bc0e-11e6-919b-23c349dc2513.png)\r\n\r\nBelow is a log error from PostgreSQL concerning the same issue\r\n\r\n2016-12-06 23:10:36 EAT ERROR:  invalid input syntax for integer: \"NDIII167\" at character 314\r\n2016-12-06 23:10:36 EAT STATEMENT:  `SELECT mi_paddy.id AS mi_paddy_id, mi_paddy.paddy_code AS mi_paddy_paddy_code, mi_paddy.location_name AS mi_paddy_location_name, mi_paddy.area AS mi_paddy_area, mi_paddy.subdivisions AS mi_paddy_subdivisions, ST_AsBinary(mi_paddy.spatial_geometry) AS mi_paddy_spatial_geometry \r\n\tFROM mi_paddy \r\n\tWHERE mi_paddy.id = 'NDIII167' \r\n\t LIMIT 1`"},"comment":{"url":"https://api.github.com/repos/gltn/stdm/issues/comments/265337748","html_url":"https://github.com/gltn/stdm/issues/206#issuecomment-265337748","issue_url":"https://api.github.com/repos/gltn/stdm/issues/206","id":265337748,"user":{"login":"wondie","id":9709624,"avatar_url":"https://avatars.githubusercontent.com/u/9709624?v=3","gravatar_id":"","url":"https://api.github.com/users/wondie","html_url":"https://github.com/wondie","followers_url":"https://api.github.com/users/wondie/followers","following_url":"https://api.github.com/users/wondie/following{/other_user}","gists_url":"https://api.github.com/users/wondie/gists{/gist_id}","starred_url":"https://api.github.com/users/wondie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wondie/subscriptions","organizations_url":"https://api.github.com/users/wondie/orgs","repos_url":"https://api.github.com/users/wondie/repos","events_url":"https://api.github.com/users/wondie/events{/privacy}","received_events_url":"https://api.github.com/users/wondie/received_events","type":"User","site_admin":false},"created_at":"2016-12-07T02:30:46Z","updated_at":"2016-12-07T02:30:46Z","body":"@gkahiu yes it is a strange error and I am surprised how this error was never seen before! \r\nThe issue is most likely caused by an error of treating all relations parent tables as a lookup tables in [this function](https://github.com/gltn/stdm/blob/master/utils/util.py#L533).\r\n\r\n@nkoech I will wait for the configuration and db backup? In the mean time, try to reproduce the issue again after replacing the util.py file located in stdm/utils folder with the one attached here. \r\n[util.zip](https://github.com/gltn/stdm/files/635515/util.zip)\r\n\r\n@gkahiu I think we need to create a branch 1.4.3 so that we incorporate this and other issues and update the plugin repository.\r\n\r\n\r\n"}}
{"actor":{"display_login":"wondie"}}