I am having a problem getting Redmine to run with Oracle (11.2) backend.
I get this error (below) because Oracle table names are limited to 30
characters. Does anyone around here know of a fix or workaround? I'm
wondering if I can simple change the table name, or if that will break
the application.
When doing a db migrate to an Oracle db this creates the error below.
I'm so close, but now when I do:
RAILS_ENV=production rake db:migrate --trace
I get:
AddOpenIdAuthenticationTables: migrating
================================
-- create_table(:open_id_authentication_associations, {:force=>true})
rake aborted!
An error has occurred, all later migrations canceled:
OCIError: ORA-00972: identifier is too long: CREATE TABLE
"OPEN_ID_AUTHENTICATION_ASSOCIATIONS" ("ID" NUMBER NOT NULL PRIMARY KEY,
"ISSUED" NUMBER, "LIFETIME" NUMBER, "HANDLE" VARCHAR2, "ASSOC_TYPE"
VARCHAR2, "SERVER_URL" BLOB, "SECRET" BLOB)
/opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in
`log'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1077:in
`log'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:493:in
`execute'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_schema_statements.rb:84:in
`create_table'
Any help is greatly appreciated!
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
