Issue with SQL syntax on MySQL 8.0.36 Topic is solved

[iorbita]

Hi everyone,
I've migrated a few sites to another host, for one of the sites and only for the blog section (blog by EasyBlog) I'm getting an SQL error that I don't get if the site is installed locally or if it's installed at the previous host.

The problem comes from the server database version.

Previous host: MariaDB 10.2.44 -> no problem
Local: MySQL 5.7.39 -> no problem
New host: MySQL 8.0.36 -> problem.

Here's the error I get:

Code: Select all

"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 'DESC ORDER BY a.`created` DESC' at line 1"

After some research on the web it seems that a query uses an alias (a.created) in the ORDER BY clause, which is incompatible with MySQL 8.0.36.
I've tried some SQL rules in phpMyAdmin on a development site but basically I don't know which table to target because EasyBlog has a lot of them and honestly I don't even know if my SQL rule is correct...

Can anyone tell me how to fix this?

Many thanks,
Lorenzo

Joomla 3.10.12
PHP 7.4.33

[iorbita]

... I share the fix, perhaps someone will need it.

In this case, you need to delete the DESC string in /administrator/components/com_easyblog/models/archive.php on line 327.

[pe7er]

Good to see that you've solved it yourself. Thanks for sharing your solution!