Rake db:migrate tries to use sqlite :-/

Rails
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

On Fri, Feb 26, 2010 at 4:24 PM, Peter E. [email protected]
wrote:

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

production:
adapter: mysql
encoding: utf8
reconnect: false
database: pehrlich_wiki
pool: 5
username: peter
password: [hidden]
socket: /var/lib/mysql/mysql.sock

–
Greg D.
destiney.com | gregdonald.com

3

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

4

No change, unfortunately.

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

Greg D. wrote:

On Fri, Feb 26, 2010 at 4:24 PM, Peter E. [email protected]
wrote:

RAILS_ENV=production rake db:migrate