[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