- Posts: 205
- Thank you received: 12
[SOLVED] Menu item "Vendor listing" leads to error page -> Unknown column
6 years 4 months ago - 6 years 4 months ago #319008
by liaskas
-- 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!
-- 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 4 months ago by liaskas.
Please Log in or Create an account to join the conversation.
6 years 4 months ago #319011
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Menu item "Vendor listing" leads to error page -> Unknown column
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
The following user(s) said Thank You: liaskas
Please Log in or Create an account to join the conversation.
6 years 4 months ago #319034
by liaskas
Replied by liaskas on topic [SOLVED] Menu item "Vendor listing" leads to error page -> Unknown column
Perfect...
Yes... it is solved by unpublishing plugin "HikaMarket Vendor User Location Filter" and "HikaShop Vendor User Location Filter".
Thank you Jerome.
Yes... it is solved by unpublishing plugin "HikaMarket Vendor User Location Filter" and "HikaShop Vendor User Location Filter".
Thank you Jerome.
Please Log in or Create an account to join the conversation.
Moderators: Obsidev
Time to create page: 0.140 seconds