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)