Just to add to this... The query removes any dmHTML objects that do not belong to a dmNavigation node. For most sites those dmHTML objects are impossible to access in the FarCry admin area, so in a dev environment deleting them is pretty reasonable. For a live site you might want to have an 'orphans' dmNavigation node that you can use to reparent orphaned dmHTML objects rather than deleting them.
Spike On Wed, 09 Feb 2005 13:08:51 -0500, Jeff Coughlin <[EMAIL PROTECTED]> wrote: > Jeff Coughlin wrote: > > > > I just finished entering in about another 100+ pages in a client's > > website. After approving all of the pages I went to the Farcry Admin > > homepage to see if I left anything in draft. It says I have an item in > > draft that doesn't exist (I deleted it ealier in the day). If I procede > > to click on the link to the item it brings me to the Site Tree but the > > Site TRee window is blank. No CF errors, just blank. I tried running > > the COAPI tools to fix the tree (no errors found). Updated the app > > scope, no luck. > > With some help from Spike I was able to fix this in the DB. The ghost > dmHTML object (for some reason) wasn't deleted correctly. This has now > happened twice (once for me and once for Spike). In both cases we > right-clicked on the dmHTML object in the nav tree and chose delete. > Somehow the dmHTML object did not get deleted, but was no longer > assigned to a navigation node. > > We ran the following query to look for any ghost dmHTML objects (and > then changed the select statement to delete. Thanks, Spike): > > ------- > SELECT * > FROM dmHTML > WHERE objectid NOT IN ( > SELECT data > FROM dmNavigation_aObjectIDs > ) > ------- > > -Jeff C. > > --- > You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- -------------------------------------------- Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org --- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
