If you are getting the following exception on a migration on Darwin / OS X:

SQLite3::SQLException: near "ADD": syntax error: ALTER TABLE "xxx" ADD "yyy" varchar(255)

then you can try the following:

  1. sudo gem uninstall sqlite3-ruby
  2. Install the latest sqlite3 from sources from sqlite.org
  3. sudo gem install sqlite3-ruby

Using SQL LIKE with find in Ruby On Rails

Are you interested in reading more from CodingClues?
Then subscribe to new postings via RSS or via E-Mail.

close Reblog this comment
blog comments powered by Disqus