ChiliProject is not maintained anymore. Please be advised that there will be no more updates.

We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.

Mysql insert query error

Added by Serghey Coreyba at 2012-11-06 05:21 pm

Hi to all I got error while creating issue to any project that i create. After a hour of googling don't find out answer. Maybe someone can help with that?
ChiliProject 3.3.0.080c5b63c (MySQL)
ruby 1.8.7 (2011-06-30 patchlevel 352) [x86_64-linux]
Ubuntu 12.04.1 LTS

Processing IssuesController#create (for 46.164.145.254 at 2012-11-06 13:40:37) [POST]
  Parameters: {"project_id"=>"testproj", "authenticity_token"=>"X4sGpj7dwrbWea3PvMQXZwwzQqSItArFmF47AfKUyDk=", "action"=>"create", "continue"=>"Create and continue", "issue"=>{"done_ratio"=>"0", "parent_issue_id"=>"", "subject"=>"test",
"watcher_user_ids"=>["6"], "estimated_hours"=>"", "description"=>"testtss", "start_date"=>"2012-11-06", "due_date"=>"", "status_id"=>"1", "priority_id"=>"4", "assigned_to_id"=>"1", "tracker_id"=>"1"}, "controller"=>"issues", "send_notification"=>"1", "attachments"=>{"1"=>{"description"=>""}}}

ActiveRecord::StatementInvalid (Mysql::Error: Column 'position' cannot be null: INSERT INTO `issues` (`subject`, `done_ratio`, `rgt`, `position`, `project_id`, `description`, `estimated_hours`, `lft`, `start_date`, `due_date`, `status_id`, `created_on`, `updated_on`, `parent_id`, `root_id`, `remaining_hours`, `priority_id`, `story_points`, `fixed_version_id`, `author_id`, `tracker_id`, `category_id`, `assigned_to_id`, `lock_version`) VALUES('test', 0, 2, NULL, 2, 'testtss', NULL, 1, '2012-11-06', NULL, 1, '2012-11-06 13:40:37', '2012-11-06 13:40:37', NULL, NULL, NULL, 4, NULL, NULL, 1, 1, NULL, 1, 0)):
  app/controllers/issues_controller.rb:122:in `create'
  /usr/lib/ruby/1.8/phusion_passenger/rack/request_handler.rb:92:in `process_request'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
  /usr/lib/ruby/1.8/phusion_passenger/railz/application_spawner.rb:418:in `start_request_handler'
  /usr/lib/ruby/1.8/phusion_passenger/railz/application_spawner.rb:358:in `handle_spawn_application'
  /usr/lib/ruby/1.8/phusion_passenger/utils.rb:184:in `safe_fork'
  /usr/lib/ruby/1.8/phusion_passenger/railz/application_spawner.rb:354:in `handle_spawn_application'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server.rb:352:in `__send__'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server.rb:352:in `main_loop'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server.rb:163:in `start'
  /usr/lib/ruby/1.8/phusion_passenger/railz/application_spawner.rb:213:in `start'
  /usr/lib/ruby/1.8/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
  /usr/lib/ruby/1.8/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  /usr/lib/ruby/1.8/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
  /usr/lib/ruby/1.8/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
  /usr/lib/ruby/1.8/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server.rb:352:in `__send__'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server.rb:352:in `main_loop'
  /usr/lib/ruby/1.8/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  /usr/lib/phusion_passenger/passenger-spawn-server:61

Rendering /var/www/chiliproject/public/500.html (500 Internal Server Error)
Starting SCM Creator Plugin for Redmine


Replies (1)

RE: Mysql insert query error - Added by Felix Schäfer at 2012-11-13 09:38 pm

Hi Serghey,

It seems you had a plugin installed that added the position column, as I don't think that the position column is part of the ChiliProject core. Did you have some plugins previously installed that you have removed?

(1-1/1)