Updating To Latest Shows Multiple Products With Same Id In Admin

[Walrus]

Having updated to latest from 1.6.0.11 to latest, I now see duplicate and triplicate products with same ID in Admin. For example: ID 2, 2, 3, 3, 3, 4, 5, 5, 5, 6, 6, 6, 7 (there's only 6 products for sale).

 

I can delete the dupes but will this cause a problem? For example delete the real product, and not the ghosts.

 

Where is Admin getting the dupes from? In MySQL, there only the 6 products listed with individual IDs: 2 to 7.

 

What's weird is editing ID 2 or its copy updates the product on the site.

 

TIA.

[tuk66]

1)

PrestaShop is right and your database is corrupted

 

2)

It is a PrestaShop bug and your database is right

[Walrus]

If it helps, there were no duplicate or triplicate products after updating but when I made some changes and returned to products page, I saw copies.

 

Deleting one of the ghost copies also deletes the product!

 

Anyone with some helpful solutions?

[El Patron]

If you doing this one of test system and just recopy your production and run it again. This might be better to retest then delete record. Test test test lol

[Walrus]

I tried to setup a test store for this site but had so many problems not only installing. For example, I unpacked on the server and then couldn't install (support found file permissions weren't being set to 644 -- this has NOT been a problem before). Having installed, I also had problems importing the live store database, which someone tried to help with but it was just taking too long, so I haven't gone back to it.

 

Where is admin product page getting the products from? Is it caching? I haven't found any and I deleted the main cache more than once. Is there corrupt code somewhere that triggers dupes when you do something else? For example, add features.

 

As I said at the top of the thread, the SQL product tables match number of that should show. Are there other tables that PS creates for viewing?