Modify ↓

Opened 15 years ago

Closed 9 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

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

Download all attachments as: .zip

Change History (6)

Changed 15 years ago by filthycoder

Attachment: patch_upgrade_mech_against_2.1_toddlerdev_r5257.diff​ added

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

Owner: changed from mikechml to filthycoder
Status: new → assigned

comment:3 Changed 13 years ago by Marc

Owner: changed from filthycoder to Marc
Status: assigned → new

comment:4 Changed 12 years ago by Olemis Lang

Owner: changed from Marc to Olemis Lang

comment:5 Changed 9 years ago by Cinc-th

Resolution: → fixed
Status: new → 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



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.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.