OJS was down for us this morning due to a bug in MariaDB rolled out last night. I was able to resolve it by upgrading PHP to 7.3 and thought I would share with other users. Below is the error message I found for OJS; then I discovered other sites on our server were also having similar SQL issues. Here is the bug:
I think this is between your PHP PDO library and MySQL; itās below the level of OJS. It may be something like a client library incompatibility between the client compiled into your PHP (or loaded as a library) and the server-side library. (On a live server, if these are updated using a package manager, it might be necessary to restart both the DBMS and the web server of PHP instance pool in order for the libraries to be reloaded with new versions.)
Regards,
Alec Smecher
Public Knowledge Project Team
Yes, the fault is a MariaDB bug in the top link. Since my users complained āOJS doesnāt workā, I started here. I soon found out more than just OJS was failing - other sites on the same server were as well.
I thought this info could be useful today as other admins may be getting the same complaint if they also use MariaDB and PHP<7.3. For me, updating to PHP 7.3 was all it took. This posting wasnāt a complaint about OJS, just attempting to share a finding.