Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I am wanting to get this module working with postgres. It is almost working, but having some issues... Compensation is available, if someone can help...
errors...
* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/share/drupal/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT DISTINCT(n.nid), n.title FROM node n INNER JOIN video v ON n.vid = v.vid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = -1 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'tac_lite'))) AND n.type = 'video' AND n.status = 1 AND n.moderate = 0 ORDER BY n.created DESC LIMIT 10 OFFSET 0 in /usr/share/drupal/includes/database.pgsql.inc on line 110.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/share/drupal/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT DISTINCT(n.nid), n.title FROM node n INNER JOIN video v ON n.vid = v.vid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = -1 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'tac_lite'))) AND n.type = 'video' AND n.status = 1 AND n.moderate = 0 ORDER BY RAND() DESC LIMIT 1 OFFSET 0 in /usr/share/drupal/includes/database.pgsql.inc on line 110.
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | pgsql.patch_0.txt | 2.63 KB | fax8 |
| #3 | pgsql.patch.txt | 1.74 KB | fax8 |
Comments
Comment #1
JamieR commentedThis module is not currently working in a postgresql environment.
Comment #2
fax8 commentedThe attached patch add support for PostgreSQL for video module for 4.7.
The errors you are getting are probably not related to the video module.
I think that are related to the code of some access module.
Fabio
Comment #3
fax8 commentedhere is the patch
Comment #4
fax8 commentedthis patch should fix the original author problems with SELECT and ORDER BY.
Comment #5
fax8 commentedPatch committed to HEAD and 4.7
Fabio
Comment #6
(not verified) commented