Defect #2701: Unable to create new role when custom table prefix is set - Redmine

Actions

Copy link

Defect #2701

closed

Unable to create new role when custom table prefix is set

Added by Stefan Urbanek almost 16 years ago. Updated almost 16 years ago.

Status:

Closed

Priority:

High

Assignee:

Category:

Target version:

0.8.1

Start date:

2009-02-09

Due date:

% Done:

50%

Estimated time:

Resolution:

Fixed

Affected version:

Description

ActiveRecord::StatementInvalid (Mysql::Error: Table 'my_schema.workflows' doesn't exist: INSERT INTO workflows (tracker_id, old_status_id, new_status_id, role_id) SELECT tracker_id, old_status_id, new_status_id, 6 FROM workflows WHERE role_id = 4):
    /var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
    /var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:309:in `execute'
    /var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
    /var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:319:in `insert_sql'
    /var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
    /var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
    /app/models/role.rb:34:in `copy'
    /app/controllers/roles_controller.rb:40:in `new'

by grepping for INSERT in app/modules it looks like tracker would be affected as well. Grepping for FROM reveals some DELETE statements that do not use table prefix in other files as well.

Files

tracker_role_custom_table_prefix.patch (1.69 KB) tracker_role_custom_table_prefix.patch

fix tracker.rb and role.rb to handle custom table prefix

Stefan Urbanek, 2009-02-09 12:11