{"action":"created","issue":{"url":"https://api.github.com/repos/Safecast/safecastapi/issues/230","repository_url":"https://api.github.com/repos/Safecast/safecastapi","labels_url":"https://api.github.com/repos/Safecast/safecastapi/issues/230/labels{/name}","comments_url":"https://api.github.com/repos/Safecast/safecastapi/issues/230/comments","events_url":"https://api.github.com/repos/Safecast/safecastapi/issues/230/events","html_url":"https://github.com/Safecast/safecastapi/issues/230","id":131221941,"number":230,"title":"Staging 500 on measurements/new","user":{"login":"matschaffer","id":690,"avatar_url":"https://avatars.githubusercontent.com/u/690?v=3","gravatar_id":"","url":"https://api.github.com/users/matschaffer","html_url":"https://github.com/matschaffer","followers_url":"https://api.github.com/users/matschaffer/followers","following_url":"https://api.github.com/users/matschaffer/following{/other_user}","gists_url":"https://api.github.com/users/matschaffer/gists{/gist_id}","starred_url":"https://api.github.com/users/matschaffer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matschaffer/subscriptions","organizations_url":"https://api.github.com/users/matschaffer/orgs","repos_url":"https://api.github.com/users/matschaffer/repos","events_url":"https://api.github.com/users/matschaffer/events{/privacy}","received_events_url":"https://api.github.com/users/matschaffer/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Safecast/safecastapi/labels/Bug","name":"Bug","color":"e11d21"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-04T02:39:35Z","updated_at":"2016-04-26T12:32:24Z","closed_at":"2016-04-26T12:32:24Z","body":"```\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20] Started GET \"/en-US/measurements/new\" for 126.x.20 at 2016-02-04 02:38:27 +0000\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20] Processing by MeasurementsController#new as HTML\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20]   Parameters: {\"locale\"=>\"en-US\"}\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20]   User Load (1.4ms)  SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = 574 LIMIT 1\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20]   Measurement Load (1.2ms)  SELECT \"measurements\".* FROM \"measurements\" WHERE \"measurements\".\"user_id\" = 574 ORDER BY \"measurements\".\"\" DESC LIMIT 1\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20] PG::Error: ERROR:  zero-length delimited identifier at or near \"\"\"\"\nLINE 1: ...urements\".\"user_id\" = 574 ORDER BY \"measurements\".\"\" DESC LI...\n                                                             ^\n: SELECT  \"measurements\".* FROM \"measurements\"  WHERE \"measurements\".\"user_id\" = 574 ORDER BY \"measurements\".\"\" DESC LIMIT 1\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20] Completed 500 Internal Server Error in 6.8ms\n[30955ac1eab317b322efdc739aeeaa45] [126.x.20]\nActiveRecord::StatementInvalid (PG::Error: ERROR:  zero-length delimited identifier at or near \"\"\"\"\nLINE 1: ...urements\".\"user_id\" = 574 ORDER BY \"measurements\".\"\" DESC LI...\n                                                             ^\n: SELECT  \"measurements\".* FROM \"measurements\"  WHERE \"measurements\".\"user_id\" = 574 ORDER BY \"measurements\".\"\" DESC LIMIT 1):\n  app/controllers/measurements_controller.rb:53:in `new'\n```\n\nCould be we just need a data refresh."},"comment":{"url":"https://api.github.com/repos/Safecast/safecastapi/issues/comments/214724283","html_url":"https://github.com/Safecast/safecastapi/issues/230#issuecomment-214724283","issue_url":"https://api.github.com/repos/Safecast/safecastapi/issues/230","id":214724283,"user":{"login":"matschaffer","id":690,"avatar_url":"https://avatars.githubusercontent.com/u/690?v=3","gravatar_id":"","url":"https://api.github.com/users/matschaffer","html_url":"https://github.com/matschaffer","followers_url":"https://api.github.com/users/matschaffer/followers","following_url":"https://api.github.com/users/matschaffer/following{/other_user}","gists_url":"https://api.github.com/users/matschaffer/gists{/gist_id}","starred_url":"https://api.github.com/users/matschaffer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matschaffer/subscriptions","organizations_url":"https://api.github.com/users/matschaffer/orgs","repos_url":"https://api.github.com/users/matschaffer/repos","events_url":"https://api.github.com/users/matschaffer/events{/privacy}","received_events_url":"https://api.github.com/users/matschaffer/received_events","type":"User","site_admin":false},"created_at":"2016-04-26T12:32:24Z","updated_at":"2016-04-26T12:32:24Z","body":"Possibly related to #250 - closing this since it involves old logs and isn't immediately actionable."}}