Categories
View Replies (12)

Resolved Product Images not published.

  1. shimon
    shimon
  2. RO CSVI
  3. Tuesday, 24 May 2016
  4.  Subscribe via email
I have been having a problem with images not displaying after a product import, even though the images were in the images/stories/virtuemart/product/ directory.

The template that I used was my PFS Product Import.

After a great deal of research I found that the problem is that when a new record in the jos_virtuemart_medias is created the "published" field is set to 0. This causes VM not to display the image or the thumbnail.

If I edit the database and set jos_virtuemart_medias.published = 1, the image displays,
I was testing with an image that became virtuemarr_media_id - 21089 (OH-TR-1.jpg)

I assume that I have set something incorrectly in the template or in the settings.

I have attached the debug log. I looked at it and in step 226 the update query sets it to published = 0 ( even though the many other queries up until then always had it published =1.

I believe that this is because more than one product use this image. The last product that uses this image is not published, all the previous products are published. CSVI is setting the status of this media based on the last product's status.

How do I fix this?
0
Responses (12)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Shimon,
I assume that I have set something incorrectly in the template or in the settings.

There is no setting in template for this, so you are good here.

I believe that this is because more than one product use this image. The last product that uses this image is not published, all the previous products are published. CSVI is setting the status of this media based on the last product's status.

Yes, you're correct. Product published status is used for media status and so you are seeing this issue.

How do I fix this?

To solve this, we have added a new available field media_published so the media status is independent of product published status field. Please apply the attached patch file, update your available fields and include media_published field in your import file. Try the import and let me know how it goes.


patch_vm_media_status_2016-05-25.zip
Attachments (1)
patch_vm_media_status_2016-05-25.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Shimon,
Did you try the attached patch? Please let us know if it has helped in solving you issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
dagoberto
dagoberto
Accepted Answer Pending Moderation
I tried it using CSVI Pro Version: 6.5.7 and it didn't work for me :pinch:

product_sku,file_title,file_url,media_published

I've uploaded my log file as I've read all the image posts and can't find a solution...
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I tried it using CSVI Pro Version: 6.5.7 and it didn't work for me :pinch:

We have included this feature in CSVI 6.6.0 version but latest version is CSVI 6.6.4 version. I would suggest to update to latest and see if it solves the issue.

I've uploaded my log file as I've read all the image posts and can't find a solution...

The log file is missing in your post. If its a big file, try to compress and post it.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
dagoberto
dagoberto
Accepted Answer Pending Moderation
I've just forked out 10 quid to find out I need to upgrade :(

And the price has gone up 30 quid from last year :sick:
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The price has not gone up for many years, this year we did increase the price with 10 euro and not 30 as you pointed out. Don't know where you get that number from.

As for publishing images, you can use the published field, which is used for both products and media in your version. Otherwise you can use the media import to publish your media items.

In case you do decide to get a full subscription, the price for the forum access will be applied as a discount.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
dagoberto
dagoberto
Accepted Answer Pending Moderation
Me either, sorry about that.

Thank you Rolandd
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
No worries, thank you for your subscription. With the Brexit, the pound has plummeted, perhaps that made it look like it :)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
dagoberto
dagoberto
Accepted Answer Pending Moderation
Mmmh! I'm stuck still with images not being found. I've tripled checked all settings including correct chown and permissions on images and folders. Uninstalled CSVI, reloaded, updated fields, cleared cache etc etc....

Please help, log attached.

Regards
Jamie
Attachments (1)
com_csvi.log.23.txt.zip
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Jamie,
Seems like you dont have the product images in the given path. Your debug log says that the images cannot be found, an example from your debug log "The file /home/oakfurniturecapi/public_html/images/stories/virtuemart/product/CO2111-1.jpg has not been found.". You need to have these images in the product folder first and then do the import. Try it and let me know how it goes.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
dagoberto
dagoberto
Accepted Answer Pending Moderation
Two days and €83.94 to figure out that the images use hyphens when my upload file uses underscores doh!

Can I have that support purchase refunded please?
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
Well you needed help I guess to figure that out ;)

As for a refund, you have already been given the support purchase as a discount on your subscription. To explain, the support purchase was 9.99 excluding tax and 11.99 including tax. The subscription price was 69.95 excluding tax and 83.94 including tax. That is without any discount, so you would have paid a total of 95.93 however we have deducted the 9.99 from the 69.95 which leaves a total of 59.96 excluding tax and 71.95 including tax. Combine the 71.95 and the 11.99 and you paid 83.94 including tax. The same it would be as if you did not purchase a support ticket.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!