Ouch!! I have 77.

~tom


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/
>

---
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/

Reply via email to