Project

General

Profile

Actions
Copy link

Defect #6044

closed

duplicate key errors/wrong sequence counters after 0.8.7 -> 1.0 upgrade

Added by Marc Mengel over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
2010-08-05
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

During and after doing an upgrade from 0.8.7 to 1.0, I was getting
duplicate key errors, because many of the sequence counters were
somehow wrong (in particular
wiki_content_versions
custom_values
had this problem).

I ran the attached sql code to "fix" all the id sequences; but this should probably be done in the db:migrate code somwhere.

Files

fix_sequences.sql (2.8 KB) fix_sequences.sql sql code to update all the sequence counters to max(id)+1 Marc Mengel, 2010-08-05 18:25
Actions
Copy link

Also available in: Atom PDF