Defect #10029

creating projects fail

Added by Charles Monteiro over 10 years ago. Updated over 1 year ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Resolution:No feedback Affected version:

Description

I get the following when attempting to create a new project or sub-project, apparently the code is passing a null to table field which is specified to be NOT NULL. We are on:
Redmine 1.2.1.stable.6446 (PostgreSQL)

all feedback appreciated.

stack:

ActiveRecord::StatementInvalid (RuntimeError: ERROR C23502 Mnull value in column "status" violates not-null constraint FexecMai
n.c L2250 RExecConstraints: INSERT INTO "projects" ("name", "created_on", "status", "updated_on", "lft", "description", "homepage"
, "is_public", "parent_id", "identifier", "rgt") VALUES('TB Services', '2012-01-12 10:35:43.566336', NULL, '2012-01-12 10:35:43.566336',
67, 'External enhancements in support of TB processes', '', 'f', NULL, 'tbservices', 68) RETURNING "id"):
app/controllers/projects_controller.rb:79:in `create'
passenger (3.0.8) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
passenger (3.0.8) lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request'
passenger (3.0.8) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
passenger (3.0.8) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler'
passenger (3.0.8) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send'
passenger (3.0.8) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application'
passenger (3.0.8) lib/phusion_passenger/utils.rb:479:in `safe_fork'
passenger (3.0.8) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:180:in `start'
passenger (3.0.8) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start'
passenger (3.0.8) lib/phusion_passenger/classic_rails/framework_spawner.rb:268:in `handle_spawn_application'
passenger (3.0.8) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
passenger (3.0.8) lib/phusion_passenger/classic_rails/framework_spawner.rb:263:in `handle_spawn_application'
passenger (3.0.8) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
passenger (3.0.8) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
passenger (3.0.8) lib/phusion_passenger/classic_rails/framework_spawner.rb:261:in `handle_spawn_application'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:180:in `start'
passenger (3.0.8) lib/phusion_passenger/classic_rails/framework_spawner.rb:93:in `start'
passenger (3.0.8) lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application'
passenger (3.0.8) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
passenger (3.0.8) lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application'
passenger (3.0.8) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
passenger (3.0.8) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
passenger (3.0.8) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application'
passenger (3.0.8) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application'
passenger (3.0.8) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
passenger (3.0.8) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
passenger (3.0.8) helper-scripts/passenger-spawn-server:99

Rendering /var/www/redmine-1.2/public/500.html (500 Internal Server Error)

History

#1 Updated by Etienne Massip over 10 years ago

Any plugin, which Redmine version, etc. (please give details according to SubmittingBugs)?

#2 Updated by Charles Monteiro over 10 years ago

Redmine version had already been specified, see above description.

Redmine 1.2.1.stable.6446 (PostgreSQL)

ruby version: ruby 1.8.6 (2010-02-05 patchlevel 399) [x86_64-linux]
rails version: Rails 2.3.11

Postgres : psql (PostgreSQL) 8.4.9

Plugins:

Redmine Question plugin
This is a plugin for Redmine that will allow users to ask questions to each other in issue notes
https://projects.littlestreamsoftware.com/projects/redmine-questions
Eric Davis 0.3.0
MyPage custom queries
Adds custom queries onto My Page screen
Milan Stastny of ALVILA SYSTEMS 0.0.1
Screenshot Paste
Allow pasting a screenshot from the clipboard on the issue form.
Jean-Philippe Lang 1.1.1

#3 Updated by Jean-Philippe Lang over 10 years ago

Can you check that the status column has a default value set to 1 in your projects table definition?

#4 Updated by Go MAEDA over 1 year ago

  • Status changed from New to Closed
  • Resolution set to No feedback

Also available in: Atom PDF