Accidentally installed the aphe version on a live site and immediately got the following errors on the modules page and when importing images.
This error came when i tried to upload an image. The others begann the same way with "Duplicate entry"

Please any help!

* user warning: Duplicate entry '30-30' for key 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, sticky) VALUES (30, 30, 'Brandenburgi värava ees', 'image', 1, 1, 1210072157, 1210072157, 2, 1, 0) in /home/credopr/public_html/includes/database.mysql.inc on line 172.
* user warning: Duplicate entry '30' for key 1 query: INSERT INTO node_revisions (nid, vid, title, body, teaser, timestamp, uid, format, log) VALUES (30, 30, 'Brandenburgi värava ees', 'Brandenburgi värava ees', 'Brandenburgi värava ees', 1210072157, 1, 1, '') in /home/credopr/public_html/includes/database.mysql.inc on line 172.

Comments

hannesh’s picture

hannesh commented
Status: Fixed » Active

now i get the error whenever i add a node.
The problem is, that i have almost no php or mysql skills and the site is basically disabled.

hannesh’s picture

hannesh commented
Priority: Normal » Critical

well i trunked the old tables and started new with them. but something was wrong with this thing.

Hetta’s picture

Hetta commented
Status: Active » Fixed

It doesn't seem to be an image problem:
http://www.google.com/search?q=duplicate+entry+includes/database.mysql.i...(nid,+vid,+title,+type%22&filter=0

gives the sequence table as the cause of your troble. Update that and things should be hunky dory:
http://drupal.org/node/140102
http://drupal.org/node/240692
http://drupal.org/node/97801
http://drupal.org/node/237411

hannesh’s picture

hannesh commented
Status: Active » Fixed

thanks for the reply! got it fixed.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.