Project

General

Profile

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.

    (1-1/1)