Downloaded RC2; the latest Drupal 6 version of Drupal-COD.

Selecting the "Drupal COD" installation profile, copying the default.settings.php to settings.php in /sites/default/, then inputting my Postgres details enabled the site to be installed successfully.

On the /admin/build/modules page of my website these warnings appear:

  • warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "build"
    LINE 1: ...JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 'build'
    ^ in /public_html/2012/includes/database.pgsql.inc on line 138.
  • user warning:
    query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 'build' in /public_html/2012/modules/node/node.module on line 761.
  • warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: ""
    LINE 1: ...NNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = ''
    ^ in /public_html/2012/includes/database.pgsql.inc on line 138.
  • user warning:
    query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '' in /public_html/2012/modules/node/node.module on line 761.
  • warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "session-schedule"
    LINE 1: ...N node_revisions r ON r.vid = n.vid WHERE n.nid = 'session-s...
    ^ in /public_html/2012/includes/database.pgsql.inc on line 138.
  • user warning:
    query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 'session-schedule' in /public_html/2012/modules/node/node.module on line 761.
  • warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "session-schedule"
    LINE 1: ...N node_revisions r ON r.vid = n.vid WHERE n.nid = 'session-s...
    ^ in /public_html/2012/includes/database.pgsql.inc on line 138.
  • user warning:
    query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 'session-schedule' in /public_html/2012/modules/node/node.module on line 761.
  • warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "sessions"
    LINE 1: ...N node_revisions r ON r.vid = n.vid WHERE n.nid = 'sessions'
    ^ in /public_html/2012/includes/database.pgsql.inc on line 138.
  • user warning:
    query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 'sessions' in /public_html/2012/modules/node/node.module on line 761.
  • warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "sponsors"
    LINE 1: ...N node_revisions r ON r.vid = n.vid WHERE n.nid = 'sponsors'
    ^ in /public_html/2012/includes/database.pgsql.inc on line 138.
  • user warning:
    query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 'sponsors' in /public_html/2012/modules/node/node.module on line 761.

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Postponed (maintainer needs more info)

For several of these it's not clear if they are in cod or just in Drupal or some other module. Can you trace down their origin and pinpoint what needs to be fixed? Marking needs more info for that.

My sense is that pgsql is not the highest priority thing for the cod community right now. So, if you want this fixed you are likely going to have to debug and patch.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Closing due to lack of feedback. Please reopen if you have more details or even a patch.