Skip to main content

No product image

3 years 3 months ago #353427 by Dnsftl
No product image was created by Dnsftl
-- 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

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

3 years 3 months ago - 3 years 3 months ago #353430 by Philip
Replied by Philip on topic No product image
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: 3 years 3 months ago by Philip.

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

3 years 3 months ago #353457 by Dnsftl
Replied by Dnsftl on topic No product image
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.

3 years 3 months ago - 3 years 3 months ago #353459 by nicolas
Replied by nicolas on topic No product image
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:
Code:
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: 3 years 3 months ago by nicolas.

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

3 years 3 months ago #353482 by Dnsftl
Replied by Dnsftl on topic No product image
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.

3 years 3 months ago #353488 by nicolas
Replied by nicolas on topic No product image
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.

3 years 3 months ago #353498 by Dnsftl
Replied by Dnsftl on topic No product image
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.

3 years 3 months ago - 3 years 3 months ago #353501 by nicolas
Replied by nicolas on topic No product image
Hi,

Well, it's the one I posted, with #__ replaced by your table prefix :
Code:
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: 3 years 3 months ago by nicolas.

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

3 years 3 months ago #353511 by Dnsftl
Replied by Dnsftl on topic No product image
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

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

3 years 3 months ago #353529 by nicolas
Replied by nicolas on topic No product image
Hi,

There was a typo in my MySQL query. I had written UPATE instead of UPDATE. The query should be:
Code:
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.

3 years 3 months ago #353537 by Dnsftl
Replied by Dnsftl on topic No product image
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.118 seconds
Powered by Kunena Forum