Farcry 5.1 on oracle 10. application.navid.home undefined

[pedrobl]

Hi!

I've just installed farcry 5.1 using Oracle 10. I had to modify a
couple of files for the installation to finish, because Oracle doesn't
support table names longer then 30 characters... :P I posted the
details in the farcry-dev group:
http://groups.google.com/group/farcry-dev/t/3b095f9927a50b7

Anyway, once installed I get a couple of errors that I think are
related:

1. If I browse to the application url http://server/project, I get a
"Redirect loop" error.

2. If I try to manage the users using the page
http://server/farcry/core/webtop/admin/customadmin.cfm?module=customlists/dmProfile.cfm
I get an exception, with the following message: "Variable
application.navid.home is undefined."

Most of the admin pages work fine, but some fail with the same error.
Any ideas? TIA

Pedro.

[phili...@gmail.com]

Pedro,

I have found a solution, but not one that deals with the issue at the
installation stage. Here's what I did:

- I followed the code to find the query that would otherwise populate
the navid structure.
- I looked at the query and improved it (although on a SQL Server
install the original works fine)
- I changed the file /core/packages/types/dmNavigation.cfc
- In the getNavAlias function above the existing query:

<cfif application.dbtype eq "ora">
<cfquery datasource="#arguments.dsn#" name="q">
SELECT nav.objectID, nav.lNavIDAlias, ntm.nLeft
FROM #application.dbowner#dmNavigation nav
LEFT JOIN #application.dbowner#nested_tree_objects ntm ON
nav.objectid = ntm.objectid
WHERE lNavIDAlias IS NOT NULL
ORDER BY ntm.nLeft
</cfquery>
<cfelse>
<!--- original query --->
</cfif>

- That only half solves the issue. The rest is the one done at install
where the navid structure is created.
- To solve this, open the /core/webtop/site/sidebar.cfm and put the
following at the top:

<cfif not isDefined('application.navid.home')>
<cfset application.navid = createObject("component",
application.stcoapi["dmNavigation"].packagePath).getNavAlias() />
</cfif>

- Then log into the admin and go to the site page, which should now
load the side bar without the navid.home error.

You'll also be able to look at the view page as well without the
redirect loop!

(I thought this issue would be much more complex than modifying the
query ever so slightly)

-Phil