"PDOException : SQLSTATE[42803]: Grouping error" when creating a simple queue (PostgreSQL)

formatting error

I can't get this module working (at least the main functionality which is create a simple queue) using PostgreSQL.

Your patch works well, but still got an error :

PDOException : SQLSTATE[22P02]: Invalid text representation: 7 ERREUR: invalid syntax for integer : « add » LINE 1: ...) AS subqueues FROM nodequeue_queue q WHERE q.qid IN ('add') ^: SELECT q.*, (SELECT count(*) FROM {nodequeue_subqueue} s WHERE q.qid = s.qid) AS subqueues FROM {nodequeue_queue} q WHERE q.qid IN (:to_load_0); Array ( [:to_load_0] => add ) dans nodequeue_load_queues() (line 613 in .../sites/all/modules/contrib/nodequeue/nodequeue.module).

The attached patch fixed it (in addition with yours).

Assuming the same thing has to be done in nodequeue_load_subqueues

The patch only applies for 7.x-2.x branch

#5: 1475396_cast_int.patch queued for re-testing.

Now, getting an issue while showing a view ordered by the queue :

PDOException : SQLSTATE[42803]: Grouping error: 7 ERREUR: the column « q.sqid » must appears in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT s.*, COUNT(n.position) AS count ^: SELECT s.*, COUNT(n.position) AS count FROM {nodequeue_subqueue} s LEFT OUTER JOIN {nodequeue_nodes} n ON n.sqid = s.sqid WHERE (( (s.qid = :db_condition_placeholder_0) AND (s.reference IN (:db_condition_placeholder_1)) )) GROUP BY s.sqid; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 ) dans nodequeue_load_subqueues_by_reference() (ligne 794 dans .../sites/all/modules/contrib/nodequeue/nodequeue.module).

Works fine.
Just added a missing parenthesis in the last modified query.