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: