[Skip to main content](#vessel-content) # Unknown column 'Array' in 'where clause' ## - **[Gnsbud](/forum/user/37991-gnsbud "View Gnsbud's Profile")** - [![Gnsbud's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37991-gnsbud "View Gnsbud's Profile") Topic Author - [ Offline](/forum/user/37991-gnsbud) Less More - Posts: 42 - Thank you received: 1 - - 11 years 3 months ago [\#209131](#209131) by [Gnsbud](/forum/user/37991-gnsbud "View Gnsbud's Profile") *[Unknown column 'Array' in 'where clause'](/forum/25-install-update/878313-unknown-column-array-in-where-clause#209131 "-- url of the page with the problem -- : localhost -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.12 -- Browser(s) name and version -- : Firefox 37.0.2 -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'Array' in 'where clause' SQL=SELECT * FROM gd_hikashop_category WHERE category_id = Array LIMIT 1 Hi, I just changed few settings in my Hikashop config (can't tell which one for sure, cart flow, some currency info, shop info...) and I got this error: now each time I'm trying to visit Configuration I'm receiving above error. Already tried to install Hikashop over the existing (using Extension Manager), but still error occurs. I removed Hikashop and istalled it again, now it works, but why did this happen?")* was created by *[Gnsbud](/forum/user/37991-gnsbud "View Gnsbud's Profile")* -- url of the page with the problem -- : localhost -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.12 -- Browser(s) name and version -- : Firefox 37.0.2 -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'Array' in 'where clause' SQL=SELECT * FROM gd_hikashop_category WHERE category_id = Array LIMIT 1 Hi, I just changed few settings in my Hikashop config (can't tell which one for sure, cart flow, some currency info, shop info...) and I got this error: Code: Unknown column 'Array' in 'where clause' SQL=SELECT * FROM gd_hikashop_category WHERE category_id = Array LIMIT 1 now each time I'm trying to visit Configuration I'm receiving above error. Already tried to install Hikashop over the existing (using Extension Manager), but still error occurs. I removed Hikashop and istalled it again, now it works, but why did this happen? - [ ![err.png](/forum/attachment/25631) ](/forum/attachment/25631 "err.png") [ ](/forum/attachment/25631?download=1 "err.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODMxMy11bmtub3duLWNvbHVtbi1hcnJheS1pbi13aGVyZS1jbGF1c2U/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14304 - - 11 years 3 months ago [\#209133](#209133) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unknown column 'Array' in 'where clause'](/forum/25-install-update/878313-unknown-column-array-in-where-clause#209133 "-- url of the page with the problem -- : localhost -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.12 -- Browser(s) name and version -- : Firefox 37.0.2 -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'Array' in 'where clause' SQL=SELECT * FROM gd_hikashop_category WHERE category_id = Array LIMIT 1 Hi, I just changed few settings in my Hikashop config (can't tell which one for sure, cart flow, some currency info, shop info...) and I got this error: now each time I'm trying to visit Configuration I'm receiving above error. Already tried to install Hikashop over the existing (using Extension Manager), but still error occurs. I removed Hikashop and istalled it again, now it works, but why did this happen?")* Hi, Hard to say. It could be anything as this is a generic MySQL query to load a category. The 'Array' indicates that something relative to categories was wrong but can't say more. It could be almost anything. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODMxMy11bmtub3duLWNvbHVtbi1hcnJheS1pbi13aGVyZS1jbGF1c2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pouyan](/forum/user/50874-pouyan "View pouyan's Profile")** - [![pouyan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50874-pouyan "View pouyan's Profile") - [ Offline](/forum/user/50874-pouyan) Less More - Posts: 3 - Thank you received: 0 - - 8 years 9 months ago [\#286742](#286742) by [pouyan](/forum/user/50874-pouyan "View pouyan's Profile") Replied by *[pouyan](/forum/user/50874-pouyan "View pouyan's Profile")* on topic *[Unknown column 'Array' in 'where clause'](/forum/25-install-update/878313-unknown-column-array-in-where-clause#286742 "-- url of the page with the problem -- : localhost -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.12 -- Browser(s) name and version -- : Firefox 37.0.2 -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'Array' in 'where clause' SQL=SELECT * FROM gd_hikashop_category WHERE category_id = Array LIMIT 1 Hi, I just changed few settings in my Hikashop config (can't tell which one for sure, cart flow, some currency info, shop info...) and I got this error: now each time I'm trying to visit Configuration I'm receiving above error. Already tried to install Hikashop over the existing (using Extension Manager), but still error occurs. I removed Hikashop and istalled it again, now it works, but why did this happen?")* hi I also have a problem comparing . When I want to compare the two products, I'll go through this error. Unknown column 'Array' in 'where clause'1054 Please guide. hikashop version:_hikashop_business_v3.2.2 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODMxMy11bmtub3duLWNvbHVtbi1hcnJheS1pbi13aGVyZS1jbGF1c2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 8 years 9 months ago [\#286744](#286744) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Unknown column 'Array' in 'where clause'](/forum/25-install-update/878313-unknown-column-array-in-where-clause#286744 "-- url of the page with the problem -- : localhost -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.12 -- Browser(s) name and version -- : Firefox 37.0.2 -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'Array' in 'where clause' SQL=SELECT * FROM gd_hikashop_category WHERE category_id = Array LIMIT 1 Hi, I just changed few settings in my Hikashop config (can't tell which one for sure, cart flow, some currency info, shop info...) and I got this error: now each time I'm trying to visit Configuration I'm receiving above error. Already tried to install Hikashop over the existing (using Extension Manager), but still error occurs. I removed Hikashop and istalled it again, now it works, but why did this happen?")* Hello, You should enable the Joomla debug mode to get the "call stack" and provide us precise indicate of there there issue is. Please understand that there is thousand of queries within HikaShop (about 1600 just for the core) so we need to have more details to investigate properly. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3ODMxMy11bmtub3duLWNvbHVtbi1hcnJheS1pbi13aGVyZS1jbGF1c2U/dG1wbD1tYXJrZG93bg==) 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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)