Possible bug in new version?

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

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.

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

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

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.

wow - sounds like magic to me

1000 thanks