{"action":"closed","issue":{"url":"https://api.github.com/repos/BiologicalRecordsCentre/iRecord/issues/458","repository_url":"https://api.github.com/repos/BiologicalRecordsCentre/iRecord","labels_url":"https://api.github.com/repos/BiologicalRecordsCentre/iRecord/issues/458/labels{/name}","comments_url":"https://api.github.com/repos/BiologicalRecordsCentre/iRecord/issues/458/comments","events_url":"https://api.github.com/repos/BiologicalRecordsCentre/iRecord/issues/458/events","html_url":"https://github.com/BiologicalRecordsCentre/iRecord/issues/458","id":391475229,"node_id":"MDU6SXNzdWUzOTE0NzUyMjk=","number":458,"title":"PoMS data entry selection form failing to load","user":{"login":"kitenetter","id":16039111,"node_id":"MDQ6VXNlcjE2MDM5MTEx","avatar_url":"https://avatars3.githubusercontent.com/u/16039111?v=4","gravatar_id":"","url":"https://api.github.com/users/kitenetter","html_url":"https://github.com/kitenetter","followers_url":"https://api.github.com/users/kitenetter/followers","following_url":"https://api.github.com/users/kitenetter/following{/other_user}","gists_url":"https://api.github.com/users/kitenetter/gists{/gist_id}","starred_url":"https://api.github.com/users/kitenetter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kitenetter/subscriptions","organizations_url":"https://api.github.com/users/kitenetter/orgs","repos_url":"https://api.github.com/users/kitenetter/repos","events_url":"https://api.github.com/users/kitenetter/events{/privacy}","received_events_url":"https://api.github.com/users/kitenetter/received_events","type":"User","site_admin":false},"labels":[{"id":348262407,"node_id":"MDU6TGFiZWwzNDgyNjI0MDc=","url":"https://api.github.com/repos/BiologicalRecordsCentre/iRecord/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-12-16T14:58:21Z","updated_at":"2018-12-21T11:16:30Z","closed_at":"2018-12-21T11:16:30Z","author_association":"COLLABORATOR","body":"From the PoMS activity \"1km square survey - pan-traps\" (group_id 1073) I need to use \"Species data: select pan-traps\" in order to enter PoMS specimen data. That button takes me to:\r\nhttps://www.brc.ac.uk/irecord/node/7165?group_id=1073&implicit=f\r\n\r\nOn that page, the map is displaying but not the data table, and an error message is given:\r\n```\r\nThe data did not load successfully. The reason given was: \r\nThere was an SQL error: ERROR:  column s.blocked_sharing_tasks does not exist\r\nLINE 16: ...ND (su.website_id in (23) OR s.created_by_id=1 OR s.blocked_...\r\n                                                              ^ - SELECT COUNT(*) FROM (\r\n  SELECT *\r\n  FROM samples s\r\n  JOIN surveys su on su.id=s.survey_id and su.deleted=false\r\n  JOIN websites w on w.id=su.website_id and w.deleted=false\r\n  LEFT JOIN (sample_attribute_values savrecorder\r\n      JOIN sample_attributes sarecorder on sarecorder.id=savrecorder.sample_attribute_id and sarecorder.deleted=false\r\n           and sarecorder.system_function='full_name'\r\n  ) on savrecorder.sample_id=s.id and savrecorder.deleted=false\r\n  LEFT JOIN locations l on l.id=s.location_id and l.deleted=false\r\n  JOIN system sys ON sys.id=1\r\n  LEFT JOIN sample_attribute_values sample1093 ON sample1093.sample_id=s.id AND sample1093.sample_attribute_id=1093 AND sample1093.deleted=false\r\nLEFT JOIN cache_termlists_terms ltt1093 ON ltt1093.id=sample1093.int_value\r\n \r\n  WHERE s.deleted=false\r\n  AND (su.website_id in (23) OR s.created_by_id=1 OR s.blocked_sharing_tasks IS NULL OR NOT s.blocked_sharing_tasks @> ARRAY['R'::character ])\r\n AND su.website_id in (101,108,43,13,97,33,29,44,87,98,12,24,14,17,6,8,25,11,7,30,5,27,34,40,32,42,51,49,65,68,73,75,9,71,88,10,23,69)\r\n AND ('2018-01-01'='Click here' OR s.date_end >= CAST(COALESCE('2018-01-01','1500-01-01') as date))\r\nAND s.record_status<>'R'\r\nAND s.group_id=1073\r\nAND s.record_status<>'R'\r\n LIMIT 42) AS subquery\r\n```\r\nApologies for marking another issue as urgent but we're on a very tight schedule to get the PoMS data entered.\r\n"}}
{"actor":{"display_login":"johnvanbreda"}}