Received the below error messages midway through posting a whole load of news stories. Repaired table, and tried to sort out myself, but struggling. Simply won't let me post any news, and have no idea how to fix?
Please Help....
•user warning: Duplicate entry '11-11' for key 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, sticky) VALUES (11, 11, 'HEADLINE', 'story', 1, 1, 1268642835, 1268642845, 2, 1, 0) in /usr/www/users/name/web/includes/database.mysql.inc on line 172.
•user warning: Duplicate entry '11' for key 1 query: INSERT INTO node_revisions (nid, vid, title, body, teaser, timestamp, uid, format, log) VALUES (11, 11, 'HEADLINE', 'HEADLINE\r\n', 'HEADLINE\r\n', 1268642845, 1, 1, '') in /usr/www/users/name/web/includes/database.mysql.inc on line 172.
•user warning: Duplicate entry '11' for key 1 query: INSERT INTO node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (11, 1268642845, NULL, 1, 0) in /usr/www/users/name/web/includes/database.mysql.inc on line 172.
Comments
ideas?
Any idea, anyone? Anything?! (desperate pleas...)
Co to your database via
Go to your database via phpmyadmin and look for the node table, check out the last nid value in your table. And go to operations and make sure the auto increment value is next nid value.
Acquia certified Developer, Back end and Front specialist
Need help? Please use my contact form
Didn't work :(
Updated Nid etc in the various tables above, which looked like they were set right to start with, but it hasn't made any difference. :(
Any other ideas or do I have to start over?
You need to set the
You need to set the autoincrement values in tables : node, node_revisions, node_comment_statistics.
Acquia certified Developer, Back end and Front specialist
Need help? Please use my contact form