strange "ps_image" table issue - PS 1.6.1.9

[sergiodub]

After restoring a backup copy of the database, many product images had disappeared (about 800 of 1200 total).

Photos and thumbnails in "img" folder were all in place, but i noticed that PS_IMAGE table contained only 400 records.

I found the following errors in restore logs:

 

Error

Manager

MySQL errors restoring table 'ps_image' in database 'gotticas_ps1'

1/21/17 12:02:45 PM

Error

Manager

Duplicate entry '4875-0' for key 'id_product_cover'

1/21/17 12:02:46 PM

Error

Manager

MySQL errors restoring table 'ps_image_shop' in database 'gotticas_ps1'

1/21/17 12:02:46 PM

Error

Manager

Duplicate entry '4778-1-0' for key 'id_product'

1/21/17 12:03:00 PM

Error

Manager

MySQL errors restoring table 'ps_aff_hits' in database 'gotticas_ps1'

1/21/17 12:03:00 PM

Error

Manager

Duplicate entry '453-2016-04-07-12:43:25-0' for key 'PRIMARY'

 

 

Thinking about a timeout error or something similar, i tried to restore other backups (also of different dates), but i got always the same errors.

 

So i checked various backup, even weeks old, and i noticed that in all of these the "ps_images" table had only 400 records, even if the site has always displayed the images of all 1200 products.

 

If the "ps_image" table always had 400 records, how the site worked well? Where it stored product/image associations until now? Someone has idea of what could be happened and how to fix it?

 

Thanks to all who will help me.