Friendly Urls Disappearing

[Duncan]

Hello everyone,

We are experiencing a strange one - periodically additional friendly
urls set up via the manage fu option on a navigation node go missing.
I have tried searching for them in the farcry database table
reffriendlyURL and they are not there.

Has anybody experienced this before? Any ideas on what is happening?
Any solutions to prevent it happening in future?

We are running Farcry 3.0.1.

Many thanks,
Duncan

[Whiterod, David (PIRSA)]

Hi Duncan,

I have experienced this previously with FUs that have been applied to
dmHTML objects (but dmNavs remained OK)

Looks like this: http://bugs.farcrycms.org/browse/FC-712

Cheers

David

[Duncan]

Does anybody have a fix for this issue? Or know what needs to be
fixed?

Duncan

On May 23, 1:25 am, "Whiterod, David (PIRSA)"

[modius]

On May 27, 11:24 pm, Duncan <d.edwa...@ids.ac.uk> wrote:
> Does anybody have a fix for this issue? Or know what needs to be
> fixed?

I've had a look at:
Rebuild Friendly URLs Deletes FUs applied ot dmHTML
http://bugs.farcrycms.org/browse/FC-712

This pertains to Rebuild Friendly URLs -- which is in fact a utility
for wiping and rebuilding the FU table. If this is your problem the
fix is don't use it :)

I suspect that your problem is more subtle. As it stands we do not
have enough information to reproduce the issue and so cannot attempt
to fix it. Please raise a ticket with steps to reproduce the problem
in detail and we'll do our best to fix it.


Thanks,

-- geoff
http://www.daemon.com.au/

PS. It's worth noting that we no longer routinely patch the 3.0.x
maintenance branch. The only exception being for paying support
clients. You should consider upgrading (although without knowing the
nature of the issue your facing upgrading may not fix your issue).

[Duncan]

Hi Geoff,

Thanks for your response. Having done more investigation I think we
have identified that the issue we are experiencing does relate to the
use of Rebuild Friendly Urls. The problem seems to stem from what i
assume to be a typo in the "fRebuildFriendlyURLs" method in Farcry
\farcry_core\packages\types\types.cfc. The query which deletes old
friendly urls for this type:
<!--- delete old friendly url for this type --->
<cfquery name="stLocal.qDelete" datasource="#application.dsn#">
DELETE
FROM #application.dbowner#reffriendlyURL
WHERE refobjectid IN (SELECT objectid FROM
#application.dbowner##arguments.typeName#)
</cfquery>
Should, i assume, actually be a NOT, therefore:
<!--- delete old friendly url for this type --->
<cfquery name="stLocal.qDelete" datasource="#application.dsn#">
DELETE
FROM #application.dbowner#reffriendlyURL
WHERE refobjectid NOT IN (SELECT objectid FROM
#application.dbowner##arguments.typeName#)
</cfquery>

Is this correct? It appears to fix the problem http://bugs.farcrycms.org/browse/FC-712


Steps to reproduce the issue:
1. Create add an additional FU on a dmHTML object using the manage FU
function.
2. Check that the new additional FU has been saved to the database.
3. Run Rebuild FU function from Farcry admin for dmHTML objects.
4. Check that the new additional FU still exists in the database. It
doesn't.

We have been considering the doing the upgrade from 3 to 4 but haven't
had the window to do it as yet :( Would you be able to email me
details of your paid support options?

Many thanks,
Duncan