rake db:migrate tries to use sqlite :-/

rubyonrails-talk
1

Hi

I'm setting up Instiki on a webserver (VPS, linux.)

Here's my error: [instiki-0.17]$ rake db:migrate (in /home/peter/pehrlich.com/html/instiki-0.17) rake aborted! no such file to load -- sqlite3 /home/peter/pehrlich.com/html/instiki-0.17/rakefile.rb:10 (See full trace by running task with --trace)

And here's my config/database.yml: production:   adapter: mysql   encoding: utf8   reconnect: false   database: pehrlich_wiki   pool: 5   username: peter   password: [hidden]   socket: /var/lib/mysql/mysql.sock

This makes no sense. I've tried everything. Why is it being contrary?

Thanks!!

2

Hi

I'm setting up Instiki on a webserver (VPS, linux.)

Here's my error: [instiki-0.17]$ rake db:migrate

RAILS_ENV=production rake db:migrate

3

No change, unfortunately.

I forget to mention this earlier, I'm using Passenger, if that could change anything!

Greg Donald wrote:

4

I had the same issue and fixed it by removing hard-coded references to SQLite in this file:   lib/tasks/upgrade_instiki.rake

  ...   # The following will not work on a non-SQLite installation   db = SQLite3::Database.new( "db/production.db.sqlite3" )   db.execute( "select * from webs" ) do |row|   ...

I just deleted the entire task and left the file empty, as I currently have no need to upgrade. I'm guessing you could just replace the reference to SQLite with your database of choice if you needed this rake task. I'm happy without it.

-Ben Ridout