[Skip to main content](#vessel-content)

#   SQL error on vendor page

##

- **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")**
- [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author
- [ Offline](/forum/user/6788-dibben)

Less More

- Posts: 377
- Thank you received: 7
-
-

12 years 3 months ago [\#166151](#166151) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  *[SQL error on vendor page](/forum/22-market-bug-report/870119-sql-error-on-vendor-page#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&#95;name' in 'order clause' SQL=SELECT &#42; FROM oamvl&#95;hikamarket&#95;vendor AS a WHERE (a.vendor&#95;id &gt; 1) ORDER BY a.user&#95;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&#95;name' in 'order clause' SQL=SELECT &#42; FROM oamvl&#95;hikamarket&#95;vendor AS a WHERE (a.vendor&#95;id &gt; 1) ORDER BY a.user&#95;name asc LIMIT 20, 20  Any idea why?  Thanks Alex")* was created by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")*

-- 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 &gt; 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 &gt; 1) ORDER BY a.user_name asc LIMIT 20, 20

Any idea why?

Thanks
Alex

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg3MDExOS1zcWwtZXJyb3Itb24tdmVuZG9yLXBhZ2U/dG1wbD1tYXJrZG93bg==) 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: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

12 years 3 months ago -  12 years 3 months ago [\#166152](#166152) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[SQL error on vendor page](/forum/22-market-bug-report/870119-sql-error-on-vendor-page#166152 "-- 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&#95;name' in 'order clause' SQL=SELECT &#42; FROM oamvl&#95;hikamarket&#95;vendor AS a WHERE (a.vendor&#95;id &gt; 1) ORDER BY a.user&#95;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&#95;name' in 'order clause' SQL=SELECT &#42; FROM oamvl&#95;hikamarket&#95;vendor AS a WHERE (a.vendor&#95;id &gt; 1) ORDER BY a.user&#95;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 &#124; vendormarket &#124; selection Code:

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

By Code:

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

Regards,

---

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

Last edit: 12 years 3 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile").

The following user(s) said Thank You: [Dibben](/forum/user/6788-dibben "View Dibben's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg3MDExOS1zcWwtZXJyb3Itb24tdmVuZG9yLXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")**
- [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author
- [ Offline](/forum/user/6788-dibben)

Less More

- Posts: 377
- Thank you received: 7
-
-

12 years 3 months ago [\#166155](#166155) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[SQL error on vendor page](/forum/22-market-bug-report/870119-sql-error-on-vendor-page#166155 "-- 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&#95;name' in 'order clause' SQL=SELECT &#42; FROM oamvl&#95;hikamarket&#95;vendor AS a WHERE (a.vendor&#95;id &gt; 1) ORDER BY a.user&#95;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&#95;name' in 'order clause' SQL=SELECT &#42; FROM oamvl&#95;hikamarket&#95;vendor AS a WHERE (a.vendor&#95;id &gt; 1) ORDER BY a.user&#95;name asc LIMIT 20, 20  Any idea why?  Thanks Alex")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg3MDExOS1zcWwtZXJyb3Itb24tdmVuZG9yLXBhZ2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.053 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
