Hikashop php 7.1

Start
Prev
1
Next
End

kyratn
Topic Author
Offline

Posts: 1119
Thank you received: 114

7 years 7 months ago #268231

Hi,

Tried to enable php 7.1 and when we try to access hikashop via back-end we get error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 SQL=SELECT COUNT(name) FROM #__users as u LEFT JOIN #__hikashop_user as a ON u.id=a.user_cms_id WHERE

All fine with php 5.6 and 7.0

Thanks

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

Jerome
Offline
HikaShop core developer

Posts: 26158
Thank you received: 4028
MODERATOR

7 years 7 months ago #268234

Hello,

When you have a SQL query ; that's way better to indicate the call stack in order to understand from where the query is generated.
Lucky for you, there is just one place where there is a " COUNT(name) " in the HikaShop code, the widget class.
Please try to change

	if($widget->widget_params->customers=='total_customers'){
		$filters = '';

	if($widget->widget_params->customers=='total_customers'){
		$filters = array();

If the problem persist ; we would need more details about your widget configuration and I would recommend you to deactivate the legacy dashboard in order to use the new HikaShop 3 dashboard ; the widget system is considered as deprecated.

Regards,

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Start
Prev
1
Next
End

Time to create page: 0.053 seconds