Opened 7 years ago

Closed 10 months ago

#5401 closed defect (fixed)

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

Reported by: filthycoder Owned by: olemis
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 7 years ago.

Download all attachments as: .zip

Change History (6)

comment:1 Changed 7 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 7 years ago by filthycoder

  • Owner changed from mikechml to filthycoder
  • Status changed from new to assigned

comment:3 Changed 5 years ago by andersm

  • Owner changed from filthycoder to andersm
  • Status changed from assigned to new

comment:4 Changed 4 years ago by olemis

  • Owner changed from andersm to olemis

comment:5 Changed 10 months ago by Cinc-th

  • Resolution set to fixed
  • Status changed from new to closed

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

Add Comment

Modify Ticket

as closed The owner will remain olemis.
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.