Here is my logic on why it should be OK to delete the duplicates..... dmNavigation_aObjectIDs
simply contains a REFERENCE to an existing object. There should be no other relationships to worry about with entries in this table (as long as I only delete ONE entry). I dont believe there would be any other entries in any other tables that I would have to worry about. I would pull all this data back into a testing environment - except that is in "limbo" land at the moment with a large number of server upgrades and replacements we are doing at present. So, unfortunately, I dont have that luxury but still have to resolve the problem. Let me know if the "logic" sounds...... sound. Regards, Gary On Tue, 4 Jan 2005 11:13:41 +1000, Gary Menzel <[EMAIL PROTECTED]> wrote: > 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/ > --- 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/
