Mysql Error RELEASE SAVEPOINT active_record_1

Rails
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 M. 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

3

On Jan 8, 9:56Â am, Hemant B. [email protected] wrote:

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 C. wrote:

On Jan 8, 9:56Â am, Hemant B. [email protected] wrote:

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

5

I get around this issue :

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

Cheers
Hemant B. wrote:

Where can i get this description … ?

Frederick C. wrote:

On Jan 8, 9:56Â am, Hemant B. [email protected] wrote:

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