[Skip to main content](#vessel-content) # HiksShop Dashboard Error ## - **[fullfusion](/forum/user/2962-fullfusion "View fullfusion's Profile")** - [![fullfusion's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2962.png)](/forum/user/2962-fullfusion "View fullfusion's Profile") Topic Author - [ Offline](/forum/user/2962-fullfusion) Less More - Posts: 109 - Thank you received: 2 - - 7 years 2 months ago - 7 years 2 months ago [\#309824](#309824) by [fullfusion](/forum/user/2962-fullfusion "View fullfusion's Profile") *[HiksShop Dashboard Error](/forum/36-reports-statistics/898087-hiksshop-dashboard-error#309824 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'cat_filter.product_category_id' in 'where clause' My client was updating some info she wanted to see in the reports and when she saved the page, she got this error. Unknown column 'cat_filter.product_category_id' in 'where clause' Now if you try to go to the dashboard you get the error. One other place I get the same error is if I am in the HikaShop Configuration and I click the Save & Close or the Close button. The Save button works fine. I haven't found anything else that it is effecting. How do we correct this?")* was created by *[fullfusion](/forum/user/2962-fullfusion "View fullfusion's Profile")* -- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'cat_filter.product_category_id' in 'where clause' My client was updating some info she wanted to see in the reports and when she saved the page, she got this error. Unknown column 'cat_filter.product_category_id' in 'where clause' Now if you try to go to the dashboard you get the error. One other place I get the same error is if I am in the HikaShop Configuration and I click the Save & Close or the Close button. The Save button works fine. I haven't found anything else that it is effecting. How do we correct this? Last edit: 7 years 2 months ago by [fullfusion](/forum/user/2962-fullfusion "View fullfusion's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTgwODctaGlrc3Nob3AtZGFzaGJvYXJkLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86286 - Thank you received: 14263 - - 7 years 2 months ago [\#309839](#309839) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HiksShop Dashboard Error](/forum/36-reports-statistics/898087-hiksshop-dashboard-error#309839 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'cat_filter.product_category_id' in 'where clause' My client was updating some info she wanted to see in the reports and when she saved the page, she got this error. Unknown column 'cat_filter.product_category_id' in 'where clause' Now if you try to go to the dashboard you get the error. One other place I get the same error is if I am in the HikaShop Configuration and I click the Save & Close or the Close button. The Save button works fine. I haven't found anything else that it is effecting. How do we correct this?")* Hi, The "save & close" button of the HikaShop configuration saves the configuration and then directs to the dashboard. So if you have the error on the dashboard, it's normal you get it with that button of the configuration. This error indicates a problem with a MySQL query from a widget configured in the dashboard. There are several things to do: - first, please activate temporarily the "error reporting" and "debug mode" settings of the HikaShop configuration and look at that page again. It should display an error message with more information about the problem which will help us better understand the situation and add a fix for it. - second, do this modification and look at the page again: [ www.hikashop.com/support/forum/product-c...eld-list.html#304882](https://www.hikashop.com/support/forum/product-category-display/897111-1054-unknown-column-b-product-volume-in-field-list.html#304882) That will provide the full MySQL query leading to that error so that we can better understand the situation. - third, as this error comes from a widget, you can go in the Orders>Reports menu and disable the widgets one by one until the dashboard works again in order to identify which widget is creating the error. Then you can live that widget disabled (or delete it) and recreate the widget. Hopefully, you won't get the error or just don't recreate it. - fourth, this error also indicates that you're using the legacy dashboard of HikaShop. You can turn off the "dashboard legacy" setting of the HikaShop configuration to switch to the new dashboard. It doesn't have customization capabilities like the legacy dashboard has, but it will work fine. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTgwODctaGlrc3Nob3AtZGFzaGJvYXJkLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fullfusion](/forum/user/2962-fullfusion "View fullfusion's Profile")** - [![fullfusion's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2962.png)](/forum/user/2962-fullfusion "View fullfusion's Profile") Topic Author - [ Offline](/forum/user/2962-fullfusion) Less More - Posts: 109 - Thank you received: 2 - - 7 years 2 months ago [\#310025](#310025) by [fullfusion](/forum/user/2962-fullfusion "View fullfusion's Profile") Replied by *[fullfusion](/forum/user/2962-fullfusion "View fullfusion's Profile")* on topic *[HiksShop Dashboard Error](/forum/36-reports-statistics/898087-hiksshop-dashboard-error#310025 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'cat_filter.product_category_id' in 'where clause' My client was updating some info she wanted to see in the reports and when she saved the page, she got this error. Unknown column 'cat_filter.product_category_id' in 'where clause' Now if you try to go to the dashboard you get the error. One other place I get the same error is if I am in the HikaShop Configuration and I click the Save & Close or the Close button. The Save button works fine. I haven't found anything else that it is effecting. How do we correct this?")* I did not receive a notification that you had responded. Thanks for the info. I have unpublished the custom widgets that my client had created for the dashboard and discovered which one was the problem. I have suggested that she try to create a new one and see if that will work. I have also informed her that this is the "legacy dashboard" and will be phased out at some point. I will let you know if I need further assistance with this. Thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTgwODctaGlrc3Nob3AtZGFzaGJvYXJkLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.149 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)