Mysql Error RELEASE SAVEPOINT active_record_1

rubyonrails-talk
1

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

2

Even i am searching answer for the same .. Champs please write something .. :slight_smile:

Bob Mundane wrote:

3

Even i am searching answer for the same .. Champs please write something .. :slight_smile:

If I remember correctly there is a method in mysql_adapter that says it supports savepoints, you could override it and return false

Fred

4

Where can i get this description .. ?

Frederick Cheung wrote:

5

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: