Re: Query Error: Duplicate entry?
>>There is already a check to see if the basket exists before adding the item, so shouldn't be a duplicate basket id. Is there a lock from the time the basket is checket and the query is done? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Error: Duplicate entry?
stylo stylo wrote: > > Query Error: Duplicate entry '75A8BA37-2B3E-7F0C-15E97C353E23FA73_100' for > key 1 Datasource: Native Error Code: 1062 SQL State: 23000 Executing > SQL: INSERT INTO ... > > There is already a check to see if the basket exists before adding the item, > so shouldn't be a duplicate basket id. Apparently there is something wrong with that check. Jochem ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query Error: Duplicate entry?
Does anyone know why I might get this sometimes? Mysql: Query Error: Duplicate entry '75A8BA37-2B3E-7F0C-15E97C353E23FA73_100' for key 1 Datasource: Native Error Code: 1062 SQL State: 23000 Executing SQL: INSERT INTO ... Normally works fine so I don't understand it and google does help much. There is already a check to see if the basket exists before adding the item, so shouldn't be a duplicate basket id. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
