1140 Error backend when clicking on hikashop in components menu

kjeldbagh
Topic Author
Offline

8 years 10 months ago #283332 by kjeldbagh

1140 Error backend when clicking on hikashop in components menu was created by kjeldbagh

-- 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

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

Jerome
Offline
HikaShop core developer

8 years 10 months ago #283358 by Jerome

Replied by Jerome on topic 1140 Error backend when clicking on hikashop in components menu

Hello,

You should see to edit temporally the Joomla core file to have more information regarding the processed query.
www.hikashop.com/forum/install-update/89...-version.html#277684

Unfortunately, without knowing what is the processed query ; it will be difficult to fix it (since we cannot reproduce it in our end)

Regards,

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

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

kjeldbagh
Topic Author
Offline

8 years 10 months ago #283368 by kjeldbagh

Replied by kjeldbagh on topic 1140 Error backend when clicking on hikashop in components menu

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))

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

nicolas
Away

8 years 10 months ago #283380 by nicolas

Replied by nicolas on topic 1140 Error backend when clicking on hikashop in components menu

Hi,

I think that it's either because you're using an old version of MySQL or that you have the ONLY_FULL_GROUP_BY setting of MySQL activated:
dev.mysql.com/doc/refman/5.7/en/sql-mode...e_only_full_group_by

Add the code:

Code:

,'group' => 'hk_order.order_id'

after the code:

Code:

'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})'),
				)

in the file administrator/components/com_hikashop/classes/statistics.php and that should fix the problem.

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

kjeldbagh
Topic Author
Offline

8 years 10 months ago - 8 years 10 months ago #283458 by kjeldbagh

Replied by kjeldbagh on topic 1140 Error backend when clicking on hikashop in components menu

Hi,

Tx again.

I put the code in like this:

Code:

				'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'

Still the same error :-(

Im also looking into an SQL update.

Last edit: 8 years 10 months ago by Jerome. Reason: [code] is nice !

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

kjeldbagh
Topic Author
Offline

8 years 10 months ago #283483 by kjeldbagh

Replied by kjeldbagh on topic 1140 Error backend when clicking on hikashop in components menu

SQL update solved the problem together with the above.

Thanks for the great help.

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

Time to create page: 0.265 seconds