Too many images in product view

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 1.5.26
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : Firefox 35.0.1
-- Error-message(debug-mod must be tuned on) -- : no

After importing VM in Hikashop, the product view shows too many thumbnails. See picture.
How can I remove them?

Hi,

Please check in the table "#__hikashop_files" if the entries are doubled ?
If it is, so you can potentially make a MySQL request to delete the double entries.
stackoverflow.com/questions/3311903/remo...licate-rows-in-mysql

Please backup your database before anything.

Hello Xavier,

I have checked the table jos_hikashop_file and yes there are double images.
In the example, the first image with unique file_ref_id 90 is found on file_id 90, 190, 390, ...
See pictures.
In the backend of Hikashop I also found all these pictures with id's.
But it is not only picture with file_ref_id 90, I think it's every picture which has about 8 extra thumbnails (every product).

I will try to remove this.
But how can this happen by importing a VM webshop?

Hi,

Have you tried to import many times or only one ?

Hi,

I have import just once.
But, I have tried several times to load the 5372 images (or a part of them) from VM directory to Hikashop directory and the tumbnails from VM to Hikashop. And with load I understand copy and paste the directory with images.

I could not find any directions about what to do with the images, only a short description 'Import from VirtueMart'
www.hikashop.com/support/support/documen...port.html#virtuemart
It suggest that the import tool will import images. Well, that is not what happens. You have to copy/paste the images in the right directory. And I do not kow exactly how to handle the thumbnails.

Hi,

Which version of VirtueMart do you had ?

For the images, do you have tried this kind of request in phpMyAdmin to remove the duplications ?
ALTER IGNORE TABLE jobs ADD UNIQUE INDEX idx_name (site_id, title, company );

Regarding the thumbnails, you don't have to manage them, they will be generated automatically by HikaShop.

Hello Xavier,

I have VM version 1.1.9 (the shop is still active) I thought it was 1.1.19, the last of the VM1 series, but it is not !?!
I have not tried phpMyAdmin to change this. I will try it.

I now do understand to do nothing with the thumbnails. Thanks.

Problem is solved with a query in database:
ALTER IGNORE TABLE jos_hikashop_file ADD UNIQUE INDEX (file_path);