Opened 10 years ago

Closed 3 years ago

#5401 closed defect (fixed)

peer review database upgrade deletes all data by dropping and reinstalling all tables

Reported by: filthycoder Owned by: Olemis Lang
Priority: high Component: PeerReviewPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.11


Creating a new database version and upgrading using trac-admin upgrad deletes all reviews, because all review plugin tables get dropped.

Fix attached

Attachments (1)

patch_upgrade_mech_against_2.1_toddlerdev_r5257.diff (1.9 KB) - added by filthycoder 10 years ago.

Download all attachments as: .zip

Change History (6)

comment:1 Changed 10 years ago by filthycoder

the attached patch also adds the Trac database upgrade machanism via files in subdirectory upgrades to allow incremental DB upgrades after installing an updated version of PeerReviewPlugin

comment:2 Changed 10 years ago by filthycoder

Owner: changed from mikechml to filthycoder
Status: newassigned

comment:3 Changed 8 years ago by Marc

Owner: changed from filthycoder to Marc
Status: assignednew

comment:4 Changed 6 years ago by Olemis Lang

Owner: changed from Marc to Olemis Lang

comment:5 Changed 3 years ago by Cinc-th

Resolution: fixed
Status: newclosed

In 15192:

Upgrade for database schema to version 2.

  • all table and column names are lower case now
  • table names are prepended by peer_ to prevent name clashes
  • added some columns for future features
  • uses Trac upgrade framework
  • table contents is properly migrated

Note that the upgrade is only tested with SQLite.

Refs #10812
Refs #5395
Fixes #5808
Fixes #5401

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Olemis Lang.
The resolution will be deleted.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.