[SOLVED] Duplicated Categories after upgrade problem

[lozaria]

Hello,

I made a clean upgrade - no other modules, no other themes than the native 1.4 ones.

However I'm getting all my categories in Categories Block duplicated. The duplicates have the same ID as the originals so I guess that the problem is within the Category Block.
I tried to delete and reimport the categories from .csv file but the problem still occurs.

Here is the site: http://www.kristo-trade.com/prestashop/

Thanks!

[lozaria]

I found the answer: http://forge.prestashop.com/browse/PSCFI-1616

The fix is to delete the duplicated records in table category_group.

I made it in the following way in phpMyAdmin / SQL:

That creates new table ps_category_group_temp without duplicated rows:

CREATE TABLE ps_category_group_temp AS SELECT ps_category_group.id_category, ps_category_group.id_group
FROM ps_category_group
GROUP BY ps_category_group.id_category, ps_category_group.id_group;

Then rename the old table to ps_category_group_OLD and the new to ps_category_group

RENAME TABLE ps_category_group TO ps_category_group_OLD

RENAME TABLE ps_category_group_temp TO ps_category_group

[Dakota3511]

Thanks for your post. Problem seems to be solved however i still see duplicated categories in the home while, when i enter in one product, the list its shown correct. Any help to find the clue to solve this?

http://www.tuherramienta.es

Thank you again.

[Dakota3511]

It is now solved. May be there was a cache showing me wrong information.

Your detailed solution was of great help. thanks.

[mrzoom]

It worked almost for me, I had to do the same with ps_category_group.

[kosmik]

I ugraded from 1.3.6 to 1.4.1 and have duplicated categories too..
Can't really tell what's wrong but table ps_category_group does have duplicate records with no clear patterns as not every category was affected.

Manually removed the duplicates but not immediately see the correct result. Tried disabling performance/cache and it worked! Enabled the cache and the categories go duplicate again.

Now I noticed categories only showing only in my default language even after I switched language - another headache to fix next

[davers44]

You should try to clear the cache folder manually.
Anyway I noticed category duplication in 1.4.1 even without upgrade but just importing a backup database. As said not easy to solve promptly as things gets complicated switching language too.