So, the table name > 30 characters fixed only half my issue. Unfortunately, after I got the install to complete I was still encountering the same problems as before with the FarCry webtop errors and public site redirect loop.
Digging deeper, I found the application.navid structure was not being populated which is what was causing the infinite redirect loop. I think there is a bug in the getNavAlias() query in the template farcry/ core/packages/types/dmNavigation.cfc for Oracle 10g. The query condition on line 204 had to be commented out in order to get anything to work: "AND lNavIDAlias <> ''" On Apr 22, 2009, at 10:35 AM, nicholas sollecito wrote: > Thank you, Tomek. I was just starting to dig through old posts when > I got your response > > > On Apr 22, 2009, at 10:34 AM, Tomek Kott wrote: > >> >> This has been discussed in a previous thread here: >> http://groups.google.com/group/farcry-dev/browse_thread/thread/3b095f9927a50b7/f5f86ac80a93ec59?lnk=gst&q=ruleRichText+#f5f86ac80a93ec59 >> >> The cause is a table name > 30 characters. >> >> Tomek >> >> On Wed, Apr 22, 2009 at 10:09 AM, nicholas sollecito >> <[email protected]> wrote: >>> >>> So, I decided to start over with a fresh install on Oracle and >>> during >>> the process the step "RULES): Creating ruleRichText table." fails >>> with >>> the following error: >>> >>> "[Macromedia][Oracle JDBC Driver][Oracle]ORA-00972: identifier is >>> too long" >>> >>> struct >>> COLUMN 0 >>> ID CFQUERY >>> LINE 168 >>> RAW_TRACE at >>> cfOracleGateway2ecfc1451488126$funcDEPLOYARRAYTABLE.runFunction(/ >>> var/ >>> www/html/farcry/core/packages/fourq/gateway/OracleGateway.cfc:168) >>> TEMPLATE /var/www/html/farcry/core/packages/fourq/gateway/ >>> OracleGateway.cfc >>> TYPE CFML >>> >>> Digging through to try and find the cause of the error >>> >>> >>> On Apr 21, 2009, at 3:29 PM, Nick S. wrote: >>> >>>> >>>> I recently migrated a FarCry MySQL database to Oracle 10g. I >>>> updated >>>> the dbtype variable (to "ora") in project_folder/ >>>> farCryConstructor.cfm. After changing the DSN and restarting CF, I >>>> can't seem to get my site to work. >>>> The database was migrated using the migration tools built-in to >>>> SQLDeveloper. >>>> >>>> I am able to log in to the webtop, but some sections don't work >>>> and I >>>> can't get to the actual public site any longer. (results in a >>>> redirect >>>> loop). A couple of the problems I'm seeing: >>>> >>>> - Under the "Site" tab, where the site tree should be on the >>>> left, I >>>> get the following: >>>> "The OBJECTID argument passed to the getAncestors function is not >>>> of >>>> type UUID." >>>> >>>> I can't load any of the "Types" or "Rules" under Admin > Developer >>>> Utilities; Every class shows a conflict with a message next to each >>>> property that says: >>>> "TYPE CONFLICT EXISTS: Choose repair type below " >>>> >>>> If I choose to Repair, I get the following error: "Variable >>>> ORIGINALDATATYPE is undefined." >>>> >>>> Any ideas? Do I need to wipe out the database and reinstall? >>>>> >>> >>> >>>> >>> >> >> >> > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
