I recently updated my host OS to Ubuntu LTS 20.04, which upgraded the MySQL RDBMS to version 8.
I was prompted to upgrade my database tables, but soon discovered that any plugin requiring Geospatial data (in this case Neatline and Geolocation) no longer functioned.
The Zend function calls are slightly different, but the point of failure is the same:
“Mysqli prepare error: FUNCTION mysite_omeka.AsText does not exist”
More specifically:
“Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: FUNCTION mysite_omeka.AsText does not exist in /var/www/html/mysite/application/libraries/Zend/Db/Statement/Mysqli.php:77”
A search of the MySQL developer forums reveals that the “AsText” function has been changed in version 8, to “ST_AsText”:
Can anyone point me toward where this function call is initially generated? Is there a specific library or database table I can modify?