1054 Unknown column 'b.product_volume' in 'field list'

Hi,

This error indicates a MySQL query error. However, it doesn't mean that there is a problem with the tables in the database.
Most likely, the issue is with how something was setup which we didn't account for.
We'll need more information from you to be able to understand the problem.
First, please provide your Joomla and HikaShop versions.
Then, please try to reproduce the issue with the "error reporting" and "debug mode" settings of the Joomla configuration activated. That should give an error message with more information.
Finally, please provide a link to the shop and precise instructions to reproduce the problem.

Hi,

From what I can see in your screenshot, the error comes from a filter you have.
So log on your backend, go in the menu Display>Filters of HikaShop and disable the filters one by one until you identify the one with the issue. Keep it unpublished to fix the problem on your website and provide a screenshot of it's settings so that we can try to reproduce the issue on our end and add a patch for it.

Hi,

I'm not sure why it would do that.
How is configured the "dynamic display" setting of the filter ? It's outside of your screenshot.
Could also do that modification and reproduce the problem:
www.hikashop.com/support/forum/2-general...ror-1054.html#287524
Then, provide the full MySQL query that you get. That would help us better understand the situation.

Hello,

"provide the full MySQL query
You must guide me"

You said that when you let empty input categories the error arise, can you simply copy/paste or screenshot it like my example :

Hi,

We need the MySQL query to be able to help.
Please edit the file /libraries/joomla/database/exception/executing.php
and change the line:
parent::__construct($message, $code, $previous);
by:
parent::__construct($message.' '.$query, $code, $previous);
You can do that via FTP or the file manager of your hosting. If you don't know how to access them, please ask your hosting company support.
Once that change is done, access the page with the issue again and you'll see the MySQL query along with the error message. Please provide it.

Hi,

Thank you for that.
Please try changing the code:

		if($filter->filter_data=='information')
			return 'b.product_'.$filter->filter_options['product_information'];

		if($filter->filter_data=='information') {
			if($filter->filter_options['product_information']=='surface')
				return 'b.product_width*b.product_length';
			if($filter->filter_options['product_information']=='volume')
				return 'b.product_width*b.product_length*b.product_height';
			return 'b.product_'.$filter->filter_options['product_information'];
		}

Hi,

The "price" choices use the prices that you set in the products and dynamically retrieve them. So it can take into account price restrictions like user group, dates, etc. However, it's quite taxing on the database as it complexify the query to load the products quite a lot.
The "sort price" choices use the "product_sort_price" column of the products for the sorting. That column is filled by HikaShop automatically when you save the product or its variants in the backend interface. It only take into account unit prices of the main currency. Since the value is precalculated, it doesn't add any complexity to the query to load the products on the frontend. On top of that, it also allows you to set the value to whatever you want via the database, mass actions, or CSV import.

So both options can be useful based on your needs.

Regarding the text of the sort price sorting, you can use translation overrides:
www.hikashop.com/forum/filters-search/89...t/309141.html#309147