On 11 March 2011 14:52, Bryan Crossland <[email protected]> wrote: > You are going to have to rework your code > > If you are the author of the code that uses that table then you have > some work ahead of you. If you are not, then you need to send it back > to your developers explaining that the table name is too long for Oracle > 11 and they will need to rework the code. Good luck.
It's not his code... he said, it's Redmine... > On Fri, Mar 11, 2011 at 7:31 AM, Matthew R. <[email protected]> wrote: > > I am having a problem getting Redmine to run with Oracle 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. > "OPEN_ID_AUTHENTICATION_ASSOCIATIONS" ("ID" NUMBER NOT NULL PRIMARY > Any help is greatly appreciated! You *may* be able to get away with changing the table name in the migration and then editing the model to specify the new table name: class Mouse < ActiveRecord::Base def self.table_name() "mice" end end However, according to the release notes, Oracle support should be in there: http://www.redmine.org/projects/redmine/wiki/Changelog_0_6 but the install notes don't mention it: http://www.redmine.org/projects/redmine/wiki/RedmineInstall ..but another "but" - it looks like your conflict is with one of the plugins that Remine uses: / vendor / plugins / open_id_authentication ...so there may not be much Redmine has to do with it, but it's an open_id_authentication I'm no Oracle admin, but can you use Aliases to help? http://www.oracle-base.com/articles/misc/NamingConventions.php#Aliasing Is there any reason why you can't use mySQL or SQLite?... might save a lot of hassle if you can... -- 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.
