Project

General

Profile

Actions

Defect #2701

closed

Unable to create new role when custom table prefix is set

Added by Stefan Urbanek about 15 years ago. Updated about 15 years ago.

Status:
Closed
Priority:
High
Assignee:
-
Category:
-
Target version:
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 #1

Updated by Stefan Urbanek about 15 years ago

attached is a patch

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

Actions #2

Updated by Jean-Philippe Lang about 15 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.

Actions #3

Updated by Jean-Philippe Lang about 15 years ago

  • Status changed from Resolved to Closed

Merged in 0.8 branch in r2425.

Actions

Also available in: Atom PDF