Hi Pedro, The table names are created from two locations. First is the type definition, such as that found in /farcry/*/packages/types or /farcry/*/packages/rules. The one that is giving you problems is "/farcry/*/packages/rules/ruleShowWebfeed.cfc" where * is either /core/, plugins/pluginName, or /project/.
The base table "ruleShowWebfeed" is created from the name of the type created. (First line or so of the *.cfc file). The secondary table, holding the array, is created from the property name of the array. So in this case, the name is aWebDisplayFeeds. Farcry's database layer then puts those together into ruleShowWebfeed_aWebDisplayFeeds to create the table name. But that layer isn't so important. The important thing is to keep the total "name of type" + "name of array property" below 30 characters. If you search for aWebDisplayFeeds and replace all such occurances (in that file and webskin files related to it) with something shorter, that should do it. Hope that helps direct your search. Tomek On Fri, Mar 6, 2009 at 2:08 PM, pedrobl <[email protected]> wrote: > > > Thanks Tomek, > > On Mar 6, 2:37 pm, Tomek Kott <[email protected]> wrote: > > Hmm, I thought Oracle 10 got rid of those constraints. Did the error also > > spit out the query used for the command that failed? > > Oracle's version: > Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit > > :P > > > I have an install working on Oracle 8, so I know its possible, one just > has > > to be careful with the names. Part of the problem is that any type (such > as > > dmHTML) that has an array of associated types has an extra table. So if > > dmHTML has associated types aObjects, then there is a table created that > is > > dmHTML_aObjects. So you have to be careful to not let that combined > length > > be over 30 chars. > > > > That doesn't answer your question directly, but I know its possible to > > install on oracle, but I can't remember now if I had to change some > > definitions to get rid of long names. > > > > Tomek > > I'm now trying to figure out how the table names are generated, to see > if I can reduce their length. > > The conflicting table name is "ruleShowWebfeed_aWebDisplayFeeds". > > Any help is very much appreciated, thanks, > > Pedro. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" 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/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
