Self HostedDatabasesWeb

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION appwrite.JSON_OVERLAPS does not exi

Jul 12, 2024, 21:00

View on Discord

Votes

Replies

Participants

Unknown

Messages

AbhishekOriginal post

Rank 2: Process

Jul 12, 2024, 20:26

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

Plain text

/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}```

Summary

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.

Jul 12, 2024, 20:47

Could you specify how to replicate this?

Jul 12, 2024, 20:48

You're using the query contains filter, but in what attribute or how?

Abhishek

Rank 2: Process

Jul 12, 2024, 20:52

Attribute Type: String []
Code:

        databases.listDocuments(
            "DB",
            "COLL",
            [Query.contains('column', ['A','B']]
        ).then().catch();

Steven

Jul 12, 2024, 20:53

Are you not using mariadb?

Abhishek

Rank 2: Process

Jul 12, 2024, 20:54

Yes

Steven

Jul 12, 2024, 20:55

Yes you aren't?

Abhishek

Rank 2: Process

Jul 12, 2024, 20:55

Sorry, I'm using mariadb

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join Discord Get premium support