Oh. You shouldn't because the linked data is basically a cross-reference table. When new nodes are created they will have new objectIDs and should not affect the queries at all. I would still make a backup before I mess with the db directly.
_____ Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Duncan Sent: Monday, April 23, 2007 5:11 PM To: farcry-dev Subject: [farcry-dev] Re: Wierd friendly urls/navalias issue ah - i was asking about deleting all the junk rows rather than simply the alias value within the row. All the "deleted" navigation nodes are producing FU entries when I run the rebuild FU function which is causing the errors decribed above as the friendly url lookup returns the objectId of a navigation item which has supposedly been deleted. Do you know if I would need to remove all the linked data in order to delete the junk rows? Thanks, Duncan On 23 Apr, 20:57, "Jake Churchill" <[EMAIL PROTECTED]> wrote: > No, I believe the dmNavigation table is the only place the alias actually > shows up. I've never seen it anywhere else and the tables you mentioned are > not related to the alias. > > _____ > > Jake Churchill > > CF Webtools > > 11204 Davenport, Ste. 200b > > Omaha, NE 68154 > > http://www.cfwebtools.com > > 402-408-3733 x103 > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > > Behalf Of Duncan > Sent: Monday, April 23, 2007 2:45 PM > To: farcry-dev > Subject: [farcry-dev] Re: Wierd friendly urls/navalias issue > > Would i need to delete any data in any of the other linked tables, > e.g. dmNavigation_aobjectIDs, refobjects, fqAudit? > > On 23 Apr, 20:34, "Jake Churchill" <[EMAIL PROTECTED]> wrote: > > I can't think of any unwanted consequences if you create a custom query to > > do it. I'd backup the table first though. > > > _____ > > > Jake Churchill > > > CF Webtools > > > 11204 Davenport, Ste. 200b > > > Omaha, NE 68154 > > >http://www.cfwebtools.com > > > 402-408-3733 x103 > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On > > > Behalf Of Duncan > > Sent: Monday, April 23, 2007 2:24 PM > > To: farcry-dev > > Subject: [farcry-dev] Re: Wierd friendly urls/navalias issue > > > Hmmm.....further investigation suggests that my problems relate to > > some 1000 navigation nodes and pages i added using the quickbuilder > > and then "deleted" when I first set up the site. When I rebuild the > > FU it adds loads of FU data for these deleted items. > > > Any ideas on how i might delete them? I can identify them all by > > their absence in the nested_tree_objects table. Is this possible or > > will this introduce a new world of pain??! > > > On 23 Apr, 18:18, "Jake Churchill" <[EMAIL PROTECTED]> wrote: > > > Duplicates should be fine. I'm not aware of a quick way to delete nav > > > aliases. They won't hurt anything though. If you really want to get > rid > > of > > > them without editing each and every nav node, I'd edit your dmNavigation > > > table directly. Be ware, I've never done this and don't know what the > > > consequences will be. But this is just a string stored in the table. > The > > > application scope will need to be refreshed after you do it. Also, > > > definitely leave certain nav aliases alone. Root, home, and others > > created > > > by farcry. I'm looking in my table now and I see the following that > > > probably need to be left alone: > > > > lNavIDAlias = root, home, hidden, search, footer, imageroot, fileroot, > > > rubbish > > > > This is FC 3.0.2 > > > > _____ > > > > Jake Churchill > > > > CF Webtools > > > > 11204 Davenport, Ste. 200b > > > > Omaha, NE 68154 > > > >http://www.cfwebtools.com > > > > 402-408-3733 x103 > > > > -----Original Message----- > > > From: [email protected] [mailto:[EMAIL PROTECTED] > On > > > > Behalf Of Duncan > > > Sent: Monday, April 23, 2007 12:10 PM > > > To: farcry-dev > > > Subject: [farcry-dev] Re: Wierd friendly urls/navalias issue > > > > Hi Jake, thanks for this. > > > > Is there a quick way of deleting nav aliases? I created a site using > > > the quickbuilder which created nav aliases for all 1400 pages - doh! > > > > Should farcry allow duplicate FUs or nav aliases? > > > > Thanks, > > > again, > > > Duncan > > > > On 23 Apr, 16:57, "Jake Churchill" <[EMAIL PROTECTED]> wrote: > > > > Friendly URL's are user and search engine friendly ways to access > pages > > so > > > > you don't have objected=<objected> in the URL. The nav alias is > simply > > a > > > > way to refer to a particular node within the application. It's useful > > for > > > > link in nav classes and so forth. If you have a node called > "Contacts" > > > and > > > > create a nav alias of contacts, you can access the object id of that > > node > > > by > > > > #application.navid.contacts#. If you enter more than one nav alias it > > has > > > > to be done in a comma delimited list (i.e. contacts,staff). Each > would > > be > > > > accessible (i.e. #application.navid.contacts# & > > > #application.navid.staff#). > > > > > I don't believe there is anything preventing duplicates of friendly > urls > > > or > > > > nav aliases. Each is simply a pointer to the object ID of the node in > > > > question. > > > > > As far as managing friendly urls, you should be able to do so in Admin > > -> > > > > Manage Friendly URLs or in the object overview page for each node, > there > > > > should be a friendly url link at the bottom (same place as Stats, > Audit > > > and > > > > Properties). > > > > > _____ > > > > > Jake Churchill > > > > > CF Webtools > > > > > 11204 Davenport, Ste. 200b > > > > > Omaha, NE 68154 > > > > >http://www.cfwebtools.com > > > > > 402-408-3733 x103 > > > > > -----Original Message----- > > > > From: [email protected] [mailto:[EMAIL PROTECTED] > > On > > > > > Behalf Of Duncan > > > > Sent: Monday, April 23, 2007 10:45 AM > > > > To: farcry-dev > > > > Subject: [farcry-dev] Wierd friendly urls/navalias issue > > > > > On further investigation it seems that the system is returning 3 > > > > different objects for one friendly url and because 2 of the objects > > > > are not yet approved it requests the log in details. Is it safe to > > > > just go into the refFriendlyUrl table and delete the duplicate urls? > > > > > Can someone please clarify for me the difference between navaliases > > > > and friendlyurls in terms of purpose and functionality? > > > > > Should farcry prevent you from adding duplicate friendly urls and > > > > navaliases? > > > > > Thanks, > > > > Duncan > > > > > On 23 Apr, 14:20, Duncan <[EMAIL PROTECTED]> wrote: > > > > > We are experiencing a strange permissions issue on our installation > of > > > > > farcry. > > > > > > We are running farcry on 2 clustered application servers load > balanced > > > > > at the network level. > > > > > > On one server node when you click on one particular link the user is > > > > > sent to the faracry admin login page, but on the other server node > the > > > > > link works as it should and returns the correct page. I have looked > > > > > at the permissions on that navigation node on both servers and they > > > > > are both identical. The permissionCache.wddx is identical on each > as > > > > > well. > > > > > > Any ideas what may be causing this? > > > > > > Thanks, > > > > > Duncan- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
