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 -~----------~----~----~----~------~----~------~--~---
