Purging is *supposed* to be automatic -- every 24 hours according to the MM technote. I checked and am applying the hotfix for the ODBC cvs odbc issue in the registry mentioned in one of the MM technotes. I manually purged about 30 days ago. Based on their site user behavior, we're leaving the automatic purge window in CF admin at 90 days. Since the database is ODBC MS-SQL, it's easy enough to schedule the purge in the database.
Thanks for the UUID thought -- I think that's the easiest solution, but the application is really brittle -- piece of junk, really. Written by a PHP house that was doing a contract that basically paid them to "learn" coldFusion -- there's a lot of strange code where they manually change cookies instead of letting cf manage the client state -- it's nuts. It *looks* like using UUIDs would be easy, but I'd like to spend more time on the next version of the site than untangling the mess of this one if I can avoid it. I will be testing this to see how it goes, but am not hopeful. Regards, John Paul Ashenfelter CTO/TransitionPoint ----- Original Message ----- From: "Jamie Jackson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 5:26 PM Subject: Re: Client variable problem -- duplicates in CDATA > How often are you purging the client store? Also, the switch to > UUID-based keys is usually painless (just the flip of a switch), but I > guess you're doing something odd with the client tokens? > > Jamie > > On Tue, 24 Jun 2003 16:17:46 -0400, in cf-talk you wrote: > > >Hi folks, > > > >Working with a client on an existing website -- we're getting this error: > > > >"Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'" > > > >We're using ColdFusion 5, MS-SQL 2000, Win2k server, Apache 1.3.24 web server. Client variables are being stored in an ODBC database. > > > >Of course it's straightforward to remove the offending row, but it's happening about once a week now to random visitors (that is, one or maybe two errors per week). Any thoughts? Googling turned up 2 not too useful hits. No luck in MM technotes so far, other than the suggestion to go to UUID-based keys, which would require reworking parts of the application. > > > >We've got about 400,000+ client ids/month, which seems really high to me based on site traffic, so I think somethings going on with the weird session/client/cookie "security" management code written by the original developers. Using Pro, not Enterprise so MIB client variables shouldn't be an issue. Any other thoughts? > > > > > >Regards, > > > >John Paul Ashenfelter > >CTO/Transitionpoint > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
