when i try to access manage applications from the menu admissions I get this error in the server’s log.
Can somebody help? I’d appreciate it.
AH01071: Got error ‘PHP message: Warning: SQLSTATE: Syntax error or access violation: 1064 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 ‘>>“$.surname” AS studentSurname,
data->>"…’ at line 15 in …/src/Database/Connection.php on line 194PHP message: Uncaught Exception: Error - PDO object is uninitialized in …/src/Database/Result.php on line 49’, referer: … /index.php?q=%2Fmodules%2FAdmissions%2FstudentEnrolment_manage.php
Hi pllabreu, this sounds like it might be a MariaDB (MySQL) config issue. Please can you let us know which version of MariaDB you are using? Thanks, Ross.
It is concerning, if MariaDB and MySQL may have diverged in this area and are no longer compatible
Dears Ross and Sandra
After a ‘git pull’, the issue disappeared…
But I am using version 10.4.22
Hi Paul, thanks for the update. We discovered the issue is that MariaDB unfortunatly doesn’t support a specific syntax for working with JSON data, however there was a syntax that both MySQL and MariaDB do support, so we’ve updated all the admissions code, which is why after pulling the latest v24 you should see it working (which is great to hear). Thanks!
You’re welcome!! And congrats for the great work you have all been doing!