Forums

Data log - Error when order by field

antoniov 18 Mar, 2024
When I try to order by a field I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY created asc LIMIT 20 OFFSET 0' at line 1
Sql_error.png
Max_admin 31 Mar, 2024
Hi,

Thank you for reporting this, I have it on the todo list now
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Max_admin 06 Apr, 2024
Answer
This issue is now fixed and should be available in the new 8.0.19 update
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
antoniov 10 Apr, 2024
1 Likes
Now the MySQL error no longer appears, but nothing happens when trying to sort in ascending or descending order by clicking on the field name.
error_orderby_desc.png

Attempting to sort in descending order

error_orderby_asc.png

Attempting to sort in ascending order

Max_admin 11 Apr, 2024
correct, I fixed this for the next update
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.