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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
