Thread

Have finally bitten the bullet and decided to upgrade to version 2, use lots of galleries so have been putting it off.

However when running the Wizard I get the following error -

A Database Error Occurred

Error Number: 1062

Duplicate entry ‘11’ for key ‘PRIMARY’

ALTER TABLE `exp_weblog_data` ADD PRIMARY KEY (`entry_id`)

Filename: /var/www/vhosts/habrann.com/httpdocs/backend/expressionengine/libraries/Smartforge.php

Line Number: 351

Have checked the database and only seem to have one record with the entry_id of 11, can anyone suggest a solution?

Thanks

David

As a follow up, I tried deleting entry ‘11’ but just then falls over on entry ‘12’ with the same error message.

David

Trying again on a localhost but still get an error -

A Database Error Occurred

Error Number: 1062

Duplicate entry ‘11’ for key ‘PRIMARY’

ALTER TABLE `exp_weblog_data` ADD PRIMARY KEY `entry_id` (`entry_id`)

Filename: E:\wamp\www\system\codeigniter\system\database\DB_driver.php

Line Number: 330

We have gotten the “Duplicate entry for key ‘PRIMARY’” before when we have manually deleted data out of a table but not deleted all the associated entries with that ID in other tables.

For us it was when we were dealing with member registration spam, so it was the member_id, but it sounds like that could be your problem. You’ve got some rogue entries in tables for some reason.

Thanks Brandon, that got me upgraded. Now just have to figure out why I can’t login!