By mok000 on
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
I have this same problem and
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/
I have this problem too
http://copyobject.ru/ - компании по созданию макетов
I seem to be suffering too - 6.12...
Presumably the SQL should pass in null,and not 0....
see also http://drupal.org/node/183125
see also http://drupal.org/node/183125