[OSM-Photos] length for :photos_status:Symbol not defined [was] Partial success
H.S.Rai
hardeep.rai at gmail.com
Thu Nov 18 15:00:02 GMT 2010
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
More information about the Photos
mailing list