Test-db on SQLite: getting "index xx already exists" error

Hi all

I wanted to speed up my tests, so I changed my test environment from
MySQL to SQLite. I’m on OSX 10.4 so SQLite3 is already installed.

I changed the test env to the following:

SQLite3::SQLException: index name_unique already exists: CREATE UNIQUE
INDEX “name_unique” ON link_categories (“name”)

But after running rake db:test:prepare I got the following error:

SQLite3::SQLException: index name_unique already exists: CREATE UNIQUE
INDEX “name_unique” ON link_categories (“name”)

After changing back to MySQL everything worked again. What’s wrong
here?!

Thanks
Josh

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs