Thread

I get errors:

First I get an error about templates, but at least there’s a link to bypass that and continue.

Then:

{"error":"

Error Number: 1062
\n\n

Duplicate entry '9644-304' for key 1
\n\n

ALTER TABLE `expeng_entry_ping_status` ADD PRIMARY KEY `entry_id_ping_id` (`entry_id`, `ping_id`)
"}

I’ve rolled back my database several times and retried, and repaired the tables.  I’ve read all the other threads about this and nothing mentioned there has worked here.

DeltaJo,

What was your template error?
What build are you updating to?

What have you already tried as advised on the other threads?

John Henry I appreciate that you would want more than what I’ve given you but there really isn’t much more to tell you. 

The template error I mentioned previously did not re-occur in my latest effort just now.

Instead, it again just got to this point:

http://www.mysite/system/index.php?C=wizard&M=do_update&agree=yes&language=english&ajax_progress=yes

{"error":"

Error Number: 1062
\n\n

Duplicate entry '9644-304' for key 1
\n\n

ALTER TABLE `expeng_entry_ping_status` ADD PRIMARY KEY `entry_id_ping_id` (`entry_id`, `ping_id`)
"}

I’m updating to build 20100805.

I’ve tried whatever I could garner from other threads:  checking my permissions; re-checking the index.php file for my renamed system folder reference; repairing and optimizing my tables prior to updating, etc.

Take a look at your expeng_entry_ping_status table. Hit Browse on it if you’re using phpMyAdmin, then sort by entry_id. Do any two rows have the same entry_id and ping_id? If so, you can delete one of the duplicate rows.

Yikes.  There are thousands of entries.

DeltaJo, as we know you have a database backup already try this. Open up /system/installer/updates/ud_200.php and comment out line line 1126 like so:

//        $Q[] = "ALTER TABLE `exp_entry_ping_status` ADD PRIMARY KEY `entry_id_ping_id` (`entry_id`, `ping_id`)";

Then save and try the update again.

Brandon,

Yes — that got me through the update.  Phew.  And thanks very much!

Now of course I wonder what skipping that step will do.

The code just adds a primary key to the table. But glad Brandon was able to help. Don’t hesitate to post again as needed.