[Skip to main content](#vessel-content) # \[SOLVED\] Menu item "Vendor listing" leads to error page -> Unknown column ## - **[liaskas](/forum/user/59465-liaskas "View liaskas's Profile")** - [![liaskas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/59465-liaskas "View liaskas's Profile") Topic Author - [ Offline](/forum/user/59465-liaskas) Less More - Posts: 205 - Thank you received: 12 - - 6 years 5 months ago - 6 years 5 months ago [\#319008](#319008) by [liaskas](/forum/user/59465-liaskas "View liaskas's Profile") *[Menu item "Vendor listing" leads to error page -> Unknown column](/forum/19-hikamarket/899836-solved-menu-item-vendor-listing-leads-to-error-page-unknown-column#319008 "-- HikaShop version -- : 4.3.0 -- HikaMarket version -- : 3.0.3 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.2.30 Menu item "Vendor listing" leads to error page [Vendors (Alias: vendors) HikaMarket » Vendors listing] 1054 Unknown column 'vendor.accepted_cities' in 'where clause' SELECT vendor.* FROM xxx_hikamarket_vendor AS vendor WHERE (vendor_published = 1) AND ((vendor.`accepted_cities` IS NULL OR vendor.`accepted_cities` = '' OR vendor.`accepted_cities` = '*')) ORDER BY vendor.vendor_id ASC LIMIT 0, 21 Please give us solution!")* was created by *[liaskas](/forum/user/59465-liaskas "View liaskas's Profile")* -- HikaShop version -- : 4.3.0 -- HikaMarket version -- : 3.0.3 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.2.30 Menu item "Vendor listing" leads to error page [Vendors (Alias: vendors) HikaMarket » Vendors listing] **1054** Unknown column 'vendor.accepted_cities' in 'where clause' SELECT vendor.* FROM xxx_hikamarket_vendor AS vendor WHERE (vendor_published = 1) AND ((vendor.`accepted_cities` IS NULL OR vendor.`accepted_cities` = '' OR vendor.`accepted_cities` = '*')) ORDER BY vendor.vendor_id ASC LIMIT 0, 21 Please give us solution! Last edit: 6 years 5 months ago by [liaskas](/forum/user/59465-liaskas "View liaskas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE5LWhpa2FtYXJrZXQvODk5ODM2LXNvbHZlZC1tZW51LWl0ZW0tdmVuZG9yLWxpc3RpbmctbGVhZHMtdG8tZXJyb3ItcGFnZS11bmtub3duLWNvbHVtbj90bXBsPW1hcmtkb3du) 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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 5 months ago [\#319011](#319011) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Menu item "Vendor listing" leads to error page -> Unknown column](/forum/19-hikamarket/899836-solved-menu-item-vendor-listing-leads-to-error-page-unknown-column#319011 "-- HikaShop version -- : 4.3.0 -- HikaMarket version -- : 3.0.3 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.2.30 Menu item "Vendor listing" leads to error page [Vendors (Alias: vendors) HikaMarket » Vendors listing] 1054 Unknown column 'vendor.accepted_cities' in 'where clause' SELECT vendor.* FROM xxx_hikamarket_vendor AS vendor WHERE (vendor_published = 1) AND ((vendor.`accepted_cities` IS NULL OR vendor.`accepted_cities` = '' OR vendor.`accepted_cities` = '*')) ORDER BY vendor.vendor_id ASC LIMIT 0, 21 Please give us solution!")* [ www.hikashop.com/forum/22-market-bug-rep...e-clause.html#293566](https://www.hikashop.com/forum/22-market-bug-report/894903-unknown-column-hikam-vendor-accepted-cities-in-where-clause.html#293566) --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [liaskas](/forum/user/59465-liaskas "View liaskas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE5LWhpa2FtYXJrZXQvODk5ODM2LXNvbHZlZC1tZW51LWl0ZW0tdmVuZG9yLWxpc3RpbmctbGVhZHMtdG8tZXJyb3ItcGFnZS11bmtub3duLWNvbHVtbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[liaskas](/forum/user/59465-liaskas "View liaskas's Profile")** - [![liaskas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/59465-liaskas "View liaskas's Profile") Topic Author - [ Offline](/forum/user/59465-liaskas) Less More - Posts: 205 - Thank you received: 12 - - 6 years 5 months ago [\#319034](#319034) by [liaskas](/forum/user/59465-liaskas "View liaskas's Profile") Replied by *[liaskas](/forum/user/59465-liaskas "View liaskas's Profile")* on topic *[\[SOLVED\] Menu item "Vendor listing" leads to error page -> Unknown column](/forum/19-hikamarket/899836-solved-menu-item-vendor-listing-leads-to-error-page-unknown-column#319034 "-- HikaShop version -- : 4.3.0 -- HikaMarket version -- : 3.0.3 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.2.30 Menu item "Vendor listing" leads to error page [Vendors (Alias: vendors) HikaMarket » Vendors listing] 1054 Unknown column 'vendor.accepted_cities' in 'where clause' SELECT vendor.* FROM xxx_hikamarket_vendor AS vendor WHERE (vendor_published = 1) AND ((vendor.`accepted_cities` IS NULL OR vendor.`accepted_cities` = '' OR vendor.`accepted_cities` = '*')) ORDER BY vendor.vendor_id ASC LIMIT 0, 21 Please give us solution!")* Perfect... Yes... it is solved by unpublishing plugin "HikaMarket Vendor User Location Filter" and "HikaShop Vendor User Location Filter". Thank you Jerome. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE5LWhpa2FtYXJrZXQvODk5ODM2LXNvbHZlZC1tZW51LWl0ZW0tdmVuZG9yLWxpc3RpbmctbGVhZHMtdG8tZXJyb3ItcGFnZS11bmtub3duLWNvbHVtbj90bXBsPW1hcmtkb3du) 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? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.144 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)