1052 column 'product_id' in where clause is ambiguous

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,

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,

Great. Edit the file components/com_hikashop/views/product/view.html.php and change the line:

$filters[] = 'product_id = 0';

$filters[] = 'b.product_id = 0';

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.

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.

if(!$matchingDiscount) {
	$filters[] = 'product_id = 0';
}

if(!$matchingDiscount) {
	$filters[] = 'b.product_id = 0';
}