Kanban module throws SQL error

[BullDoggen]

Just got FreeScout installed with some modules and when I try to open Manage for Kanban it throws and error page and writes to log:

SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "union" LINE 1: ...atus" asc, "last_reply_at" desc limit 11 offset 0 union sele... ^ (SQL: select "conversations".* from "conversations" where "state" = 2 and "mailbox_id" = 1 and "status" in (1, 2) and "status" = 2 order by "status" asc, "last_reply_at" desc limit 11 offset 0 union select "conversations".* from "conversations" where "state" = 2 and "mailbox_id" = 1 and "status" in (1, 2, 3) and "status" = 3 order by "status" asc, "last_reply_at" desc limit 11 offset 0)

I think that the error is the 2 order by's, which is incorrect. How to solve this?

[freescout-helpdesk]

What DB are you using?

[BullDoggen]

It should be MySQL, but I can't confirm this 100% since I can't reach our admin currently and I don't have access to the servers. I can verify this later.

[BullDoggen]

Nope, it is running on postgreSQL

[freescout-helpdesk]

OK. We'll try to adjust the request for postgreSQL.

[freescout-helpdesk]

What are your PHP and PostgreSQL versions?

[freescout-helpdesk]

By some reason php-pgsql driver does not wrap selects into parentheses like this: (select...) union (select...)

PHP pdo driver for MySQL does it:

[freescout-helpdesk]

Kanban Module v.1.0.2 is compatible with PostgreSQL now. We had to discard unions. This may make performance of Kanban boards very low on PostgreSQL.

If someone knows how to make unions work on PostgreSQL please let us know.