Back
SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION appwrite.JSON_OVERLAPS does not exi
SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION appwrite.JSON_OVERLAPS does not exist
{"message":"Server Error","code":500,"type":"general_unknown","version":"1.5.7"}
This happens when querying with contains filter
@swoole/library/core/Database/PDOStatementProxy.php
TypeScript
/usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php in __call at line 1821
/usr/src/code/vendor/utopia-php/database/src/Database/Database.php in find at line 4859
/usr/src/code/vendor/utopia-php/database/src/Database/Validator/Authorization.php in Utopia\Database\{closure} at line 166
/usr/src/code/vendor/utopia-php/database/src/Database/Database.php in skip at line 4870
/usr/src/code/app/controllers/api/databases.php in find at line 3021
/usr/src/code/vendor/utopia-php/framework/src/App.php in {closure} at line 531
/usr/src/code/vendor/utopia-php/framework/src/App.php in execute at line 705
/usr/src/code/app/http.php in run at line 257
{closure}```
TL;DR
Developers are facing a syntax error due to a missing function 'appwrite.JSON_OVERLAPS' when using the `contains` filter in an SQL query with MariaDB. The error is causing a server error with code 500. This issue occurs in the PDOStatementProxy file.
Could you specify how to replicate this?
You're using the query contains filter, but in what attribute or how?
Attribute Type: String []
Code:
TypeScript
databases.listDocuments(
"DB",
"COLL",
[Query.contains('column', ['A','B']]
).then().catch();
Are you not using mariadb?
Yes
Yes you aren't?
Sorry, I'm using mariadb
