Are you enjoying the extensions? Did you like the support? Help others decide.

Leave a review

file 500 Error Unless Change Selection

More
5 months 3 weeks ago #6065 by smusselm
500 Error Unless Change Selection was created by smusselm
I'm not sure when it started, but if I make any changes to a module, it will cause a 500 error on the page, unless I wipe out the item selection category, save, and then select the proper categories again. 

The error comes up with something that points to my template:
An exception has been thrown during the rendering of a template ("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 a.state = 1 AND a.created_by > 0 AND `a`.`featured` = 0 GROUP BY `a`.`id` ' at line 15")

However, this is the only module I have an issue with. I have a workaround, albeit an annoying one, but I thought someone would like to know.

PHP: 8.1.2-1ubuntu2.17
MYSQL: 8.0.36-0ubuntu0.22.04.1
Joomla: 5.1.1
Latest News Enhanced: 7.0.0

It is for an intranet, so I can't provide site access due to network stuff outside my control.

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

More
5 months 3 weeks ago #6066 by syw
Replied by syw on topic 500 Error Unless Change Selection
Hello!

Do you use any cache system, like the Joomla cache?
It would be great to have more info, like logs, full database query...
Thanks!
Olivier.

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