ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

database error upgrading 1.6.9 to 2.1

October 01, 2010 9:47am

Subscribe [3]
  • #1 / Oct 01, 2010 9:47am

    helain le blanc

    10 posts

    This question may be related to a resolved thread.

    A Database Error Occurred

    Error Number: 1062

    Duplicate entry ‘7’ for key 1

    ALTER TABLE `exp_member_homepage` ADD PRIMARY KEY `member_id` (`member_id`)

    Upgrading from 1.6.9 20100805 to 2.1.0 last build

    Any help will be pleased

  • #2 / Oct 01, 2010 5:40pm

    Sue Crocker

    26054 posts

    Hi, helain.

    Double check that you have the same number of entries for the following tables:

    exp_members
    exp_member_homepage
    exp_member_data

    Any differences?

  • #3 / Oct 04, 2010 4:40am

    helain le blanc

    10 posts

    Seems like there where some dupicate id numbers in members tables.

    Solved, manually.

    Thanks.

  • #4 / Oct 04, 2010 2:03pm

    Brandon Jones

    5500 posts

    Glad Sue helped, helain!

    Definitely back up your database and run a repair and optimize to be safe. Don’t hesitate to start a new thread.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases