I traced the migrations via the development.log file.
On migration 50_creating_initial_schema, line 38, a user_id index is
added to sb_posts,
add_index "sb_posts", ["user_id", "created_at"], :name =>
"index_posts_on_user_id"
Then on migration 60_still_more_indexes, line 3, a user_id index is
added to posts,
add_index :posts, :user_id
Here are the entries in the development.log file:
[4;36;1mSQL (0.120000) [0m [0;1mCREATE INDEX
"index_posts_on_user_id" ON "sb_posts" ("user_id", "created_at") [0m
[4;36;1mSQL (0.000000) [0m [0;1mSQLite3::SQLException: index
index_posts_on_user_id already exists: CREATE INDEX
"index_posts_on_user_id" ON "posts" ("user_id") [0m
according to SQLite a duplication error occurs for
index_posts_on_user_id even though they were created on different
tables. I'm fairly new to Rails, SQLite and CommunityEngine, so please
advise me if I made an error on my analysis.
On Nov 1, 7:10 am, "Bruno Bornsztein" <[EMAIL PROTECTED]>
wrote:
> Could this be a SQLite issue? Does this happen if you use MySql?
>
> On Fri, Oct 31, 2008 at 3:19 PM, Oli <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I am using Rails 2.1.2, the latest commit of Community Engine and the
> > Engines plugin. When migrating the database it fails on migration 060
> > with the line
>
> > == 60 StillMoreIndexes: migrating
> > ===========================================
> > -- add_index(:posts, :user_id)
> > rake aborted!
> > SQLite3::SQLException: index index_posts_on_user_id already exists:
> > CREATE INDEX "index_posts_on_user_id" ON "posts" ("user_id")
>
> > I looked through the migrations and couldn't spot the command being
> > used previously, so I don't know what the problem is. Any help
> > appreciated.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CommunityEngine" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/communityengine?hl=en
-~----------~----~----~----~------~----~------~--~---
