Modify

Opened 8 years ago

Closed 14 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 Lang
Priority: high Component: PeerReviewPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.11

Description

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 8 years ago.

Download all attachments as: .zip

Change History (6)

Changed 8 years ago by filthycoder

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

Owner: changed from mikechml to filthycoder
Status: newassigned

comment:3 Changed 6 years ago by Marc

Owner: changed from filthycoder to Marc
Status: assignednew

comment:4 Changed 4 years ago by Olemis Lang

Owner: changed from Marc to Olemis Lang

comment:5 Changed 14 months 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
Action
as closed The owner will remain Olemis Lang.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.