Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

auto_migrations does not accept the name and unique options

#151

This instruction:

add_index "us_hits", ["user_id", "operatingsystem_id", "jdk_id", "product_id", "version_id", "nl_id"], :name => "user_id"

is failing, the name of the index is not user_id:

add_index("us_hits", ["user_id", "operatingsystem_id", "jdk_id", "product_id", "version_id", "nl_id"])

rake aborted!

Mysql::Error: Identifier name 'index_us_hits_on_user_id_and_operatingsystem_id_and_jdk_id_and_product_id_and_version_id_and_nl_id' is too long: CREATE INDEX `index_us_hits_on_user_id_and_operatingsystem_id_and_jdk_id_and_product_id_and_version_id_and_nl_id` ON us_hits (`user_id`, `operatingsystem_id`, `jdk_id`, `product_id`, `version_id`, `nl_id`)

Reported by toulmean · November 8th, 2007 @ 03:06 PM

State: resolved
Milestone: none
Assigned to: PJ Hyett PJ Hyett

Activity

  1. toulmean
    toulmean

    From my investigations, it looks like line 107 of the auto_migrations file is failing.

    I will provide a fix for this tomorrow, unless someone feels up to the challenge ?

    November 8th, 2007 @ 03:08 PM

  2. Chris Wanstrath
    Chris Wanstrath
    • Assigned user changed from Chris Wanstrath to PJ Hyett
    • State changed from new to open

    November 8th, 2007 @ 03:12 PM

  3. toulmean
    toulmean

    Attached a patch. It works for me.

    November 9th, 2007 @ 02:53 AM

  4. PJ Hyett
    PJ Hyett
    • State changed from open to resolved

    patch applied, thanks for making AM better.

    November 9th, 2007 @ 10:12 AM

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.