Hi, I''m trying to upgrade an app from 2.2.2 to 2.3.2 and I get a bunch of Mysql Errors : Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''RELEASE SAVEPOINT active_record_1'' at line 1: RELEASE SAVEPOINT active_record_1 Mysql version is 4.1.22 which supports save points but not the RELEASE SAVEPOINT command. I did a test under mysql console. So, - is Rails 2.3.2 incompatible with mysql 4.1.22 ? - is there a special Mysql adapter ? Thanks -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Even i am searching answer for the same .. Champs please write something .. :) Bob Mundane wrote:> Hi, I''m trying to upgrade an app from 2.2.2 to 2.3.2 and I get a bunch > of Mysql Errors : Mysql::Error: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near ''RELEASE SAVEPOINT active_record_1'' at line 1: > RELEASE SAVEPOINT active_record_1 > > Mysql version is 4.1.22 which supports save points but not the RELEASE > SAVEPOINT command. I did a test under mysql console. > > So, > - is Rails 2.3.2 incompatible with mysql 4.1.22 ? > - is there a special Mysql adapter ? > > Thanks-- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Jan 8, 9:56 am, Hemant Bhargava <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> Even i am searching answer for the same .. > Champs please write something .. :) >If I remember correctly there is a method in mysql_adapter that says it supports savepoints, you could override it and return false Fred> Bob Mundane wrote: > > Hi, I''m trying to upgrade an app from 2.2.2 to 2.3.2 and I get a bunch > > of Mysql Errors : Mysql::Error: You have an error in your SQL syntax; > > check the manual that corresponds to your MySQL server version for the > > right syntax to use near ''RELEASE SAVEPOINT active_record_1'' at line 1: > > RELEASE SAVEPOINT active_record_1 > > > Mysql version is 4.1.22 which supports save points but not the RELEASE > > SAVEPOINT command. I did a test under mysql console. > > > So, > > - is Rails 2.3.2 incompatible with mysql 4.1.22 ? > > - is there a special Mysql adapter ? > > > Thanks > > -- > Posted viahttp://www.ruby-forum.com/.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Where can i get this description .. ? Frederick Cheung wrote:> On Jan 8, 9:56 am, Hemant Bhargava <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote: >> Even i am searching answer for the same .. >> Champs please write something .. :) >> > > If I remember correctly there is a method in mysql_adapter that says > it supports savepoints, you could override it and return false > > Fred-- Posted via http://www.ruby-forum.com/. --001485e9a5705214ca047ca7b772 Content-Type: text/plain; charset=ISO-8859-1 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. --001485e9a5705214ca047ca7b772--
I get around this issue : http://my.rails-royce.org/2010/03/11/mysql-4-x-and-rails-release-savepoint-issue/ Cheers Hemant Bhargava wrote:> Where can i get this description .. ? > > > Frederick Cheung wrote: >> On Jan 8, 9:56 am, Hemant Bhargava <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote: >>> Even i am searching answer for the same .. >>> Champs please write something .. :) >>> >> >> If I remember correctly there is a method in mysql_adapter that says >> it supports savepoints, you could override it and return false >> >> Fred-- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.