I went for a slightly simpler option. I backed up the table (so I had a quick way to rollback) and then manually edited a single entry to see if it all worked OK (which it did).
I then proceeded to manually delete each of the duplicates (there are only 25 files in there). The backup remains and I will observe over the next couple of days. I recently saw a request for a schema diagram regarding FarCry. And, while I do know the schema fairly well, it would be nice to have some documentation on it (e.g. how some of the Nav stuff works - i.e. FILE root item uses aObjectID's for each file, etc. etc.) Regards, Gary On Mon, 03 Jan 2005 22:31:04 -0500, Jeff Coughlin <[EMAIL PROTECTED]> wrote: > Gary Menzel wrote: > > 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. > > It sounds like a good place to test, however I any testing like this > should really be done on a dev box. If you can't get your hands on a > development server you might want to consider using a workstation. I do > much of my CF development on my laptop (WinXP,IIS,CFMX,MSSQL). > > If this is not an option and you "must" work on the production server > please make sure to make a DB backup first. Then make a new database > and restore the backup there (leaving the old website running). Make a > new Farcry website and point it to the new database (*See note below). > Then you can do all the tests to the DB you want. However, I do suggest > that you consider another option like working on another server/workstation. > > *note: Since you are making a copy of an existing Farcry website there > is no need to run the Farcry installer. Instead make your farcry > project folder and copy the files in there. Then adit the > _ServerSpecificVars.cfm file (edit the custom variables) and > Application.cfm (give it a new Application name). Make a new website in > your webserver and point it to the <newProject>/www folder, and a > virtual directory for the adminstrator. Create a new datasource and > point it to the new backup/dev database. I don't think I forgot > anything, but its late here and I'm doing this from the top of my head. > Good luck. > > -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/
