Unable to create new role when custom table prefix is set
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.
#2 Updated by Jean-Philippe Lang almost 9 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