1140 Error backend when clicking on hikashop in components menu

-- HikaShop version -- : 3.2.1
-- Joomla version -- : 3.8.2
-- PHP version -- : 5.0.51
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
/home/web1487/www/dindyrlege.com/libraries/joomla/database/driver/mysqli.php:650

Hi,

Getting an error when clicking on Hikashop in the components menu backend.

If I click on any of the submenus, everything is fine.

An ideas?

Regards Kjeld

Tx so much for the quick answer.

This is what I am getting. Perhaps something wrong with the order status?

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SELECT SUM(hk_order.order_full_price) as value, hk_order.order_currency_id as currency FROM c6l9m_hikashop_order AS hk_order WHERE (hk_order.order_type = 'sale') AND (hk_order.order_status IN ('confirmed','shipped')) AND (hk_order.order_invoice_created >= 1509321600 AND (1511999999 <= 0 OR hk_order.order_invoice_created <= 1511999999))

Hi,

Tx again.

I put the code in like this:

				'get' => 'object',
				'select' => array(
					'SUM(hk_order.order_full_price) as value',
					'hk_order.order_currency_id as currency'
				),
				'tables' => hikashop_table('order') . ' AS hk_order ',
				'filters' => array(
					'order_type' => 'hk_order.order_type = '.$order_type.'',
					'order_status' => ('hk_order.order_status IN ('.implode(',', $valid_order_statuses).')'),
					'order_created' => ($created_status ?
						'hk_order.order_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_created <= {DATE_END})':
						'hk_order.order_invoice_created >= {DATE_START} AND ({DATE_END} <= 0 OR hk_order.order_invoice_created <= {DATE_END})'),
				),
				'group' => 'hk_order.order_id'

SQL update solved the problem together with the above.

Thanks for the great help.