Defect #4235
closedIssues not working
0%
Description
Throws error 500 when trying to open. It happens only with one project...
log:
Processing IssuesController#index (for 79.139.136.243 at 2009-11-17 10:59:11) [GET] Parameters: {"project_id"=>"rbforest", "action"=>"index", "controller"=>"issues"} Rendering template within layouts/base Rendering issues/index.rhtml ActionView::TemplateError (SystemStackError: stack level too deep: SELECT * FROM "enumerations" WHERE ("enumerations"."project_id" IS NULL) AND ( ("enumerations"."type" = 'IssuePriority' ) ) ORDER BY position) on line #63 of app/views/queries/_filters.rhtml: 60: <tr> 61: <td> 62: <table> 63: <% query.available_filters.sort{|a,b| a[1][:order]<=>b[1][:order]}.each do |filter| %> 64: <% field = filter[0] 65: options = filter[1] %> 66: <tr <%= 'style="display:none;"' unless query.has_filter?(field) %> id="tr_<%= field %>" class="filter"> app/models/query.rb:164:in `available_filters' app/views/queries/_filters.rhtml:63:in `_run_rhtml_app47views47queries47_filters46rhtml_locals_filters_object_query' app/views/issues/index.rhtml:17:in `_run_rhtml_app47views47issues47index46rhtml' app/views/issues/index.rhtml:11:in `_run_rhtml_app47views47issues47index46rhtml' app/controllers/issues_controller.rb:82:in `index' app/controllers/issues_controller.rb:71:in `index' /dh/passenger/lib/phusion_passenger/rack/request_handler.rb:95:in `process_request' /dh/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop' /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler' /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application' /dh/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork' /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application' /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__' /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop' /dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously' /dh/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start' /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start' /dh/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application' /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add' /dh/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application' /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize' /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' /dh/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application' /dh/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application' /dh/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application' /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__' /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop' /dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously' Rendering /home/xdevweb/code.x-demon.org/public/500.html (500 Internal Server Error)
Updated by Thomas Pihl over 15 years ago
It's really hard to say without more information.
Are you sure youäre up to date with rails (2.3.4) and all other gems required for devel edition? My first thought would be a mixup in versions.
If you're sure, please provide more information. Run the query manually and validate the result (to make sure database are in a good state).
Make sure not all enums are disabled in that project.
Not really sure what else to suggest.
/T
Updated by Lex Rivera over 15 years ago
I checked all and found that all gems up-to-date (using gem update i updated them anyway)
With sqlite3 checked DB. All sql requests which caused error 500 in redmine working perfectly in sqlite3. Also, "stack too deep" also happens when i try to open repo view, issues or projects settings.
Updated by Jean-Philippe Lang over 15 years ago
I'm not able to reproduce. Is there anything specific to mention about the project on which this error occurs?
Can you have a try with latest trunk (r3083)?
Updated by Lex Rivera over 15 years ago
happens even with latest rev. will try to reinstall it with old DB.
Updated by Lex Rivera over 15 years ago
now happens with settings too... for example, create project
Processing ProjectsController#add (for 79.139.136.243 at 2009-11-21 05:32:48) [POST]
Parameters: {"enabled_modules"=>["issue_tracking", "time_tracking", "news", "documents", "files", "wiki", "repository", "boards"], "commit"=>"Save", "action"=>"add", "authenticity_token"=>"et1xRT/bDMdO6v0HQULBrj+SX0H61giZY6ohrCAfXTc=", "project"=>{"name"=>"dfgdf", "homepage"=>"", "is_public"=>"1", "description"=>"dg", "identifier"=>"sdfd"}, "controller"=>"projects"}
ActiveRecord::StatementInvalid (SystemStackError: stack level too deep: SELECT * FROM "projects" WHERE ("projects"."id" = 1) ):
app/models/project.rb:209:in `find'
app/models/enabled_module.rb:33:in `module_enabled'
app/controllers/projects_controller.rb:77:in `add'
/dh/passenger/lib/phusion_passenger/rack/request_handler.rb:95:in `process_request'
/dh/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
/dh/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
/dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
/dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
/dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
Rendering /home/xdevweb/code.x-demon.org/public/500.html (500 Internal Server Error)
Updated by Jean-Philippe Lang over 15 years ago
Can you provide the information requested in SubmittingBugs please?
Updated by Lex Rivera over 15 years ago
[ps12894]$ RAILS_ENV="production" ruby script/about
About your application's environment
Ruby version 1.8.7 (x86_64-linux)
RubyGems version 1.3.5
Rack version 1.0
Rails version 2.3.4
Active Record version 2.3.4
Active Resource version 2.3.4
Action Mailer version 2.3.4
Active Support version 2.3.4
Application root /home/xdevweb/code.x-demon.org
Environment production
Database adapter sqlite3
Database schema version 20091114105931
Updated by Lex Rivera over 15 years ago
Nope, less than 10 mbytes sqlite, email can handle it.
Updated by Jean-Philippe Lang over 15 years ago
My email address can be found here: http://www.redmine.org/users/1
Updated by Lex Rivera over 15 years ago
Any updates? I still cannot use my redmine installation.
Updated by Jean-Philippe Lang over 15 years ago
- Status changed from New to Closed
- Resolution set to Cant reproduce
I've just tested the database you sent me.
Everything is fine with latest trunk (had to run db:migrate), ruby 1.8.7 and sqlite3-ruby (1.2.3) gem.