Project

General

Profile

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
Actions
Copy link

Also available in: Atom PDF