Data log - Error when order by field

Resolve data log sorting errors in ChronoForms.

Overview

The issue was caused by a SQL syntax error when ordering by a field, which was fixed in an update, but sorting functionality remained unresponsive.
Update to the latest version to correct the SQL error, then ensure you apply the subsequent fix to restore full sorting functionality when clicking field names.

an 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

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.

an 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.

Attempting to sort in descending order

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.

This topic is locked and no more replies can be posted.