After upgrading from 6.4 to 6.6, Drupal no longer accepts posts. When attempting, I get the error messages below. As you can see, I am using the PostgreSQL backend:

warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "node_revisions_pkey" in /u/mok/public_html/includes/database.pgsql.inc on line 138.
user warning: query: INSERT INTO node_revisions (nid, uid, title, body, teaser, log, timestamp, format) VALUES (0, 1, 'This is test title', 'Test content. Yikes!', 'Test content. Yikes!', '', 1225897441, 2) in /u/mok/public_html/includes/common.inc on line 3324.
warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "node_vid_idx" in /u/mok/public_html/includes/database.pgsql.inc on line 138.
user warning: query: INSERT INTO node (vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) VALUES (0, 'blog', '', 'This is test title', 1, 1, 1225897441, 1225897441, 2, 1, 0, 0, 0, 0) in /u/mok/public_html/includes/common.inc on line 3324.
warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "node_comment_statistics_pkey" in /u/mok/public_html/includes/database.pgsql.inc on line 138.
user warning: query: INSERT INTO node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (0, 1225897441, NULL, 1, 0) in /u/mok/public_html/modules/comment/comment.module on line 607.
The post could not be saved.

I can see that there is a duplicate key problem, but I need some input on how to fix that.

Cheers,
Morten

Comments

Anonymous’s picture

I have this same problem and I'm now feeling very helpless about it. Whatever I do I can't post new article. To make things worse, every time I try (unsuccessfully), my whole site becomes forbidden, at least until I rebuild permissions. This is making me very, very sad, I don't have any clue how to resolve this, and until I do, obviously no new articles. :(

Drupal 6.9, PostgreSQL.

Please help!
--
http://www.linuxinsight.com/

Djamshud’s picture

http://copyobject.ru/ - компании по созданию макетов

David Goodwin’s picture

Presumably the SQL should pass in null,and not 0....

David Goodwin’s picture