Skip to content

Instantly share code, notes, and snippets.

@rosem
Created March 5, 2018 23:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rosem/88243b71a45b6ab79e52b5a93181a7f2 to your computer and use it in GitHub Desktop.
Save rosem/88243b71a45b6ab79e52b5a93181a7f2 to your computer and use it in GitHub Desktop.
Log 2
Started POST "/rooms/geolocated.xml" for 174.230.18.33 at 2018-03-05 18:32:57 -0500
Processing by RoomsController#geolocated as XML
Parameters: {"ne"=>"38.162181,-121.881439", "res"=>"high", "sw"=>"37.057131,-122.825671"}
^[[1m^[[36mUser Load (0.6ms)^[[0m ^[[1mSELECT "users".* FROM "users" WHERE "users"."authentication_token" = 'SurFrddosuQcXV5ct7d4' AND ("users"."deleted_at" IS NULL) LIMIT 1^[[0m
User: 382b4b34
User-Agent: Mapchat* 2.0 rev:197 (iPhone; iOS 11.2; en_US)
^[[1m^[[35m (0.1ms)^[[0m BEGIN
^[[1m^[[36mUser Exists (0.2ms)^[[0m ^[[1mSELECT 1 AS one FROM "users" WHERE ("users"."uuid" = '6092AA9E-E11E-48F4-B189-FCF6D1F487FF' AND "users"."id" != 26) LIMIT 1^[[0m
^[[1m^[[35m (0.3ms)^[[0m UPDATE "users" SET "ne_lat" = 38.162181, "ne_lng" = -121.881439, "sw_lat" = 37.057131, "sw_lng" = -122.825671, "updated_at" = '2018-03-05 23:32:57.764121' WHERE "users"."id" = 26
[paperclip] Saving attachments.
^[[1m^[[36m (0.5ms)^[[0m ^[[1mCOMMIT^[[0m
^[[1m^[[35mRoom Load (0.6ms)^[[0m SELECT "rooms".* FROM "rooms" WHERE ("rooms"."deleted_at" IS NULL) AND (rooms.lat>37.057131 AND rooms.lat<38.162181 AND rooms.lng>-122.825671 AND rooms.lng<-121.881439) AND (private = 'f') AND (rooms.archived_at IS NULL AND (rooms.active_since IS NULL OR rooms.active_since <= '2018-03-05 23:32:57')) LIMIT 50
^[[1m^[[36mMessage Load (0.7ms)^[[0m ^[[1mSELECT id, content, created_at, user_id, room_id, photo_file_name, photo_updated_at, photo_meta FROM "messages" WHERE "messages"."room_id" IN (37, 38, 40, 41, 39, 33, 34, 35, 36) AND (messages.user_id not in (select users.id from users where blocked = true)) AND (messages.user_id not in (select blocked_id from blocked_users where blocked_users.user_id = 26 union select user_id from blocked_users where blocked_users.blocked_id = 26 union select users.id from users where blocked = true)) ORDER BY created_at ASC^[[0m
^[[1m^[[35mMessage Load (0.6ms)^[[0m SELECT id, created_at, user_id, room_id FROM "messages" WHERE "messages"."room_id" IN (37, 38, 40, 41, 39, 33, 34, 35, 36) AND (messages.user_id not in (select users.id from users where blocked = true)) AND (messages.user_id not in (select blocked_id from blocked_users where blocked_users.user_id = 26 union select user_id from blocked_users where blocked_users.blocked_id = 26 union select users.id from users where blocked = true)) ORDER BY created_at DESC
^[[1m^[[36mUser Load (0.3ms)^[[0m ^[[1mSELECT id, pseudo, avatar_file_name, avatar_updated_at FROM "users" WHERE "users"."id" IN (26) AND ("users"."deleted_at" IS NULL)^[[0m
Cache read: index_153/rooms/37-20180303021817//2018-03-03 02:18:17 UTC
Cache generate: index_153/rooms/37-20180303021817//2018-03-03 02:18:17 UTC
undefined method `distance' for #<Room:0x000000055cc560>
Rendered inline template (0.4ms)
Completed 500 Internal Server Error in 75ms (Views: 0.9ms | ActiveRecord: 3.9ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment