[OSM-Photos] length for :photos_status:Symbol not defined [was] Partial success
John McKerrell
john at mckerrell.net
Thu Nov 18 16:28:40 GMT 2010
Is the file on the disk in the correct place? It should be in public/available/12c682ac2c12ae5f574ed6142ce01cb900a4536d-square.jpg
If not it might be a permissions problem, this could be the same thing Amrit is seeing too. i.e. the system does not have permission to write to that directory?
On 18 Nov 2010, at 15:00, H.S.Rai wrote:
> On Mon, Nov 8, 2010 at 2:44 PM, John McKerrell <john at mckerrell.net> wrote:
>> Try editing 20091031110719_photo_filename_status_indexes.rb and replacing
>> :photos_status with "photos_status", and :photos_filename with
>> "photos_filename" in both places.
>
>
> Now I am getting errors like:
>
> ActionController::RoutingError (No route matches
> "/available/12c682ac2c12ae5f574ed6142ce01cb900a4536d-square.jpg" with
> {:method=>:get}):
>
> Rendering rescues/layout (not_found)
>
> [2010-11-18 19:43:05] ERROR WEBrick::HTTPStatus::LengthRequired
> [2010-11-18 19:43:05] ERROR HTTPRequest#fixup:
> WEBrick::HTTPStatus::LengthRequired occured.
> [2010-11-18 19:43:05] ERROR NoMethodError: private method `gsub!'
> called for #<Class:0xb6e68b68>
>
> Full log is below sigature.
>
> May I know what is the issue?
>
> --
> H.S.Rai
>
> tcc at tcc:~$ ssh hsrai at 202.164.53.116
> hsrai at gne:~$ cd OSV/OpenStreetView/
> hsrai at gne:~/OSV/OpenStreetView$ ./script/tools/processor.rb &
> hsrai at gne:~/OSV/OpenStreetView$ script/server &
> hsrai at gne:~/OSV/OpenStreetView$ => Booting WEBrick
> => Rails 2.3.8 application starting on http://0.0.0.0:3000
> Sleeping for a minute
> => Call with -d to detach
> => Ctrl-C to shutdown server
> [2010-11-18 19:39:21] INFO WEBrick 1.3.1
> [2010-11-18 19:39:21] INFO ruby 1.8.7 (2010-01-10) [i486-linux]
> [2010-11-18 19:39:26] INFO WEBrick::HTTPServer#start: pid=11112 port=3000
> Sleeping for a minute
> SQL (0.3ms) LOCK TABLES photos WRITE
> Photo Load (0.8ms) SELECT * FROM `photos` WHERE (`photos`.`status`
> = 'pending') LIMIT 1
> SQL (0.2ms) UNLOCK TABLES
> SQL (0.3ms) LOCK TABLES photos WRITE
> Photo Load (0.7ms) SELECT * FROM `photos` WHERE (`photos`.`status`
> = 'pending') LIMIT 1
> SQL (0.1ms) UNLOCK TABLES
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing MainController#index (for 202.164.53.112 at 2010-11-18
> 19:41:48) [GET]
> Photo Load (1.1ms) SELECT * FROM `photos` WHERE ((lat IS NULL OR
> lon IS NULL) AND status = 'available') ORDER BY created_at ASC LIMIT
> 0, 10
> Rendering template within layouts/application
> Rendering main/index
> Completed in 109ms (View: 71, DB: 1) | 200 OK [http://202.164.53.116/]
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
> request.format=application/json
> format=#<ActionController::MimeResponds::Responder:0xb6e8d238>
>
>
> Processing Api::PhotosController#locate to json (for 202.164.53.112 at
> 2010-11-18 19:42:00) [GET]
> Parameters: {"bbox"=>"-131.66015624475,-65.440001658206,131.66015624475,65.440001658206"}
> Photo Load (1.4ms) SELECT * FROM `photos` WHERE (lat IS NOT NULL
> AND lon IS NOT NULL AND lat >= -65.440001658206 AND lat <=
> 65.440001658206 AND lon >= -131.66015624475 AND lon <= 131.66015624475
> AND status = 'available') GROUP BY floor(lat/-0.32720000829103),
> floor(lon/-0.877734374965) ORDER BY created_at DESC LIMIT 100
> Photo Columns (2.5ms) SHOW FIELDS FROM `photos`
> Tag Load (1.0ms) SELECT * FROM `tags` WHERE (`tags`.`deleted_at`
> IS NULL AND `tags`.`photo_id` = 1)
> CompositeMetadata Load (1.0ms) SELECT * FROM `composite_metadatas`
> WHERE (`composite_metadatas`.photo_id = 1)
> Completed in 136ms (View: 67, DB: 6) | 200 OK
> [http://202.164.53.116/api/photos/locate.json?bbox=-131.66015624475,-65.440001658206,131.66015624475,65.440001658206]
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing ApplicationController#index (for 202.164.53.112 at
> 2010-11-18 19:42:00) [GET]
>
> ActionController::RoutingError (No route matches
> "/available/12c682ac2c12ae5f574ed6142ce01cb900a4536d-square.jpg" with
> {:method=>:get}):
> /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
> /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
> /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
> /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
> /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
> /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
>
> Rendering rescues/layout (not_found)
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing SessionsController#new (for 202.164.53.112 at 2010-11-18
> 19:42:11) [GET]
> Rendering template within layouts/application
> Rendering sessions/new
> Completed in 97ms (View: 92, DB: 0) | 200 OK [http://202.164.53.116/login]
> Sleeping for a minute
> SQL (0.3ms) LOCK TABLES photos WRITE
> Photo Load (0.8ms) SELECT * FROM `photos` WHERE (`photos`.`status`
> = 'pending') LIMIT 1
> SQL (0.2ms) UNLOCK TABLES
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing SessionsController#create (for 202.164.53.112 at 2010-11-18
> 19:42:35) [POST]
> Parameters: {"commit"=>"Log in",
> "authenticity_token"=>"1wtcb71Gs1y3fknh6xh0k6j4cXxPlSeZVC0bl4UCviI=",
> "login"=>"hsrai", "password"=>"123123"}
> User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.`login` =
> 'hsrai') AND (users.state = 'active') LIMIT 1
> User Columns (2.1ms) SHOW FIELDS FROM `users`
> SQL (0.2ms) BEGIN
> SQL (0.2ms) COMMIT
> Redirected to http://202.164.53.116:3000/
> Completed in 25ms (DB: 3) | 302 Found [http://202.164.53.116/session]
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing MainController#index (for 202.164.53.112 at 2010-11-18
> 19:42:36) [GET]
> Photo Load (0.3ms) SELECT * FROM `photos` WHERE ((lat IS NULL OR
> lon IS NULL) AND status = 'available') ORDER BY created_at ASC LIMIT
> 0, 10
> Rendering template within layouts/application
> Rendering main/index
> User Columns (3.0ms) SHOW FIELDS FROM `users`
> User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.`id` = 1) LIMIT 1
> Photo Columns (2.7ms) SHOW FIELDS FROM `photos`
> SQL (0.7ms) SELECT count(*) AS count_all FROM `photos` WHERE
> (`photos`.`status` = 'unavailable' AND `photos`.`user_id` = 1)
> SQL (0.7ms) SELECT count(*) AS count_all FROM `photos` WHERE
> (status = 'moderation')
> Moderator Columns (1.7ms) SHOW FIELDS FROM `moderators`
> SQL (1.1ms) SELECT count(DISTINCT `moderators`.id) AS count_all
> FROM `moderators` LEFT OUTER JOIN `photos` ON `photos`.id =
> `moderators`.photo_id WHERE (photos.status = 'moderation' AND
> moderators.status <> 'pending' AND moderators.user_id = 1)
> Completed in 91ms (View: 56, DB: 11) | 200 OK [http://202.164.53.116/]
> request.format=application/json
> format=#<ActionController::MimeResponds::Responder:0xb6f56ea8>
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing Api::PhotosController#locate to json (for 202.164.53.112 at
> 2010-11-18 19:42:37) [GET]
> Parameters: {"bbox"=>"-131.66015624475,-65.440001658206,131.66015624475,65.440001658206"}
> Photo Load (0.4ms) SELECT * FROM `photos` WHERE (lat IS NOT NULL
> AND lon IS NOT NULL AND lat >= -65.440001658206 AND lat <=
> 65.440001658206 AND lon >= -131.66015624475 AND lon <= 131.66015624475
> AND status = 'available') GROUP BY floor(lat/-0.32720000829103),
> floor(lon/-0.877734374965) ORDER BY created_at DESC LIMIT 100
> Photo Columns (2.5ms) SHOW FIELDS FROM `photos`
> Tag Load (0.2ms) SELECT * FROM `tags` WHERE (`tags`.`deleted_at`
> IS NULL AND `tags`.`photo_id` = 1)
> CompositeMetadata Load (0.2ms) SELECT * FROM `composite_metadatas`
> WHERE (`composite_metadatas`.photo_id = 1)
> Completed in 78ms (View: 44, DB: 3) | 200 OK
> [http://202.164.53.116/api/photos/locate.json?bbox=-131.66015624475,-65.440001658206,131.66015624475,65.440001658206]
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing ApplicationController#index (for 202.164.53.112 at
> 2010-11-18 19:42:37) [GET]
>
> ActionController::RoutingError (No route matches
> "/available/12c682ac2c12ae5f574ed6142ce01cb900a4536d-square.jpg" with
> {:method=>:get}):
> /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
> /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
> /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
> /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
> /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
> /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
>
> Rendering rescues/layout (not_found)
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing ModerateController#index (for 202.164.53.112 at 2010-11-18
> 19:43:01) [GET]
> User Columns (1.9ms) SHOW FIELDS FROM `users`
> User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.`id` = 1) LIMIT 1
> Rendering template within layouts/application
> Rendering moderate/index
> Photo Columns (2.6ms) SHOW FIELDS FROM `photos`
> SQL (0.2ms) SELECT count(*) AS count_all FROM `photos` WHERE
> (`photos`.`status` = 'unavailable' AND `photos`.`user_id` = 1)
> SQL (0.2ms) SELECT count(*) AS count_all FROM `photos` WHERE
> (status = 'moderation')
> Moderator Columns (1.6ms) SHOW FIELDS FROM `moderators`
> SQL (0.2ms) SELECT count(DISTINCT `moderators`.id) AS count_all
> FROM `moderators` LEFT OUTER JOIN `photos` ON `photos`.id =
> `moderators`.photo_id WHERE (photos.status = 'moderation' AND
> moderators.status <> 'pending' AND moderators.user_id = 1)
> Completed in 221ms (View: 202, DB: 7) | 200 OK [http://202.164.53.116/moderate]
> SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
>
>
> Processing Api::PhotosController#index (for 202.164.53.112 at
> 2010-11-18 19:43:05) [GET]
> Parameters: {"status"=>"moderation"}
> User Columns (2.1ms) SHOW FIELDS FROM `users`
> User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.`id` = 1) LIMIT 1
> Photo Columns (2.7ms) SHOW FIELDS FROM `photos`
> Moderator Columns (1.5ms) SHOW FIELDS FROM `moderators`
> Tag Columns (1.8ms) SHOW FIELDS FROM `tags`
>
> CompositeMetadata Columns (1.8ms) SHOW FIELDS FROM `composite_metadatas`
> Photo Load IDs For Limited Eager Loading (1.1ms) SELECT DISTINCT
> `photos`.id FROM `photos` LEFT OUTER JOIN `moderators` ON
> moderators.photo_id = photos.id WHERE (moderators.user_id = 1 AND
> moderators.status = 'pending' AND photos.status = 'moderation' ) ORDER
> BY moderators.created_at DESC LIMIT 0, 10
> Completed in 95ms (View: 1, DB: 11) | 200 OK
> [http://202.164.53.116/api/photos/?status=moderation]
> [2010-11-18 19:43:05] ERROR WEBrick::HTTPStatus::LengthRequired
> [2010-11-18 19:43:05] ERROR HTTPRequest#fixup:
> WEBrick::HTTPStatus::LengthRequired occured.
> [2010-11-18 19:43:05] ERROR NoMethodError: private method `gsub!'
> called for #<Class:0xb6e68b68>
> /usr/lib/ruby/1.8/webrick/htmlutils.rb:16:in `escape'
> /usr/lib/ruby/1.8/webrick/httpresponse.rb:232:in `set_error'
> /usr/lib/ruby/1.8/webrick/httpserver.rb:70:in `run'
> /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
> /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
> /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
> /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
> /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
> /var/lib/gems/1.8/gems/rack-1.1.0/lib/rack/handler/webrick.rb:14:in `run'
> /var/lib/gems/1.8/gems/rails-2.3.8/lib/commands/server.rb:111
> /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
> /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `require'
> script/server:3
>
> _______________________________________________
> Photos mailing list
> Photos at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/photos
More information about the Photos
mailing list