Compatibility with PostgreSQL and SQLite

HI,

Thanks for the report.

I quickly tried the module with 10.2.5 and SQlite but I don't encounter any problems.

What problems do you have with postgres?

The query is objectively not beautiful but it should still work...

I needed this patch with PostgreSQL 12
it should still work with mysql /mariadb and sqlite

HI,

I replicated the problem with PostgreSQL:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 5: ORDER by b.weight ^: SELECT DISTINCT * FROM "book" as b inner join "node" as n ON n.nid = b.nid WHERE b.pid = :pid ORDER by b.weight; Array ( [:pid] => 1 ) in Drupal\booktree\Controller\BooktreeController->booktree_mostra_figli() (line 69 of /var/www/html/booktree-pgsql/web/modules/contrib/booktree/src/Controller/BooktreeController.php).

the patch fixes it.
Thank you

I apply the fix to both branches 8.x-1.x and 3.x

Thanks Uccio!

Automatically closed - issue fixed for 2 weeks with no activity.