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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
