Thread

The upgrade process has been breaking for me.  I have repaired the tables in question and tried many alternate processes. 

I am getting this error:

ALTER TABLE `exp_category_posts` ADD PRIMARY KEY `entry_id_cat_id` (`entry_id`, `cat_id`)

I got a similar error on the ping table but deleted the contents to get around it.

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

I didn’t want to loose my categories, what should I do to get this thing working?

Hi, eyevariety. You’re attempting to upgrade from 1.7.1 to 2.1.3 or 2.1.4 beta?

This was to 2.1.3- sorry for my slow response, I hadn’t realized you had replied.

Hi eyevariety,

Was your site originally developed on an earlier version of EE? If so, do you recall which one? Which addons are you using in your 1.7.1 installation?

Cheers

Greg

Greg this site was started on 1.6.1 maybe, 3 or 4 years ago. 

Lots of addons: Rating, User, Playa many others.  I have tried to strip out any non-essential addons before the upgrade.  But honestly that doesn’t seem like issue here.  The only addon I used that effected categories was category check box and I didn’t use anything that effected pings. 

All tables where checked and repaired prior to upgrading.

Any tips are very welcome!

Hi eyevariety,

Please confirm that everything was working fine in version 1.7.1. before you tried to upgrade. Did you test your site or did you just attempt to go straight to 2.1.3? Do you have backups of both your original site and the 1.7.1 version?

Cheers

Greg

1.71 is running fine on the live version of this site.  I would be glad to run any tests this afternoon, just tell me what to do.

Hi, eyevariety.

If you DESC exp_category_posts from inside your EE1.x install or via PHPMyAdmin, what results do you get?

Admin ›  Utilities ›  SQL Manager ›  Database Query Form

entry_id   int(10) unsigned   NO   MUL   0  
cat_id       int(10) unsigned   NO   MUL   0  

Thanks 😊

eyevariety,

What actual error do you get when you run

[code]ALTER TABLE `exp_category_posts` ADD PRIMARY KEY `entry_id_cat_id` (`entry_id`, `cat_id`)

</code></pre>

in the same place?