Error 1054 (can't access Hikashop main CP)

-- HikaShop version -- : 2.6.0.20
-- Joomla version -- : 3.4.6
-- PHP version -- : 5.4.43
-- Browser(s) name and version -- : All
-- Error-message(debug-mod must be tuned on) -- : 1054 - Er heeft zich een fout voorgedaan.

Unknown column 'cat.category_id' in 'where clause' SQL=SELECT *, COUNT(a.user_id) AS total FROM j17_hikashop_user AS a LEFT JOIN j17_hikashop_order AS o ON a.user_id=o.order_user_id LEFT JOIN j17_hikashop_address AS b ON a.user_id=b.address_user_id LEFT JOIN j17_hikashop_zone AS z ON b.address_country=z.zone_namekey WHERE a.user_partner_activated=0 AND cat.category_id IN ('67') AND a.user_created > 1420070400 AND a.user_created execute() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/index.php:47
2 JApplicationAdministrator->doExecute() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/cms/application/cms.php:252
3 JApplicationAdministrator->dispatch() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/cms/application/administrator.php:152
4 JComponentHelper::renderComponent() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/cms/application/administrator.php:98
5 JComponentHelper::executeComponent() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/cms/component/helper.php:372
6 require_once() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/cms/component/helper.php:392
7 hikashopController->execute() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/hikashop.php:54
8 JControllerLegacy->execute() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/helpers/helper.php:1601
9 hikashopController->listing() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/legacy/controller/legacy.php:728
10 hikashopController->display() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/helpers/helper.php:1356
11 JControllerLegacy->display() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/helpers/helper.php:1621
12 dashboardViewDashboard->display() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/legacy/controller/legacy.php:690
13 dashboardViewDashboard->listing() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/views/dashboard/view.html.php:16
14 dashboardViewDashboard->widgets() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/views/dashboard/view.html.php:22
15 hikashopWidgetClass->data() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/views/dashboard/view.html.php:83
16 JDatabaseDriver->loadObjectList() /home/xxxi/xxxx/aba-i.nl/public_html/administrator/components/com_hikashop/classes/widget.php:1234
17 JDatabaseDriverMysqli->execute() /home/xxxi/xxxx/aba-i.nl/public_html/libraries/joomla/database/driver.php:1318

I suddenly when I choose Hikashop in backend get that message. What's wrong.

Hikashop is working on frontedn and if I choose other menu (so not directly Hikashop) in backend but f.e. Hikashop > Products than CP is working.

How can I solve this.

I already deleted caches, browser cache's, run an update etc.

EDIT
I also see that the last 305 clients have not fild in Name Surname fields. But they do and must on form. !!!! Alle empty
It seems that BEFORE APRIL 19Th all new clients are in Joomla users with name etc, but form April 19th all new clienst have no name in Hikashop and are NOT added to Joomla users.

Hi,

I think that your issue is related on the widgets displayed on the dashboard.
Could you give us a screenshot of the settings of the used widgets ? That way we will be able to reproduce the issue on our end and fix it.

Could you try to edit the file "administrator/components/hikashop/classes/widget.php" and in the function "loadDatas()" replace the line:

$db->setQuery('SELECT * FROM '.hikashop_table('category').' WHERE category_id IN ('.implode(',',$this->categories).')');

$db->setQuery('SELECT * FROM '.hikashop_table('category').' AS cat WHERE category_id IN ('.implode(',',$this->categories).')');

Hi,

Thanks for your response.

For the error message, I changed the widget.php but no change.
I can't show you widget settings because the ONLY page I get this error is the main dashboard, so I can't enter that and see the settings.
Or can I reset the widget settings somewhere else?

SO what to do now? I can give you login info so you can check.

Second problem (users) is solved, that was a changed setting (who changed that I don't know, probably an error by client.)

Jerome,

You'v made my day, brillant.

I switched them off one by one and it was a MAP widget. Don't know what that showed but the CP is working again.
Thanks a lot, really really happy

Lately there was a J 3.4.6 update and I upgraded the site to your business edition. Maybe something went wrong there.

Anyhow, I can go on.

Great support !