My D7 site is working I have about 5000 nodes. I am down to 18 pending updates left but I get this error. I deleted all node revisions using this module node_revision_delete. I don't know what to do. I tried to delete vid 7190 from the table system_update. But it just comes back with another vid duplicate

Update #7061

Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7190' for key 'PRIMARY': INSERT INTO {system_update_7061} (vid) SELECT DISTINCT u.vid AS vid FROM {upload} u; Array ( ) in system_update_7061() (line 2804 of C:\xampp\htdocs\drupal222\modules\system\system.install).

Comments

leisurman’s picture

Fixed but I lost a couple of nodes.
I went into the node_revisions table and delete the duplicate titles and vids