Hello. We have been having this problem for several months, and we think it is contributing to the horrible slowness of our site. The error message (which does have an incomplete thread on hosueoffusion: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:26248?subject=Cannot-insert-duplicate-key-row-in-object-CDATA-with-unique-index-id1- )
This is the exact error: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; ..NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1), ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. Date/Time: 06/19/06 14:16:30 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Additionally, we have set that particular table to have coldfusion expire the records after two days. Doesnt help. Was there any resolution to this persons original issue from 2003? any help appreciated carl ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244164 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
