By dcine on

I translate my drupal 6 installation (Pressflow version 6.26) of a server with php 5.2 to other with php 5.3.
Since then every time I edit a node I get the following error:

User warning: Duplicate entry '15738 'for key' PRIMARY 'query: INSERT INTO private (nid, private) VALUES (15738, 0) in _db_query () (line 169 of / usr/home/em8SouHuQnnG/web/includes/database. mysqli.inc).

I've looked at several posts that seem to speak and deal with the issue, but have not found the solution.

Anybody can help me? (Please)

Barry Collins

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

check the private table is there two rows for 15738? if so, back up the table, delete one of the rows and test.

dcine’s picture

dcine commented

Ok, thanks for your help "VM", I checked the table "private" and has only one row for the nid 15738
My site is online and the users can see the errors each time they edit a node.
Could you help me (please!)?

Barry Collins

Barry Collins
Blog: http://www.los5000dedosdeldoctort.com - Web: http://www.dcine.org

vm’s picture

vm commented

is auto_increment set on the private table?

dcine’s picture

dcine commented

I have looked with Phpmyadmin and does not appear in the table autoincrement private (in Phpmyadmin in options) but my knowledge of this tool is very poor…
If not active do I have to activate it?

Barry Collins

Barry Collins
Blog: http://www.los5000dedosdeldoctort.com - Web: http://www.dcine.org

vm’s picture

vm commented

first result

dcine’s picture

dcine commented

But in my version of Phpmyadmin (3.5.2.1) not so easy to watch this option…
I search in my "private" table and i think that te Autoincrement is not active.
Could you help me (please)?

Barry Collins

Barry Collins
Blog: http://www.los5000dedosdeldoctort.com - Web: http://www.dcine.org

vm’s picture

vm commented

Then you need to do a little bit of your own legwork and perhaps seek out a phpmyadmin support group. (please)