Thread

Hi guys,
Trying to run this upgrade and running into this:

{"error":"
Error Number: 1062<\/p>\n\n

Duplicate entry '1' for key 'PRIMARY'<\/p>\n\n

ALTER TABLE `exp_member_homepage` ADD PRIMARY KEY `member_id` (`member_id`)<\/p>\n\n

Filename: updates\/ud_200.php<\/p>\n\n

Line Number: 1700<\/p>"}

Any ideas what’s going on?

Thanks,
Steven

Hi Steven,

I am sorry you’ve had trouble with the upgrade from 1.6.4

The error is a result of trying to run the same statement twice. We see this usually as the result of a server behind a load-balacer.

We have a resource on the Wiki for Troubleshooting Upgrade Errors.

The first step is rolling back the files and database to the pre-upgrade state. If you are behind a load-balancer, any way to step around that for the update process would be recommended.

Once you’ve reset from the backup and tried again, let me know!

Cheers,

Dan,
Sorry managed to resolve this.

I was running locally so no load balancer. Eventually rolled back, run some checks on the db and started again and all was well with the world.

Thanks,
Steven

Hey Steven Grant,

I am glad that Dan was able to help out and that you are back in business.

If you need anything else, please just let me know by opening a new thread.

Cheers,