SQL error on Subscription display

  • Posts: 246
  • Thank you received: 5
5 years 7 months ago #295990

-- HikaShop version -- : 3.5.1
-- HikaSerial version -- : 2.2.0
-- Joomla version -- : 3.8.8

Hi,

Going to the menu "personal dashboard" on the front, clicking on "my subscriptions" give an error :

Erreur: 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 ') AND pack.pack_published = 1' at line 1

No error in the backend which shows the 3 test subscription in the HikaSerial component.

All the others link of the user dashboard on the front work as expected (My Serials, My cart, My orders, etc...)

I did not succeed in displaying the SQL in error (error log, error reporting, browser console....)

Regards,

Laurent

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

  • Posts: 246
  • Thank you received: 5
5 years 7 months ago #296013

Well, today, everything work fine ?!?.....
Closing this one.

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

  • Posts: 246
  • Thank you received: 5
5 years 7 months ago #296016

Finally, the error raised again....
It seems to occur only if there is at least one active subscription.

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
5 years 7 months ago #296014

Hello,

If the issue come back, please activate the Joomla debug mode to get the call stack and know the source of the issue (the file and the line).

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: 246
  • Thank you received: 5
5 years 7 months ago #296371

The error is showing in an error page on which the debug does not show. Nothing else is displayed.
It shows without errors if the subscriptions are closed of expired.....

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
5 years 7 months ago #296398

Hello,

Unfortunately, we have lot of queries with "pack.pack_published = 1".
But I think that I fond the one responsible of your issue and I made a patch for it.
You can re-download HikaSerial to get the fix.

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: 246
  • Thank you received: 5
5 years 7 months ago #296446

So far, no more error with the new code.
Thanks.

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

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