Problem 1:
When I try to post a new page I get an error simmilar to the one below (the autoincrement value on the nodes table is correct), could you tell me were the increment value is stored because it seems to me that the nodes table is the wrong place.
user error: Duplicate entry '10' for key 1
query: INSERT INTO harrypotter.node (status, moderate, promote, sticky, comment, title, body, format, uid, created, type, teaser, changed, nid) VALUES('1', '0', '0', '0', '0', 'Privacy Policy', '
Introduction.
We take your right to privacy seriously and want you to feel comfortable using our web site. This Privacy Policy deals with personally
identifiable information (referred to as \"Data\" below) that may be collected by us on our site. This Policy does not apply to other entities that we do not own or control or persons that are not our employees, agents or within our control. Please take time to read our Terms of Use.
1. Collection of Data.
Our registration process requires only a valid e-mail address and a unique user ID and password. Providing us with other information is at your option. Please take note that your user name, e-mail address, or other submissio in /home/wizards/includes/database.mysql.inc on line 66.
user error: Duplicate entry '10' for key 1
query: INSERT INTO harrypotter.node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (10, 1127925720, NULL, 2, 0) in /home/wizards/includes/database.mysql.inc on line 66.
warning: Cannot modify header information - headers already sent by (output started at /home/wizards/includes/common.inc:384) in /home/wizards/includes/common.inc on line 192.
Problem 2:
I imported all my users from postnuke, but now all of them don't have the authenticated user role enabled. Which table is this role stored in so that I can write a script that makes everyone authenticated?
Comments
No ideas???
No ideas???
user error: Duplicate entry
I am gettin exactly the same behavior on an new install of CivicSpace 8.2 on Site5. Exactly when adding a node, incrementing the key on each attempt.
In my case the problem was
In my case the problem was fixed when I corrected the numerical values stored in the sequences table.