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

View: New views
3 Messages — Rating Filter:   Alert me  

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

by pedrobl :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


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.

--~--~---------~--~----~------------~-------~--~----~
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@...
To unsubscribe from this group, send email to farcry-user+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---


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

by Phil Kemp :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

http://www.nabble.com/Farcry-5.1-on-oracle-10.-application.navid.home-undefined-td22438680s621.html

I've already posted there, but if this issue is posted in many places I'd like to find a solution too!

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

by Phil Kemp :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


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@...
To unsubscribe from this group, send email to farcry-user+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---