Hi. I have a Virtuemart store manager and I am trying to export / import product images.
After importing, I see images in the media, I see them in the product administration, I see them in other components, but I do not see them on the category page and the product detail page.
I export pole SKU, images, has media.
However, when I open the product in the administration and save it without any change, the images will start to appear. Otherwise I see noimage.gif. Why?
I tried to track the items in the mySql database I don't see any difference in the data before and after saving. What can change with re-saving?
Check that ###_virtuemart_products/has_medias = 1
Quote from: jenkinhill on April 04, 2021, 15:41:42 PM
Check that ###_virtuemart_products/has_medias = 1
Yes, I have
Disable "optimise query for product" in virtuemart config and check if it work.
Quote from: Studio 42 on April 05, 2021, 19:21:18 PM
Disable "optimise query for product" in virtuemart config and check if it work.
Thank you for the advice. I can't find this setting. Is it in administration? Or in a .cfg file?
is that it?
In the first tab "shop" of the config at the bottom
"Optimise sql requests for products"
But this is only available in the latest release
If you do not see it, then your release is to old and the problem is not here.
Quote from: Studio 42 on April 07, 2021, 08:58:04 AM
In the first tab "shop" of the config at the bottom
"Optimise sql requests for products"
But this is only available in the latest release
If you do not see it, then your release is to old and the problem is not here.
I tried to turn it off. Cleared cache. No change.
And if you use virtuemart to add a media; does it work ?
Yes.
All I have to do is open the product with the non-functional image in the front-end in the administration and save it without any changes. And all of a sudden I see photos of the product.
I don't understand why I can see them in administration, in media, on ftp, in Virtumert store manager I see them. I also see them in excel like manager. I just don't see them on the page.
Of course, when I create a test in the VM administration, I see the image.
This is just a shot in the dark, Do You have this option enabled in VM configuration ?
Enable Dynamic Thumbnail Resizing
Jörgen @ Kreativ Fotografi
Quote from: Jörgen on April 08, 2021, 11:06:26 AM
This is just a shot in the dark, Do You have this option enabled in VM configuration ?
Enable Dynamic Thumbnail Resizing
Jörgen @ Kreativ Fotografi
Yes, I have it turned on. Should I try turning it off?
You could try, just to see if it makes any difference, but my guess is that it should be turned on to generate the thumbnails.
Have You tried to delete the old unused thumbnails ?
Jörgen @ Kreativ Fotografi
I try everything. Turn off. Turn on. Delete. The result is still the same. In the administration I see all products with pictures. Not on the web.
I also changed the template. It didn't help.
wrong vendor ID for images - bug or wrong setup in store manager?
We have the same situation with our app Product Import for VirtueMart form xml or csv.
If we wrong setup vendor ID for images, then we see in admin, but not in FE
You can right setup or custom develop or use our app
I think this falls back to the store manager, ask them for help regarding this.
Jörgen @ Kreativ Fotografi
_virtuemart_medias column file_lang . . . . what is it?
manager fills me in this field "
when I delete them, everything works.
Not sure, but as you can have different image for each language it could be important to have either empty or correct language code.
Nice that You have got it working.
Jörgen
yep, setup right language is basic option in our app Import product for Virtuemart too :)
Solved.
If someone has a problem after importing images with this tool, it is caused by inserting the value "" into the file_lang column in the virtuemart_medias table.
Repair:
UPDATE j3_virtuemart_medias SET file_lang = NULL;
Because the quotation marks are meaninglessly inserted into multiple columns, I added another fix:
UPDATE j3_virtuemart_medias SET file_params = NULL;
UPDATE j3_virtuemart_medias SET file_class = NULL;
UPDATE j3_virtuemart_medias SET file_meta = NULL;
UPDATE j3_virtuemart_medias SET file_description = NULL;
I'm not a programmer and I helped myself with the MySQL manual. He would definitely come up with a nicer notation.
For other:
This fix break functional for multilanguage shop with multilanguage images - use it carefoul or hire right developer for right fix.
This is just a fix for the eMagicOne Store Manager for Virtuemart (https://emagicone.com/products/solutions-for-virtuemart/) bug, which you can now download and use for free. The company has completed further development of this program, so I asked about the forum here. Because I found a solution, I will write it here without further unnecessary comments so that others can know.
I wrote about the problem above. The solution is to replace the values that the program incorrectly created. This modification changes all items in the table. If you want to modify only some, you must use the WHERE parameter.
More here: http://dev.mysql.com/doc/refman/5.1/en/update.html
Thank you for your cooperation