error on discount when selecting vendor

-- url of the page with the problem -- : backend
-- HikaShop version -- : 2.6.0
-- HikaMarket version -- : 1.6.7
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.4
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'a.user_id' in 'order clause' SQL=SELECT * FROM shd8y_hikamarket_vendor AS a WHERE (a.vendor_id > 1) ORDER BY a.user_id asc LIMIT 0, 25

Hi,

I went to select a vendor so that there was a discount for just that vendor however i now just get an error message
Unknown column 'a.user_id' in 'order clause' SQL=SELECT * FROM shd8y_hikamarket_vendor AS a WHERE (a.vendor_id > 1) ORDER BY a.user_id asc LIMIT 0, 25

Hi,

Please logout from your backend in order to clean your session.
If it does not work ; it could be interesting to delete the cookies for your website.

It looks like there is a "sorting" column stored in the session which is used by two different views.
But, in order to fix the issue ; I'll need to know the very exact place where the error is coming from because there are a lot of places in HikaMarket where that kind of SQL query is made.

Regards,

Hi Jerome,

Yes logging out seems to have worked. It happened when i created a coupon and applied it to a specific vendor. When i wanted to sort by ID number (so i could see the most recent vendor more quickly within the lightbox) the error occurred. It then stayed there when i went to the view vendors normally in hikamarket.

Kind regards

Alex

Hi,

In the file "administrator/components/com_hikamarket/views/vendormarket/view.html.php" you can replace By so it would use a different "key" to store the sorting value in the vendor selection and in the vendor listing.

In the same view, you can also replace By In order to specify the authorized columns for the ordering ; it will avoid the SQL error you got.

These two patchs will be tested and added into HikaMarket.

Regards,