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

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
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-user" group.
To post to this group, send email to farcry-user-/[email protected]
To unsubscribe from this group, send email to farcry-user+unsubscribe-/[email protected]
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---