Time entrie 505error
Added by Thijs Simonis almost 13 years ago
Hello,
When i add a new time entrie i get an 505error.
Running Redmine 1.3.0(mysql) from ppa:ondrej/redmine with Apache2 Passenger on Ubuntu10.04
In the logfile i see database redmine, but it is redmine_default.
About your application's environment
Ruby version 1.8.7 (i486-linux) RubyGems version 1.7.2 Rack version 1.3 Rails version 2.3.14 Active Record version 2.3.14 Active Resource version 2.3.14 Action Mailer version 2.3.14 Active Support version 2.3.14 Edge Rails revision unknown Application root /usr/share/redmine Environment production Database adapter mysql Database schema version 20111010202847 About your Redmine plugins Redmine Theme Changer plugin 0.0.5 Redmine Issue Checklist plugin 1.0.1 Redmine Close Button plugin 0.0.7 Redmine Wiki Extensions plugin 0.3.8 Mylyn Connector plugin 2.7.6.stable Redmine Question plugin 0.3.0 Redmine Hudson plugin 1.0.7
production.log
ActiveRecord::StatementInvalid (Mysql::Error: Table 'redmine.custom_values' doesn't exist: INSERT INTO `time_entries` (`tyear`, `start_time`, `project_id`, `tweek`, `issue_id`, `created_on`, `updated_on`, `comments`, `activity_id`, `billed_hours`, `user_id`, `spent_on`, `hours`, `tmonth`) VALUES(2012, NULL, 51, 8, 3101, '2012-02-21 19:52:23', '2012-02-21 19:52:23', '', 9, NULL, 77, '2012-02-21', 1.0, 2)): /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract_adapter.rb:227:in `log' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/mysql_adapter.rb:324:in `execute' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/database_statements.rb:259:in `insert_sql' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/mysql_adapter.rb:334:in `insert_sql' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/query_cache.rb:19:in `insert' /usr/lib/ruby/vendor_ruby/active_record/base.rb:2961:in `create_without_timestamps' /usr/lib/ruby/vendor_ruby/active_record/timestamp.rb:53:in `create_without_callbacks' /usr/lib/ruby/vendor_ruby/active_record/callbacks.rb:266:in `create' /usr/lib/ruby/vendor_ruby/active_record/base.rb:2927:in `create_or_update_without_callbacks' /usr/lib/ruby/vendor_ruby/active_record/callbacks.rb:250:in `create_or_update' /usr/lib/ruby/vendor_ruby/active_record/base.rb:2577:in `save_without_validation' /usr/lib/ruby/vendor_ruby/active_record/validations.rb:1089:in `save_without_dirty' /usr/lib/ruby/vendor_ruby/active_record/dirty.rb:79:in `save_without_transactions' /usr/lib/ruby/vendor_ruby/active_record/transactions.rb:229:in `send' /usr/lib/ruby/vendor_ruby/active_record/transactions.rb:229:in `with_transaction_returning_status' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction' /usr/lib/ruby/vendor_ruby/active_record/transactions.rb:182:in `transaction' /usr/lib/ruby/vendor_ruby/active_record/transactions.rb:228:in `with_transaction_returning_status' /usr/lib/ruby/vendor_ruby/active_record/transactions.rb:196:in `save' /usr/lib/ruby/vendor_ruby/active_record/transactions.rb:208:in `rollback_active_record_state!' /usr/lib/ruby/vendor_ruby/active_record/transactions.rb:196:in `save' app/controllers/timelog_controller.rb:121:in `create' /usr/lib/ruby/vendor_ruby/action_controller/base.rb:1333:in `send' /usr/lib/ruby/vendor_ruby/action_controller/base.rb:1333:in `perform_action_without_filters' /usr/lib/ruby/vendor_ruby/action_controller/filters.rb:617:in `call_filters' /usr/lib/ruby/vendor_ruby/action_controller/filters.rb:610:in `perform_action_without_benchmark' /usr/lib/ruby/vendor_ruby/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /usr/lib/ruby/vendor_ruby/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /usr/lib/ruby/vendor_ruby/action_controller/rescue.rb:160:in `perform_action_without_flash' /usr/lib/ruby/vendor_ruby/action_controller/flash.rb:151:in `perform_action' /usr/lib/ruby/vendor_ruby/action_controller/base.rb:532:in `send' /usr/lib/ruby/vendor_ruby/action_controller/base.rb:532:in `process_without_filters' /usr/lib/ruby/vendor_ruby/action_controller/filters.rb:606:in `process' /usr/lib/ruby/vendor_ruby/action_controller/base.rb:391:in `process' /usr/lib/ruby/vendor_ruby/action_controller/base.rb:386:in `call' /usr/lib/ruby/vendor_ruby/action_controller/routing/route_set.rb:438:in `call' /usr/lib/ruby/vendor_ruby/action_controller/dispatcher.rb:87:in `dispatch' /usr/lib/ruby/vendor_ruby/action_controller/dispatcher.rb:121:in `_call' /usr/lib/ruby/vendor_ruby/action_controller/dispatcher.rb:130:in `build_middleware_stack' /usr/lib/ruby/vendor_ruby/active_record/query_cache.rb:29:in `call' /usr/lib/ruby/vendor_ruby/active_record/query_cache.rb:29:in `call' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache' /usr/lib/ruby/vendor_ruby/active_record/query_cache.rb:9:in `cache' /usr/lib/ruby/vendor_ruby/active_record/query_cache.rb:28:in `call' /usr/lib/ruby/vendor_ruby/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call' /usr/lib/ruby/vendor_ruby/action_controller/string_coercion.rb:25:in `call' /usr/lib/ruby/vendor_ruby/rack/head.rb:9:in `call' /usr/lib/ruby/vendor_ruby/rack/methodoverride.rb:24:in `call' /usr/lib/ruby/vendor_ruby/action_controller/params_parser.rb:15:in `call' /usr/lib/ruby/vendor_ruby/action_controller/session/cookie_store.rb:99:in `call' /usr/lib/ruby/vendor_ruby/action_controller/failsafe.rb:26:in `call' /usr/lib/ruby/vendor_ruby/rack/lock.rb:15:in `call' /usr/lib/ruby/vendor_ruby/action_controller/dispatcher.rb:106:in `call' /usr/lib/ruby/1.8/phusion_passenger/rack/request_handler.rb:95: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:374:in `start_request_handler' /usr/lib/ruby/1.8/phusion_passenger/railz/application_spawner.rb:332: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:330: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:209: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 /usr/share/redmine/public/500.html (500 Internal Server Error)
database.yml
production: adapter: mysql database: redmine_default host: localhost port: username: redmine password: ******** encoding: utf8
Replies (1)
RE: Time entrie 505error - Added by Thijs Simonis over 12 years ago
Can be closed!
I have found a old TRIGGER that causes the problem.