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

#   Vendor listing error 1064

##

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

Less More

- Posts: 134
- Thank you received: 6
-
-
-
- [](https://madein-bg.com)
-

10 years 11 months ago -  10 years 11 months ago [\#223436](#223436) by [filiar](/forum/user/33070-filiar "View filiar's Profile")  *[Vendor listing error 1064](/forum/22-market-bug-report/880967-vendor-listing-error-1064#223436 "-- HikaShop version -- : 2.6.0 -- HikaMarket version -- : 1.6.7 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Error-message(debug-mod must be tuned on) -- : 1064  -- MYSQL version 5.6.27  Hi, as described in the other topic concerning simillar error, this is my bug report about vendor listing menu, regarding the last HM update.  That is the exact message I get:  Regards, Iliya")* was created by *[filiar](/forum/user/33070-filiar "View filiar's Profile")*

-- HikaShop version -- : 2.6.0
-- HikaMarket version -- : 1.6.7
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.6.14
-- Error-message(debug-mod must be tuned on) -- : 1064

-- MYSQL version 5.6.27

Hi, as described in the other topic concerning simillar error, this is my bug report about vendor listing menu, regarding the last HM update.

That is the exact message I get: Code:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'inherit LIMIT 0, 9' at line 1 SQL=SELECT vendor.* FROM mibg_hikamarket_vendor AS vendor WHERE (vendor_published = 1) AND (vendor.vendor_id &gt; 1) ORDER BY vendor.vendor_created inherit LIMIT 0, 9

Regards,
Iliya

Last edit: 10 years 11 months ago by [filiar](/forum/user/33070-filiar "View filiar's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg4MDk2Ny12ZW5kb3ItbGlzdGluZy1lcnJvci0xMDY0P3RtcGw9bWFya2Rvd24=) 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)
-

10 years 11 months ago [\#223463](#223463) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Vendor listing error 1064](/forum/22-market-bug-report/880967-vendor-listing-error-1064#223463 "-- HikaShop version -- : 2.6.0 -- HikaMarket version -- : 1.6.7 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Error-message(debug-mod must be tuned on) -- : 1064  -- MYSQL version 5.6.27  Hi, as described in the other topic concerning simillar error, this is my bug report about vendor listing menu, regarding the last HM update.  That is the exact message I get:  Regards, Iliya")*

Hi,

In the file "administrator/components/com_hikamarket/helpers/helper.php" please replace in the function "processFilters" Code:

if(empty($orderingAccept) &#124;&#124; in_array($t.'.', $orderingAccept) &#124;&#124; in_array($this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value, $orderingAccept)) $order = ' ORDER BY '.$this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value.' '.strtoupper($this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir);

By Code:

$dir = strtolower($this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir); if(!in_array($dir, array('asc', 'desc'))) $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir = 'ASC'; if(empty($orderingAccept) &#124;&#124; in_array($t.'.', $orderingAccept) &#124;&#124; in_array($this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value, $orderingAccept)) $order = ' ORDER BY '.$this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value.' '.strtoupper($this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir);

It will avoid to insert an "inherit" as the value of the ordering.
Now I don't understand why you have that error because there is check in the view in order to replace the "inherit" by "ASC" ; I tried to reproduce your issue but I couldn't. That's why the patch for the helper will be a good solution.

Regards,

---

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

The following user(s) said Thank You: [filiar](/forum/user/33070-filiar "View filiar's Profile")

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

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

Less More

- Posts: 134
- Thank you received: 6
-
-
-
- [](https://madein-bg.com)
-

10 years 11 months ago [\#223472](#223472) by [filiar](/forum/user/33070-filiar "View filiar's Profile")  Replied by *[filiar](/forum/user/33070-filiar "View filiar's Profile")* on topic *[Vendor listing error 1064](/forum/22-market-bug-report/880967-vendor-listing-error-1064#223472 "-- HikaShop version -- : 2.6.0 -- HikaMarket version -- : 1.6.7 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Error-message(debug-mod must be tuned on) -- : 1064  -- MYSQL version 5.6.27  Hi, as described in the other topic concerning simillar error, this is my bug report about vendor listing menu, regarding the last HM update.  That is the exact message I get:  Regards, Iliya")*

Thank You, Jerome.. That fixed the issue.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg4MDk2Ny12ZW5kb3ItbGlzdGluZy1lcnJvci0xMDY0P3RtcGw9bWFya2Rvd24=) 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.062 seconds

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