So I just checked my dmNavigation.cfc file, and I have this:
WHERE lNavIDAlias IS NOT NULL
Of course, I don't know if that's there because I fixed it a long
while back or if its normal, but I haven't had a problem with it, so
maybe that'll do the trick for you.
Tomek
On Wed, Apr 22, 2009 at 2:38 PM, nicholas sollecito
<[email protected]> wrote:
> 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 cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---
