RE: SQL 139 transaction error
Error 139 appears to be some kind of bug http://bugs.mysql.com/bug.php?id=10035 Its occurring with a legacy form. Originally error would throw if upload attachment. Changed InnoDB to MyISAM and upload went fine Now if modify text box in form throws same error. Considering switching to MSSQL if cant resolve Any thoughts would be appreciated -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: 2010-10-15 13:23 To: cf-talk Subject: Re: SQL 139 transaction error Since MyISAM is a non-transactional storage engine, the error doesn't make too much sense to me. Are you sure your migration from InnoDB was successful, and that you are infact using MyISAM and not InnoDB on this table? -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting & Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Fri, Oct 15, 2010 at 10:34 AM, cfcom wrote: > > Is anyone familiar with MySql 139 transaction storage error. > I've switched the engine from InnoDB to MyISAM but am still seeing issues. > Am running MySql 5. Am wondering if I should move from open source to a > different DB - Any suggestions or insight would be most appreciated. > > TIA > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL 139 transaction error
Since MyISAM is a non-transactional storage engine, the error doesn't make too much sense to me. Are you sure your migration from InnoDB was successful, and that you are infact using MyISAM and not InnoDB on this table? -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting & Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Fri, Oct 15, 2010 at 10:34 AM, cfcom wrote: > > Is anyone familiar with MySql 139 transaction storage error. > I've switched the engine from InnoDB to MyISAM but am still seeing issues. > Am running MySql 5. Am wondering if I should move from open source to a > different DB - Any suggestions or insight would be most appreciated. > > TIA > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL 139 transaction error
Is anyone familiar with MySql 139 transaction storage error. I've switched the engine from InnoDB to MyISAM but am still seeing issues. Am running MySql 5. Am wondering if I should move from open source to a different DB - Any suggestions or insight would be most appreciated. TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm