Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot use the filter allassignees:Username in PostgreSQL #82

Open
PCunvik opened this issue Jun 21, 2023 · 1 comment
Open

Cannot use the filter allassignees:Username in PostgreSQL #82

PCunvik opened this issue Jun 21, 2023 · 1 comment

Comments

@PCunvik
Copy link

PCunvik commented Jun 21, 2023

Kanboard version: 1.2.30
PHP Version: 8.2.7
Group_assign version: 1.8.2
PostgreSQL version: 15.2

I added multiple people to a task and used the filter allassignees:Username as the database complains about the syntax:
SQL: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "`"

It is this query that gives the error:
(SELECT id FROM `groups` WHERE `groups`.name='petcun')

I saw that fix #70 fixed a bug in mysql where "groups" was a reserved word, I removed the fix and postgres didn't complain about the syntax anymore and it worked.

@szjozsef
Copy link

We have the exact same situation we had to remove the "`" characters form the query in order to make it compatible with PostgreSQL again

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants