Yet another reason why I hate to use CFID and CFTOKEN. Roll your own is the way to go...
The recommendation to use UUIDs is probably your best bet. How long will it take to modify your code? Another solution is to manually clean out the CDATA and CGLOBAL tables. My guess is you have a bunch of old records in there where people haven't come back in AGES. Remember, CF has been known to not properly clean up the CDATA and CGLOBAL tables even though the CFAdmin settings are in there. You'll be able to quickly determine this by looking at your database tables (please tell me you ARE using database tables right?) -Novak ----- Original Message ----- From: "John Paul Ashenfelter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 1:17 PM Subject: Client variable problem -- duplicates in CDATA > 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
