Hi Gary, this is some days on so you have probably rersolved the issue, but...
I had the same issue at at client site (they had the file uploaded server 500 error problem). I tracked it down to the same database error and went ahead and blew away dupicate records and this resolved the issue. I had the luxure of recovering their database to my dev server to test. it worked on my dev server and their production server. What caused it? Hmmm, good question - I dont think I worked out why, but it has not occurred since. Server error 500?? - I dont think so; user would try more than twice, maybe up to 5 times, so I would have expextend to see up to 5 duplicate records on some occations. Node moves sounds more plausable to me; and if memory recalls, I do believe this was noted at the time of the issue. client site: b211 win2000 sql 7 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/
