SQL error on vendor page

-- HikaShop version -- : 2.3.2
-- HikaMarket version -- : 1.4.1
-- Joomla version -- : 2.3.2
-- PHP version -- : 5.4
-- Browser(s) name and version -- : firefox
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'a.user_name' in 'order clause' SQL=SELECT * FROM oamvl_hikamarket_vendor AS a WHERE (a.vendor_id > 1) ORDER BY a.user_name asc LIMIT 20, 20

Hi Jerome,
I managed to break the vendor page by trying to sort the vendors by title when selecting them in the product backend now if i click to the vendors page i just get the message :

1054 Unknown column 'a.user_name' in 'order clause' SQL=SELECT * FROM oamvl_hikamarket_vendor AS a WHERE (a.vendor_id > 1) ORDER BY a.user_name asc LIMIT 20, 20

Any idea why?

Thanks
Alex

Hi,

First, you can log out and clean your cookies in order to clean your session and remove the sorting key for the vendor listing.
[strike]I really don't know where you clicked in order to have such sorting key, I don't have any "user_name" sorting in HikaMarket backend.[/strike]
My bad, it's a mistake in the vendor selection.

View : backend | vendormarket | selection By
Regards,

Thanks clearing the cookies also sorted it i shall patch that to prevent future issues
Kind regards