1064 error listing vendors menu

-- HikaShop version -- : 2.7.0
-- HikaMarket version -- : 1.6.7
-- Joomla version -- : 3.4.5
-- Error-message(debug-mod must be tuned on) -- : 1064 error listing vendors menu

Hi,
After update hikashop and hikamarket, I found 1064 error in vendor listing menu.
I activate debug mode and even remove all customization in hikamarket views, but error still exists.
Debug mode shows nothing except "page not found error: 404".
I coudn't find the error.
Please see and help me solving the problem. (Site is live and this error irritate customers)
Mehdi.

Same to me!

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 > 1) ORDER BY vendor.vendor_created inherit LIMIT 0, 9

Thanks filiar for your reply.
In what file I should apply your recommended changes?

No, mehdikazemi. The script is just the description of the error that I got. It is not the solution. I attached it to help hika team find the problem.

Hi,

@mehdikazemi

Please note that HikaShop 2.7.0 does not exist ; it is not a valid HikaShop version number.

Your menu "فروشگاه-ها" is a product listing menu ; so it means that it points to HikaShop.
The url "فروشگاه-ها/vendormarket/listing" is not a valid URL because it still use the same HikaShop menu but with a HikaMarket controller.
The Joomla router can't know that it has to call HikaMarket and HikaShop does not know that controller name.

Please check the configuration of your Joomla menus.

@filiar

Please be really sure that you have the exact same issue that a thread before posting into it.
Because, in your case you need to open a new thread.

Regards,

Hi
You are right, I wrote a wrong version, I meant 2.6.0.
BTW, the URL you saw is redirecting by Sh404SEF, so it is totally independent to "فروشگاه-ها".
(Non-SEF: index.php?option=com_hikamarket&Itemid=603&lang=fa&layout=listing&view=vendormarket)
In addition, it worked before last update I have done today, like a charm.
As I said, this menu is hikamarket vendor listing menu item.
Would you please review this problem considering this.
Thanks in advance,
Mehdi.

Jerome, my error number is also 1064. Isn't it the same as it happens on vendor listing menu.

Regards!

@mehdikazemi

If you take your non SEF URL and you remove the "itemid=603", you will have a working vendor listing display.
So I still don't know what that menu "603" is or how it is configured. Please reply to that question in order to go forward.

@filiar

Once again, please create a new thread for your different issue.
Even if you have a "1064" code ; you have an error message and mehdikazemi does not have that same message (currently, he does not have any error description except a 404 page).
So for the moment, it is a different problem !

I did nothing for menu itemid of vendor listing menu. It is set automatically by joomla. (603 is the id of menu item)

Hi,

Please check the configuration of your Joomla menus.

So I still don't know what that menu "603" is or how it is configured. Please reply to that question in order to go forward.

So, I'll reformulate, once again :
Please provide details about that Joomla menu configuration.

Regards,

See the attached images. I captured two screenshot of the menu configuration. Is that help?

I have created a new vendor listing menu and the problem repeated in that menu.
Can you help me? Site is live and it is not a good situation.

Hi,

Thanks for the screenshots.
Can you please re-download HikaMarket 1.6.7 in order to see if it fix your issue ?

Regards,

Hi Jerome,
Thank you.
New version solved my issue.