SSL Labs ScoreSecurityHeaders.io Score

Log in to participate

There is no cost to join RicheyWeb, and membership is a requirement to submit bug reports and participate in the support forums.

× EU e-Privacy Directive needs your help!

A free extension like this survives only by reputation. You can help by submitting a review in the Joomla Extension Directory. Please take the time to make a review by clicking on the link below (opens in a new window)

extensions.joomla.org/write-review/review/add?extension_id=4850

V. 3.10.6 - Error 1064

More
2 months 1 week ago #2012 by danielecr
danielecr created the topic: V. 3.10.6 - Error 1064
Hello, unfortunately with the update to 3.10.6 I have a 1064 error on all my pages: from what I read this should be related to sql syntax?

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

More
2 months 1 week ago #2014 by michael
michael replied the topic: V. 3.10.6 - Error 1064
OK, is that the extent of the error? Is there something describing what the sql error is? There is only one query in this new version, and it's:

SELECT folder,element FROM #__extensions WHERE access IN (<csv list of access levels>);

It's a pretty basic query.

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

More
2 months 1 week ago #2015 by michael
michael replied the topic: V. 3.10.6 - Error 1064
Joomla sometimes puts the SQL error in the page title

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

More
2 months 1 week ago #2016 by danielecr
danielecr replied the topic: V. 3.10.6 - Error 1064
Thank you for your reply,
this is what I'm getting:
#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 ')' at line 3

If I disable the system eprivacy plugin everything works (only the system is enough to be disabled to not have the error)

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

More
2 months 1 week ago #2019 by michael
michael replied the topic: V. 3.10.6 - Error 1064
OK, that tells me that there is a problem with the ACL array being sent to the function that loads system plugins. Since the function already tests for the array length, the only thing it could be is an empty element in the array.

Since I don't know how an empty element could get there.... Do you feel comfortable editing PHP?

In /plugins/system/eprivacy/eprivacy.php, at the bottom of the file there is a function called "_loadPlugins"

Before the "if(!count($acl)) {" line, add this:

$acl = array_filter( $acl, 'strlen' );

this removes any empty elements from the array.

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

More
2 months 1 week ago #2021 by danielecr
danielecr replied the topic: V. 3.10.6 - Error 1064
Modification done and uploaded new file in the plugins/system/eprivacy folder, but same error is shown.

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Kunena Forum