Category images not showing

  • Posts: 23
  • Thank you received: 2
  • Hikashop Business
3 years 6 months ago #323727

-- url of the page with the problem -- : testsitepro4.biz/index.php/book-categories2
-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.0.33
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : -

I have read the previous posts going back as far as 2015 relating to category images not showing. Can I get you to look at my dev site to shine some light on what is going wrong please. The data was imported from an OpenCart site.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 6 months ago #323732

Hi,

Well, first, when you edit a category in the backend, do you see a image listed in the image setting ?
- If you don't see anything, then it means that the images have not been imported for the categories. You would have to add them manually.
- If you see an image, and it's actually the default image configured in the HikaShop configuration, then it means that the image has been attached to the category but that the system can't find the corresponding file in the images/com_hikashop/upload/ folder. That means that the image files of the categories couldn't be copied during the migration. In that case, you can download the category images from where they are stored in your OpenCart and upload them to the images/com_hikashop/upload/ folder via FTP and the images should then appear on the listing.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
  • Hikashop Business
3 years 6 months ago #323764

Thankyou Nicolas
I agree with your suggestions and actually that was what we did when we migrated the files.

Then we noticed the category image issue. To test the site we made a new manual category just two days ago [Test V2] and same behaviour, upload image file, save, no image.In the database and upload folder the image is getting uploaded correctly.

So we are still requiring your assistance.

Last edit: 3 years 6 months ago by probiz.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 6 months ago #323804

Hi,

Then I would need a backend access to check on the situation.
Could you provide that along with a link to this thread via our contact form ?
www.hikashop.com/support/contact-us.html

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 6 months ago #323856

Hi,

Thanks for the access. We're moving forward.
From what I could see, the issue is that the entry in the hikashop_file table disappears after it has been added to it.
However, I'm not able to reproduce the problem on my local test website.
I thought it could come from a plugin implementing the trigger onAfterFileCreate which would delete the entry wrongfully, but I couldn't find any plugin on your website which could do that.
So I'll need a FTP access to be able to edit the files and add some debugging to the process to check the situation.
Ideally, an access to PHPMyAdmin to check the situation in the database would be great too if you can provide it.
You can provide them via our contact form, like you did for the backend access.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
  • Hikashop Business
3 years 6 months ago #323935

I have done this Nicolas.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 6 months ago #323945

Hi,

Thanks. I got the access and checked that everything is ok in the code.
The issue seems to be at the MySQL level. Because HikaShop asks MySQL to add the entry in the database, and it gets back the id of the file, but then that entry is missing in the database.
Would it be possible to also get a PHPMyAdmin access to check the structure of the hikashop_file table and check the situation after an image is selected/uploaded for a category ?

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
  • Hikashop Business
3 years 6 months ago #323954

Thankyou for looking Nicolas. The info I gave you 2 days ago gives you access to cPanel for this site from which you can click thru to phpMyAdmin.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
  • Hikashop Business
3 years 6 months ago #324014

I have sent cPanel info to do this thru Contact Us.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 6 months ago #324036

Hi,

I checked your database and found the issue.
The size of the columns has been modified for all your tables.
I suppose to try to optimize the space used by the data and reduce the size of the database.
Unfortunately, the size of the column "file_type" in the hikashop_file table has been modified to 7 characters.
While that's ok for products as the text "product" is 7 characters, the text "category" is 8 characters. And thus MySQL is automatically trimming it to 7 characters when adding the entry in the database:
monosnap.com/file/hCY5mfp5m49qOTgv0HPA1n1EECSnn7
And then, when HikaShop tries to load the image for the category, it doesn't find any entry with the file_type equal to "category".

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
  • Hikashop Business
3 years 6 months ago #324051

The issue has been fixed. Thankyou very much for your assistance Nicolas. It is extremely valuable to be able to ask and get expert Hikashop advice which is why it is our favoured e-comm component.

Last edit: 3 years 6 months ago by probiz.

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 1
  • Hikashop Business
3 years 5 months ago #324507

Hi there,

After updating Joomla to 3.9.21 my category images are not shown anymore? Today updated to 3.9.22 but still the same..

Currently running:
Joomla 3.9.22
Hikashop Business 4.3.0
PHP 7.4.10

Is this a known issue or, if not, can someone please advice me?

Thanks!

Last edit: 3 years 5 months ago by ebordes.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 5 months ago #324516

Hi,

It's not a known issue.
Wouldn't the problem be that you reverted the change I made in the hikashop_file table (for example with a backup / restore or something, or with the tool you use to reduce the size of the columns in the tables of the database)?

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 1
  • Hikashop Business
3 years 5 months ago #324546

Hi Nicolas,

No, there was nothing restored, just a Joomla update. I've allready checked the dBase and this 7 digit character issue is not there.....any suggestions?

Thanks!

Attachments:
Last edit: 3 years 5 months ago by ebordes.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 5 months ago #324564

Hi,

I do see the images for your categories on your website:
monosnap.com/file/7TfIdBranM8KnWr5gRdYY9UM85Nvzr
Could you provide more specific information of what doesn't work where ?

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 1
  • Hikashop Business
3 years 5 months ago #324577

nicolas wrote: Hi,

I do see the images for your categories on your website:
monosnap.com/file/7TfIdBranM8KnWr5gRdYY9UM85Nvzr
Could you provide more specific information of what doesn't work where ?


Hi Nicolas,

This is a reply to my question? The imagelink is not my site?

Last edit: 3 years 5 months ago by ebordes.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 5 months ago #324591

Hi,

Sorry, I thought you were the same person who started this thread.
But then, I would first need a link to the page with the issue on your end to be able to analyze the situation.

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 1
  • Hikashop Business
3 years 5 months ago #324632

Hi Nicolas,

No problem, I just was confused by this screendump.....

I've installed a backup running Joomla 3.9.20 and then the category overview looks like Image 1.



After updating to Joomla 3.9.21 or 3.9.22 the images don't show anymore(image 2)?


What info do you need to tackle this issue?

Thanks!

Kind regards, Eddy

Attachments:
Last edit: 3 years 5 months ago by ebordes.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
3 years 5 months ago #324646

Hi,

As I said in my previous message, a link to the page would have been great.
However, looking at your screenshots, it seems that you issue comes from the settings of your menu item.
Edit it via the Joomla menu manager and under the "products options" tab at the top of the tab content, make sure that "DIV / Grid" is selected instead of "list" and that should help.

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 1
  • Hikashop Business
3 years 5 months ago #324744

Got it!



Thanks!

Last edit: 3 years 5 months ago by ebordes.
The following user(s) said Thank You: Philip

Please Log in or Create an account to join the conversation.

Time to create page: 0.111 seconds
Powered by Kunena Forum