rake db:migrate tries to use sqlite :-/

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!!

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

No change, unfortunately.

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

Greg Donald wrote:

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