Mysql Error RELEASE SAVEPOINT active_record_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

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

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

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

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs