I have Rails error with save method in ActiveRecord

Question

enter image description here

I found this Error when call save method

My Rails Envi: Rails 3.2.5, sqlite 3.7.12 (in GemFile 1.3.6), latest ActiveRecord

Thanks You in Advance.

This is a Terminal Output rails console --sandbox
Loading development environment in sandbox (Rails 3.2.5)
Any modifications you make will be rolled back on exit
1.9.3-p194 :001 > user = User.new(name: "xxx", email: "yyy")
=> #
1.9.3-p194 :002 > user.save
(0.3ms) SAVEPOINT active_record_1 ActiveRecord::StatementInvalid: SQLite3::SQLException: near "SAVEPOINT": syntax error: SAVEPOINT active_record_1 — Kiattisak Anoochitarom, Jun 08 '12 at 14:54
Related to what @Agis said, does this help? http://yortz.it/2011/03/05/SAVEPOINT-active_record_-1-(ActiveRecord::StatementInvalid) — Oscar Del Ben, Jun 08 '12 at 14:55
@Agis How to database_cleaner ? I'm a newbie in Web Dev and Rails. — Kiattisak Anoochitarom, Jun 08 '12 at 15:07
@OscarDelBen How to database_cleaner ? I'm a newbie in Web Dev and Rails. — Kiattisak Anoochitarom, Jun 08 '12 at 15:09
I found this error while I'm testing my Model with '$ rails console --sandbox' — Kiattisak Anoochitarom, Jun 08 '12 at 15:14

score 0 · Answer 1 · answered Jun 08 '12 at 18:53

ActiveRecord and newer versions of SQLite both support nested transactions, but the AR/SQLite adapter does not.

1 Answers1