This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
October 01, 2010 9:47am
Subscribe [3]#1 / Oct 01, 2010 9:47am
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
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
Seems like there where some dupicate id numbers in members tables.
Solved, manually.
Thanks.
#4 / Oct 04, 2010 2:03pm
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.