Defect #2701

Unable to create new role when custom table prefix is set

Added by Stefan Urbanek over 8 years ago. Updated over 8 years ago.

Status:ClosedStart date:2009-02-09
Priority:HighDue date:
Assignee:-% Done:

50%

Category:-
Target version:0.8.1
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.

tracker_role_custom_table_prefix.patch Magnifier - fix tracker.rb and role.rb to handle custom table prefix (1.69 KB) Stefan Urbanek, 2009-02-09 12:11

Associated revisions

Revision 2424
Added by Jean-Philippe Lang over 8 years ago

Removes hardcoded table names (#2701).

History

#1 Updated by Stefan Urbanek over 8 years ago

attached is a patch

note: similar patches are needed for other files as well.

#2 Updated by Jean-Philippe Lang over 8 years ago

  • Status changed from New to Resolved
  • Target version set to 0.8.1
  • Affected version (unused) set to devel
  • Resolution set to Fixed

Fixed in r2424. Please note that your patch is broken. Table name is workflows, but class name is Workflow, not Workflows.

#3 Updated by Jean-Philippe Lang over 8 years ago

  • Status changed from Resolved to Closed

Merged in 0.8 branch in r2425.

Also available in: Atom PDF