Error showing "Syntax Error or Access Rule Violation detected by database" in list view for a specific tableIssue If a below error message format is showing on any list view Syntax Error or Access Rule Violation detected by database ((conn=xxxxx) 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 'DESC limit 0,20 /* <instance node>, gs:xxxxxxxxxxxxxxxxxx, tx:xxxxxx' at line x) Example: If error message is showing on 'my groups work' module list then this module uses 'Task' table as source. So any Task table list will also show the same error ResolutionMost Possible Cause: Sort Order was not set on any column on the list and it is causing SQL error to identify the order while generating the query Solution: Sort any existing column of the list (like 'Number' field)Related LinksControlling the sort sequence used to display lists