Possible bug in new version?

  • Posts: 9
  • Thank you received: 1
  • Hikashop Business
3 years 11 months ago #327187

-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.9323
-- Browser(s) name and version -- : various
-- Error-message(debug-mod must be tuned on) -- : 42000 - SQLSTATE[42000]: Syntax error or access violation: 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 'SELECT * FROM muryi_hikashop_variant AS v LEFT JOIN muryi_hikashop_characterist' at line 1

hi everyone.
I don't know if you can help me - hope so.
since I updated Hikashop about 5% of my customers can't access their "Customer download space" they get an errormessage



If they navigate in their browser back, they can access their customer space and view their orders, but not the "customer download space"

We didn't find any relations that could be a common thing... they use various browsers and devices.. some are old customers, some new... all in all about 5-10%.

Thanks for input

ManuBothe

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
3 years 11 months ago #327189

Hi,

We'll need more information on the problem.
Please do this modification:
www.hikashop.com/support/forum/install-u...ror-1064.html#326783
That way, the error message there will contain the full MySQL query.
And second, when you reproduce the issue, please activate before the "error reporting" and "debug mode" settings of the Joomla configuration.
That way, that error message should contain more information like the "call stack" so that will help us understand what's going on.

The following user(s) said Thank You: manubothe

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

  • Posts: 9
  • Thank you received: 1
  • Hikashop Business
3 years 11 months ago #327248

Sorry it took me so long - had to find a "good" time to do this.

heres the error report - hope I did everything correctly.



Thanks in advance

Attachments:

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

  • Posts: 9
  • Thank you received: 1
  • Hikashop Business
3 years 11 months ago #327249

I have to add and emphasize, this problem still only affects about 5-10% of our customers... and I had to use a customers account to reproduce this error, cos I couldn't do it with any account I created...

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
3 years 11 months ago #327260

Hi,

Thank you for that.
I was able to replicate the issue and after much debugging, I found what was the problem and made a patch for it.
Download again the install package of HikaShop on our website and install it on yours and it will add the patch for that error.

The following user(s) said Thank You: manubothe

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

  • Posts: 9
  • Thank you received: 1
  • Hikashop Business
3 years 11 months ago #327289

wow - sounds like magic to me

1000 thanks

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

Time to create page: 0.067 seconds
Powered by Kunena Forum