Posted by dcine on November 11, 2012 at 7:23pm
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
Comments
=-=
check the private table is there two rows for 15738? if so, back up the table, delete one of the rows and test.
The private table has only one row for 15738
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
=-=
is auto_increment set on the private table?
I think not
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
=-=
first result
Yes I know how to search results in google…
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
=-=
Then you need to do a little bit of your own legwork and perhaps seek out a phpmyadmin support group. (please)