VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: sandstorm on November 21, 2013, 14:47:31 PM

Title: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: sandstorm on November 21, 2013, 14:47:31 PM
I noticed something, by accident when I was trying to export some product information using CSVi.
All my new products I added since updating to VM2.0.22C & now tested with 2.0.24B don't seem to have a thumb image path in my CSVI export.

SO I started digging around and it seems they are not being added to  file_url_thumb field in virtuemart_medias database table.

When I manually load an image into a new product in the back of virtuemart.
The image & thumb are both generated OK but the path for the "Used URL Thumb" in the backend of virtuemart starts with (Default URL) I cant recall wether this was always there or not?
(Default URL) images/stories/virtuemart/product/resized/test_150x150.png
And after checking in virtuemart_medias database table there is no entry in file_url_thumb in the database for the newly added image.

But If in the back end of VM, I remove the (Default URL) & hit save, the screen saves & refreshes.
The Thumb URL still shows the (Default URL) text at the beginning of the path, but now in file_url_thumb in the databse for the new entry, we now have a path entry.

Is this a VM bug or maybe just not used anymore in the newest versions of VM2.0.22+

I tried adding an image and then going to Shop > Media > synchronize & this also doesnt add the thumb path to file_url_thumb in the virtuemart_medias table

Thanks,
Andy
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: sandstorm on November 25, 2013, 11:08:53 AM
Surely I'm not the only person that has noticed this or is being affected by it? ::)

I am not a developer, so I cannot find a solution to the problem, but happy to test any patch if anybody has any ideas?
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: jenkinhill on November 25, 2013, 12:11:06 PM
AFAIK the url/path has not been stored for a few versions now.

Found it: "changed behaviour of media thumbs, the path/url is not stored unless it is an overwrite" in http://forum.virtuemart.net/index.php?topic=115877.msg390380#msg390380
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: sandstorm on November 26, 2013, 13:00:14 PM
Quote from: jenkinhill on November 25, 2013, 12:11:06 PM
AFAIK the url/path has not been stored for a few versions now.
That would make sense as I updated from 2.0.18 to 2.0.22.   Any ideas/help on how to create this as an overwrite. 
I need to use CSVi to export products thumbnails and as they are now not stored anywhere I cant export them.

I read through the forum post that jenkilhill pointed me to, but this just tells us that mediathumbs are now now longer stored?
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: Milbo on November 26, 2013, 13:55:21 PM
They are only stored, if you are using an override, else the path is always created by the same scheme.
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: sandstorm on November 26, 2013, 14:34:11 PM
Spoke with Roland at CSVi.
They are going to modify CSVi, to use the same method as virtuemart
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: lostmail on April 19, 2014, 12:20:07 PM
Quote from: jenkinhill on November 25, 2013, 12:11:06 PM
AFAIK the url/path has not been stored for a few versions now.

Found it: "changed behaviour of media thumbs, the path/url is not stored unless it is an overwrite" in http://forum.virtuemart.net/index.php?topic=115877.msg390380#msg390380

What a nonsense ???
The path is stored since VM 1.x to 2.0 and 2.6 does not.
Any you recommend to upload a thumbnail in a second upload sequence only to fill the structure of the SQL ?

Can anyone tell me what the reason is for that Step back ??

I can not create products with image ulploading and than again "replace Minithumb" only to get the "file_url_thumb" table filled in !!!

Please fix that just in time or give an idea for he "Overwrite" (but I hate overwrites)....
Minithumb is created but SQL not filled  :-\ :-\ :-\ with the path to Minithumb - very usefull  :'(
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: mbrando on April 25, 2014, 22:35:22 PM
Hello,

VM 2.6 and having the same issue. recently used CSVi to up load products with image URLs. I thought they would have processed them but no thumbnails created.

Just (Default URL) images/stories/virtuemart/product/resized/xyz__150x150.jpg for the thumb path.

- Mike
Title: Re: Thumbnail image paths not showing in file_url_thumb in VM_medias table
Post by: Milbo on April 25, 2014, 22:59:41 PM
read the manual!

It is widely explain. you have to do NOTHING ! just upload your picture and DO NOTHING. The thumbs are automatically generated since version vm2.0.0. And the paths are not stored because they are anyway generated. If you change your default thumbsize, then you get now new thumbs. The old system did not create new thumbs. Because the autogeneration is only done IF there is no file. IF there is something written in the thumb path, then it is understand as override. Then it takes always the file written in the path. But that is the wrong way to use it. Only people like JJK selling Art are using the override thumb stuff, because they manually thumb their images.