Error trying to browse the control panel - 1064 my

Start
Prev
1
Next
End

ila.qs.ad
Topic Author
Offline

Posts: 7
Thank you received: 0

9 years 11 months ago #215000

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.4
-- PHP version -- : 5.6.12-0+deb8u1
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM r6ct_hikashop_order AS a LEFT JOIN r6ct_hikashop_user AS b ON a.order_user_' at line 1 SQL=SELECT b.*, FROM r6ct_hikashop_order AS a LEFT JOIN r6ct_hikashop_user AS b ON a.order_user_id=b.user_id WHERE a.order_type='sale' AND a.order_created > 1438387200 AND a.order_created

Hello I was working on configuration in the control panel and an error appears.
I can't see the control panel and some other function. It seams an error in mysql database but I'm not able to modify or understand wher is the problem.

Tks for your help!

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

Jerome
Offline
HikaShop core developer

Posts: 26266
Thank you received: 4044
MODERATOR

9 years 11 months ago #215003

Hi,

I think that you have a widget with an "incorrect" configuration.
Even if you can't display the dashboard you should be able to display the widget listing and unpublish (or delete) the widget with the issue.

/administrator/index.php?option=com_hikashop&ctrl=report

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.