I have tracked it down to the following table: dmNavigation_aObjectIDs
Where the "data" field has the duplicate entries against the "dmFile" root item from the dmNavigation table. Do you think it be safe for me to delete the duplicates? Is there anything else you can think of that may also need adjusting besides the entries in that table? (I can't, as these are just "array" objects of the dmNavigation type and I am only deleting a duplicate - not the whole entry). I am at a loss to see how ALL of these could just suddenly be duplcated by someone trying to move a single node. Regards, Gary On Mon, 03 Jan 2005 20:01:50 -0500, Jeff Coughlin <[EMAIL PROTECTED]> wrote: > Gary Menzel wrote: > > This was first reported by an Admin person on their machine.... and > > then immediately duplicated on mine. > > > > I cannot see anything related to dmFile in the nested_tree_objects > > table - so I cannot see that using FIX TREE would actually help. > > Now I do remember this happening to me once a while back. It wasn't in > the file tree, rather the site tree (under home). I posted a few > messages here but no one was able to help. When I ran FIX TREE it made > things worse (website was completely unusable. Things happening in the > js tree that seemed haunting). After working on it for a couple hours > and getting a lot of complaints from the department who needed to use it > I had no choice but to revert to the previous night's DB backup. They > lost several hours of work. > > I can only guess it was from moving objects around in the tree (thats > what was done before the error happened). > > If you can't revert to a previous backup then I hope someone here can > help you. At the time of my issue Geoff Bowers was willing to take a > look at a copy of the DB, but my client didn't have any more time to > wait. Perhaps someone here can offer the same assistance. I would be > willing to look at the data if your client's information is not private. > Feel free to email me and I'll see if I can take a look at the data (I > use MSSQL). > > -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/
