Glad I could help.
On Nov 4, 9:29 pm, "Bruno Bornsztein" <[EMAIL PROTECTED]>
wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
