Nice work! Thanks for catching that. It's fixed in the latest version.
On Mon, Nov 3, 2008 at 1:57 AM, jc <[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
