Hi there,
I've got a new site running for a corporate client with a sysadmin I've never worked with before, and we seem to have some teething issues. I encountered the following issue whenever I attempt to modify an existing SEF URL in the sh404SEF component:
ERROR:
Could not save data. Error: 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 'ASC' at line 1
Steps to replicate (on their server):
Go to Components > sh404SEF > SEF URLs
Perform a search for 'general' in the search bar at the top of the URL list.
Click on the URL 'general/terms-conditions' - and change it to 'terms', then click save.
Error appears at that point.
Their sysadmin response is as follows:
On investigation we found that there is some issue with the component sh404sef. This happened as ‘rank’ is the column name in table sh404sef_urls. In MySQL ‘rank’ is used as function, as a result there is a conflict.
Given I've never encountered this in the dozens of dozens of sites I have running sh404SEF, I'm somewhat dubious of their claims.
Here's my system info:
Setting Value
PHP Built On Windows NT SV 10.0 build 17763 (Windows Server 2016) AMD64
Database Type mysql
Database Version 8.0.15
Database Collation utf8mb4_0900_ai_ci
Database Connection Collation utf8mb4_0900_ai_ci
PHP Version 7.3.3
Web Server Microsoft-IIS/10.0
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.9.6 Stable [ Amani ] 7-May-2019 15:00 GMT