Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By work77 on
I just installed the Coherent Access Module to allow for user-level permissions to nodes. I got a nice surprise below when trying to load content (that is of the type that I associated with Coherent Access). Can anybody suggest anything?
* warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "drupal__coherent_access_gid_pkey" in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO drupal__coherent_access_gid (gid, nid, mode) values(0, 28, 0) in /home/www/php/cms/drupal-6.13/modules/coherent_access/coherent_access.module on line 667.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "drupal__coherent_access_gid_gid_seq" is not yet defined in this session in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT CURRVAL('drupal__coherent_access_gid_gid_seq') in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 232.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "drupal__coherent_access_gid_pkey" in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO drupal__coherent_access_gid (gid, nid, mode) values(0, 28, 1) in /home/www/php/cms/drupal-6.13/modules/coherent_access/coherent_access.module on line 667.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "drupal__coherent_access_gid_gid_seq" is not yet defined in this session in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT CURRVAL('drupal__coherent_access_gid_gid_seq') in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 232.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "drupal__coherent_access_gid_pkey" in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO drupal__coherent_access_gid (gid, nid, mode) values(0, 28, 3) in /home/www/php/cms/drupal-6.13/modules/coherent_access/coherent_access.module on line 667.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "drupal__coherent_access_gid_gid_seq" is not yet defined in this session in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT CURRVAL('drupal__coherent_access_gid_gid_seq') in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 232.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "drupal__coherent_access_gid_pkey" in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO drupal__coherent_access_gid (gid, nid, mode) values(0, 28, 7) in /home/www/php/cms/drupal-6.13/modules/coherent_access/coherent_access.module on line 667.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "drupal__coherent_access_gid_gid_seq" is not yet defined in this session in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT CURRVAL('drupal__coherent_access_gid_gid_seq') in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 232.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "coherent_access" does not exist LINE 1: ...T count(*) FROM drupal__node_access WHERE realm = "coherent_... ^ in /home/www/php/cms/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT count(*) FROM drupal__node_access WHERE realm = "coherent_access" AND gid = 0 in /home/www/php/cms/drupal-6.13/modules/coherent_access/coherent_access.module on line 423.
Comments
Use the issue queue for contributed projects
Try looking through http://drupal.org/project/issues/coherent_access , and if nothing matches your situation, file a new report. There's very little chance the developers will be sifting through the thousands of posts in the general forums regularly and see this thread.