SQL error on vendor page

  • Posts: 377
  • Thank you received: 7
10 years 3 months ago #166151

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 3 months ago #166152

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.
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.
My bad, it's a mistake in the vendor selection.

View : backend | vendormarket | selection

echo JHTML::_('grid.sort', JText::_('HIKA_NAME'), 'a.user_name', $this->pageInfo->filter->order->dir,$this->pageInfo->filter->order->value );
By
echo JHTML::_('grid.sort', JText::_('HIKA_NAME'), 'a.vendor_name', $this->pageInfo->filter->order->dir,$this->pageInfo->filter->order->value );

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Last edit: 10 years 3 months ago by Jerome.
The following user(s) said Thank You: Dibben

Please Log in or Create an account to join the conversation.

  • Posts: 377
  • Thank you received: 7
10 years 3 months ago #166155

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

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.040 seconds
Powered by Kunena Forum