Forum: Ruby on Rails Mysql Error RELEASE SAVEPOINT active_record_1

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
4349a46c5faf5658a7240c22b3c4c21f?d=identicon&s=25 Bob Mundane (pgs)
on 2009-03-31 09:42
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
5fa24420cee32bd1d97e2fd3a61de37f?d=identicon&s=25 Hemant Bhargava (hemant-bhargava7)
on 2010-01-08 10:56
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
81b61875e41eaa58887543635d556fca?d=identicon&s=25 Frederick Cheung (Guest)
on 2010-01-08 11:30
(Received via mailing list)
On Jan 8, 9:56 am, Hemant Bhargava <li...@ruby-forum.com> 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
5fa24420cee32bd1d97e2fd3a61de37f?d=identicon&s=25 Hemant Bhargava (hemant-bhargava7)
on 2010-01-08 15:08
Where can i get this description .. ?


Frederick Cheung wrote:
> On Jan 8, 9:56 am, Hemant Bhargava <li...@ruby-forum.com> 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
802412b10b72714330917c139a240f30?d=identicon&s=25 Hery Hallelujah (hallelujah)
on 2010-03-11 10:37
I get around this issue :

http://my.rails-royce.org/2010/03/11/mysql-4-x-and...

Cheers
Hemant Bhargava wrote:
> Where can i get this description .. ?
>
>
> Frederick Cheung wrote:
>> On Jan 8, 9:56 am, Hemant Bhargava <li...@ruby-forum.com> 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
This topic is locked and can not be replied to.