VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Art_Koenig on February 08, 2012, 01:19:34 AM

Title: Upgrade to 2.0.1e - product image disappeared
Post by: Art_Koenig on February 08, 2012, 01:19:34 AM
Hi there,

I've just upgraded from 2.0.0 stable to 2.0.1e and the image of my product (I only have one product in my shop) just disappeared on the front-end.
In the product description in the back-end the image is still there.

I'm running Joomla 2.5.1.

I just want to be sure this prob has a quick fix because I want to upgrade an other site the same way which has 400 products and I don't want to reassign/reupload 400+ pictures ;).

Thanks for your help!
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: brentonking on February 08, 2012, 07:48:15 AM
Go to edit the product in the backend of virtuemart and then go to the "Product Images" tab and check if you can see the picture there. If so, make sure the "File Published?" box is checked under the image.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: Elnino on February 08, 2012, 08:18:57 AM
Thanks a lot.

You were right, the "File published" box was unticked ...

It leads then to a second question: on this site I just have one product to sell so that's fine to re-tick this box but I don't want to go in my 400 product pages on my other website if the upgrade from 2.0.0 to 2.0.1e makes all my pictures unpublished ...

What are my options ? Is this a known bug of the upgrade?

Thanks again.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: Art_Koenig on February 09, 2012, 00:12:44 AM
I've just tested on my 400 products website and it did the same stuff ... All my media files become unpublished ...
I have to republish them one by one.

Good thing I made a backup ;).
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: brentonking on February 09, 2012, 01:04:03 AM
I'm not sure what the options are here. I had a site with 40 products and decided to open up the database .sql file for jos_virtuemart_medias and changed it there. Not a quick fix, but faster than doing it individually. There might be a configuration option that automatically sets them to published, that you have to change in the "com_virtuemart.2.0.1.?.zip" or "com_virtuemart_ext_aio_2.0.1.zip?" file before you install/update it, but I wouldn't know where that lives in the files.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: Art_Koenig on February 09, 2012, 01:37:52 AM
Oh ok so you had the same trouble. Good to know I was not the only one. Yes I changed it in PHPMyAdmin too.
For those who have the issue, here's the SQL command you want to use if you want to publish all your files that aren't published (which was my case as I don't have any files on the server that I don't want to publish):

UPDATE jos_virtuemart_medias
SET published='1'
WHERE published='0'


That did the trick for me.

VM team, please take care of this issue when we upgrade from a previous 2.0.0 version. I must add not 100% of my media were unpublished so I really don't know on which criteria some media became unpublished during the upgrade ... It looks random to me but maybe it's not.

Cheers!
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: charles99 on February 19, 2012, 20:39:39 PM
I have to agree with Art on this...  Especially for new users that don't know how to make changes to their database!     This should have been one of the first thing you guys should have addressed!  Some users are dealing with thousands of products and to think they would have to reassign each product image is enough to make me switch to another program without all the upgrade bombs! 
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: jenkinhill on February 19, 2012, 23:37:40 PM
I thought Milbo made it quite clear that VM2.0.1x are pre-releases for testing which is why they are heavily discussed in http://forum.virtuemart.net/index.php?board=127.0. The release version for general use will be 2.0.2 

Problem is that VM2.0.1 is currently the only version to use with J2.5.1 and feedback is needed from many different setups so issues can be addressed. For example on the 5 test sites I have updated from 2.0 to one of the 2.0.1 releases I have not had a problem with images, so would not have reported it to the devs. But hearing that some have had this problem means that they are aware.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: charles99 on February 20, 2012, 05:18:30 AM
No it wasn't made clear! 

Here's a problem that everyone seem to be reporting images not loading right after upgrading to 2.0.1 A to K...   And every time you find a fix the next update mess's everything up! 




[attachment cleanup by admin]
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: texhead on March 01, 2012, 05:23:29 AM
I upgraded from 2.0.0 to 2.0.2 today and the disappearing images issue is still with us.
Thanks for the sql, I needed that!
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: jenkinhill on March 01, 2012, 10:23:41 AM
I do all updates by using Joomla's extension manager, no problems there with unpublishing files.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: scarrott on March 02, 2012, 13:59:41 PM
Same problem for me. I've republished all my images but now the main image is displaying far to big (it used to be resized to fit the left column of the product details pages) and all the additional images are missing (the thumbnail for the main image is the only one showing) despite the fact that they are all set to publish.

Starting to wish i'd never touched VM2.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: jenkinhill on March 02, 2012, 17:50:29 PM
To resize the main product details image - in the FAQs:  http://forum.virtuemart.net/index.php?topic=98647.0
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: Milbo on March 03, 2012, 19:55:54 PM
Quote from: Art_Koenig on February 09, 2012, 01:37:52 AM
VM team, please take care of this issue when we upgrade from a previous 2.0.0 version. I must add not 100% of my media were unpublished so I really don't know on which criteria some media became unpublished during the upgrade ... It looks random to me but maybe it's not.

It was far more tricky. Medias are set in the constructor as unpublished (=0) ? Then I add a check for security, when it gets stored. The reason here is the upcoming multivendor stuff. But something went wrong and it was suddenly always stored as unpublished. BUT we didnt noticed this, because the unpublishing feature itself was broken. So also unpublished medias were shown. As I fixed this (I think January or so) I had the dilemma what todo now. I decided to not auto publish them, because people could have set this on purpose. Looking back, I think I should have do this, or at least provide a tool for it.

Quote from: charles99 on February 19, 2012, 20:39:39 PM
.... and to think they would have to reassign each product image is enough to make me switch to another program without all the upgrade bombs! 

I am not aware of that there is a problem with reassigning them. Other method pure gui based is to use the media view and use the publishing option in the list.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: RFreund on March 12, 2012, 02:43:12 AM
What table did you have to run the sql command on?

I have the same problem when upgrading to VM 2.0.3b
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: airquee1 on March 21, 2012, 19:57:53 PM
I have had the same problem with the upgrade to 2.0.2.
I have over 1000 products, I cannot possibly go into each one individually and change them all but I am new to this and have no idea about the commands that are talked about in previous posts. Can someone help with a step by step of how to re-publish all 1000+ images.

If I'd known this was going to happen I would never have updated.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: ale_turbo on March 23, 2012, 10:54:36 AM
Hi,
I'm new to VM and I'm developing a site with Joomla 2.5.2 and VM2.0.2 !
Since I didn't upgrade from an old version, I'm not facing the same problem you mention, but a very similar issue.
If I create a category and insert a category image, the image is correctly shown... but when I create a product and insert an image on that product, I cannot see any image!!
I tried to unpublish and republish the image, but without success. I tried to resize the image... nothing!
I can only see the thumb Product: Image unavailable.

Any ideas?

Thank you!
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: MissyW on March 26, 2012, 05:31:03 AM
I had the same problem when upgrading from VM 2.0 to VM 2.0.2
Quote from: RFreund on March 12, 2012, 02:43:12 AM
What table did you have to run the sql command on?

I have the same problem when upgrading to VM 2.0.3b
With earlier releases of Joomla, the prefix for all tables was "jos_".  With the recent releases of Joomla, you can specify the table prefix or accept a default when you install Joomla.  Look for a table that has the same prefix as all your other tables and ends with "_virtuemart_medias".   In the sql command given, replace "jos_" with your prefix.
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: kimbukhari on May 08, 2012, 22:44:47 PM
Dear Technical Guys,

I am new to Joomla and VM but sorted out most of my problems as per your posted solutions. Now the new (may be) problem what i have face here after upgrading VM 2.0.0 to 2.0.1 that my product prices are not including in my cart. What to do for it?

Regards,

Kim
Title: Re: Upgrade to 2.0.1e - product image disappeared
Post by: kimbukhari on May 08, 2012, 22:46:43 PM
Dear Technical Guys,

In connection to my post, please note that the selected product is not added into the cart which creates this whole scenario.

Regards,

Kim