No product image

  • Posts: 21
  • Thank you received: 2
  • Hikashop Business
1 year 4 months ago #353427

-- HikaShop version -- : 4.7.4
-- Joomla version -- : 4.3.3
-- PHP version -- : 8.1
-- Browser(s) name and version -- : Firefox 115.0.2 (64-bits)

Hi,

In the backend of hikashop I added product(s) for a customers, now the order only shows our logo instead of the product image, we just can't find how to get the right product image there.

How can we do this?

Regards,

Dennis

Attachments:

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
1 year 4 months ago #353430

Hello,

By default in order form, the product image is the first img (see my screenshot), and so maybe it's because you have set as first image your website logo?

alt


If this is not the case then something escapes us and we are going to need more material, so provide us with these elements :
- An Url link to your backend access
- Backend user references (with maximum Acl)

Awaiting your feedback
Regards

Last edit: 1 year 4 months ago by Philip.

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

  • Posts: 21
  • Thank you received: 2
  • Hikashop Business
1 year 4 months ago #353457

Hi,

In the configuration, our logo was under Images, which has been removed. Made a new order for another customer but still no product images.

Information send

Regards,

Dennis

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 4 months ago #353459

Hi,

This indicates that the product_id column in the hikashop_order_product table has been emptied in your database. So the link between the products in the orders and the products themselves has been lost and thus HikaShop cannot retrieve the images.
To fix that, you would have to run a MySQL query in your PHPMyAdmin:

UPDATE #__hikashop_product as p, #__hikashop_order_product as op SET op.product_id=p.product_id WHERE p.product_name=op.order_product_name
where #__ needs to be replaced by your joomla table prefix.

Last edit: 1 year 4 months ago by nicolas.

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

  • Posts: 21
  • Thank you received: 2
  • Hikashop Business
1 year 4 months ago #353482

Hi Nicolas,

I try to run the SQL query

This message contains confidential information


but I get an error:

This message contains confidential information


Regards,

Dennis

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 4 months ago #353488

Hi,

You made some mistakes in your MySQL query. You swaped the p and op aliases for the tables, but not in the condition, so there is a mismatch.

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

  • Posts: 21
  • Thank you received: 2
  • Hikashop Business
1 year 4 months ago #353498

Hi Nicolas,

Oke, what then is the right one? because I know little about it.

Can you provide the correct MySQL query for me?

Thank you in advance

Regards,

Dennis

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 4 months ago #353501

Hi,

Well, it's the one I posted, with #__ replaced by your table prefix :

UPDATE xmbe8_hikashop_product as p, xmbe8_hikashop_order_product as op SET op.product_id=p.product_id WHERE p.product_name=op.order_product_name

Last edit: 1 year 4 months ago by nicolas.

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

  • Posts: 21
  • Thank you received: 2
  • Hikashop Business
1 year 4 months ago #353511

Hi Nicholas,

Sorry, it must be just me, but I don't understand it, I must be doing it wrong some how, but I get the following error.

This message contains confidential information


Regards,

Dennis

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 4 months ago #353529

Hi,

There was a typo in my MySQL query. I had written UPATE instead of UPDATE. The query should be:

UPDATE xmbe8_hikashop_product as p, xmbe8_hikashop_order_product as op SET op.product_id=p.product_id WHERE p.product_name=op.order_product_name

The following user(s) said Thank You: Dnsftl

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

  • Posts: 21
  • Thank you received: 2
  • Hikashop Business
1 year 4 months ago #353537

Hi Nicholas,

It worked, thanks for the time and help.

Regards,

Dennis

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

Time to create page: 0.076 seconds
Powered by Kunena Forum