On 2007-09-03 17:19:49 +0400, AgBr wrote:
I use obs-api-0.1.1-37.1. Is it possible to use frontend with sqlite3 database engine?
my /srv/www/obs/frontend/config/database.yml:
development: adapter: sqlite3 database: db/frontend_development.sqlite3
rake migrate returns an error: [...] SQLite3::SQLException: index role_id already exists: CREATE INDEX "role_id" ON roles_static_permissions ("role_id")
(See full trace by running task with --trace)
What's wrong?
afaik sqlite only supports one index per table. and you get the error when it tries to add the 2nd index. imho this index might be a candidate for a drop. but we have other tables where we definitely need 2 indeces. darix -- openSUSE - SUSE Linux is my linux openSUSE is good for you www.opensuse.org --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-buildservice+help@opensuse.org