Error 1054 Unknown column 'pr.product_related_quantity' in 'field list'

  • Posts: 235
  • Thank you received: 4
6 years 2 months ago #285941

-- url of the page with the problem -- : www.car-and-tuning.nl/shop/checkout/confirm/cart_id-25565
-- HikaShop version -- : 3.2.2
-- Joomla version -- : 3.8.3
-- PHP version -- : 7
-- Browser(s) name and version -- : -
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'pr.product_related_quantity' in 'field list'

After update to 3.2.2 I get this error on completion of the order:

Error 1054 Unknown column 'pr.product_related_quantity' in 'field list'

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

  • Posts: 25990
  • Thank you received: 4003
  • MODERATOR
6 years 2 months ago #285942

Hello,

You should perform a "check database" in your HikaShop configuration.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 235
  • Thank you received: 4
6 years 2 months ago #286021

Jerome,

I tried yesterday and also today.
I asked the hosting provider to give the site 'unlimited resources', but even then the database repair results in a overload of the server.

If I sent you database-credentials, can you fix it?


Jan



WEBSITE TEMPORARY UNAVAILABLE
The website you're trying to visit is unavailable, because exceeds its allotted resource capacity. The cause may be that there are too many active visitors, or the website might be experiencing a technical defect.

In most cases this is a temporary problem, so please try again later. We thank you for your patience and understanding. Is this your website? Please contact us at This email address is being protected from spambots. You need JavaScript enabled to view it.

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

  • Posts: 235
  • Thank you received: 4
6 years 2 months ago #286027

I've this log from the provider

===
[Tue Jan 16 15:37:10.641975 2018] [lsapi:error] [pid 386721:tid 140530042623744] [client 83.82.176.182:54595] [host www.car-and-tuning.nl ] Backend error on sending request(POST /administrator/index.php?option=com_hikashop&ctrl=config HTTP/2.0); uri(/administrator/index.php?option=com_hikashop&ctrl=config) content-length(14244) (lsphp is killed?): ReceiveAckHdr: nothing to read from backend socket, referer: www.car-and-tuning.nl/administrator/inde...hikashop&ctrl=config
===

I trie3d this in the htaccess without any result
php_value max_execution_time 300

Jan

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

  • Posts: 235
  • Thank you received: 4
6 years 2 months ago #286028

Even with this no result:

php_value max_execution_time 600

Jan

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

  • Posts: 81289
  • Thank you received: 13023
  • MODERATOR
6 years 2 months ago #286023

Hi,

Well you can edit the table hikashop_product_related via your phpmyadmin and add the column product_related_quantity as an "INT" and it will fix that error.
But you might have other errors after that.

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

  • Posts: 235
  • Thank you received: 4
6 years 2 months ago #286126

Thanks a lot! This was the solution.

It works!

Jan

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

Time to create page: 0.067 seconds
Powered by Kunena Forum