By scopas on

HI,

Whenever posting a new entry I get a duplicate entry error in two tables:

user error: Duplicate entry '55' for key 1
query: INSERT INTO alpha_node (title, body, format, uid, type, teaser, status, moderate, promote, sticky, comment, created, changed, nid) VALUES('sdf', 'sdf', '1', '2', 'blog', 'sdf', '1', '', '1', '', '2', '1118866276', '1118866276', '55') in /usr/home/web/my.site.dgd.se/alpha/includes/database.mysql.inc on line 66.

user error: Duplicate entry '55' for key 1
query: INSERT INTO alpha_node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (55, 1118866276, NULL, 2, 0) in /usr/home/web/my.site.dgd.se/alpha/includes/database.mysql.inc on line 66.

I have manually inserted 500+ posts in these table so the error is understood. Question is: Where do I change the counter value (key?) for last post? The node_counter table does not contain any posts.

Thanks,
~ B

Comments

Ayman’s picture

Ayman commented

I think it is in the sequences table, change the id of the key node_nid [and comments_cid].

Good luck :)