1064 error listing vendors menu

  • Posts: 54
  • Thank you received: 2
8 years 11 months ago #223305

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

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

  • Posts: 134
  • Thank you received: 6
8 years 11 months ago #223325

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

Last edit: 8 years 11 months ago by filiar.
The following user(s) said Thank You: mehdikazemi

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

  • Posts: 54
  • Thank you received: 2
8 years 11 months ago #223328

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

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

  • Posts: 134
  • Thank you received: 6
8 years 11 months ago #223330

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.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 11 months ago #223331

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,

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.

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

  • Posts: 54
  • Thank you received: 2
8 years 11 months ago #223360

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.

Last edit: 8 years 11 months ago by mehdikazemi.

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

  • Posts: 134
  • Thank you received: 6
8 years 11 months ago #223361

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

Regards!

Last edit: 8 years 11 months ago by filiar.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 11 months ago #223364

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

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.

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

  • Posts: 54
  • Thank you received: 2
8 years 11 months ago #223388

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

Last edit: 8 years 11 months ago by mehdikazemi.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 11 months ago #223398

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,

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.

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

  • Posts: 54
  • Thank you received: 2
8 years 11 months ago #223424

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

Attachments:

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

  • Posts: 54
  • Thank you received: 2
8 years 11 months ago #223430

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.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 11 months ago #223464

Hi,

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

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.

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

  • Posts: 54
  • Thank you received: 2
8 years 11 months ago #223474

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

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

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