1052 column 'product_id' in where clause is ambiguous

-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне
-- HikaShop version -- : 3.2.2
-- Joomla version -- : 3.8.3
-- PHP version -- : 7.0
-- Browser(s) name and version -- : Google Chrome 63.0.3239.132
-- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS

After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared.
How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...

Hello,

Please activate temporally the Joomla debug mode in order to have the call stack.
The full SQL query and the file where that query is generated will be required in order to understand the issue.

Regards,

Hello,

Unfortunately, there is not the full SQL query which would allow us to understand where and what that query is.
Please try to use the default Joomla template and check again your settings for the Joomla debug mode.

Regards,

Same problem here. It has something to do with the HikaShop Content Module. When i disable this module the problem is gone.

This is since i updated from version 3.2.1 to version 3.2.2 any clue?

Hi,

In the file /libraries/joomla/database/exception/executing.php change the line:
parent::__construct($message, $code, $previous);
to:
parent::__construct($message.' '.$query, $code, $previous);
That should provide the full MySQL query which will help understand the problem.

Hi Nicolas this is the Query

Kind regards René

Hi,

Great. Edit the file components/com_hikashop/views/product/view.html.php and change the line: to: That should fix the problem.

Note that you probably want to turn off the "discount only" setting in your products listings menu item/module.
Because this means that you have a listing of products without any products that will display because there are no discounts for the products of the listing.

Hi Nicolas,

I turned off "Discount Only" and that solved the problem.

Kind regards René

Hello,

You have three solutions.
1 - Update to HikaShop 3.3.0 which already contain a patch for that..

2 - Do than renem wrote

I turned off "Discount Only" and that solved the problem.

3 -edit the file "components/com_hikashop/view/product/view.html.php" and replace By
Regards,