Modify

Opened 16 years ago

Closed 15 years ago

Last modified 14 years ago

#4356 closed defect (fixed)

upgrade fix

Reported by: Shane Caraveo Owned by: Colin Guthrie
Priority: normal Component: WorkLogPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

an initial install failed during the "upgrade" process. I've refactored the database code a bit, and now I can install the plugin. The primary fix is adding the rollback if the first query in do_db_upgrade failed. This work was done with postgres 8.3.

Attachments (1)

worklog-upgrade.patch (3.5 KB) - added by Shane Caraveo 16 years ago.

Download all attachments as: .zip

Change History (4)

Changed 16 years ago by Shane Caraveo

Attachment: worklog-upgrade.patch added

comment:1 Changed 15 years ago by Colin Guthrie

Resolution: fixed
Status: newclosed

(In [6471]) Fix initial installation on some databases due to general bad practice.

Fixes #4356 by applying patch from mixedpuppy. Thanks and sorry for the (rediculous) delay.

comment:2 Changed 14 years ago by anonymous

The upgrade after first installaion still doesn't seem to work. Executing those queries manually seem to get it working:

CREATE TABLE work_log (
                               worker     TEXT,
                               ticket     INTEGER,
                               lastchange INTEGER,
                               starttime  INTEGER,
                               endtime    INTEGER,
                               comment    TEXT
                               );
UPDATE system SET value=3 WHERE name='WorklogPlugin_Db_Version';

comment:3 in reply to:  2 Changed 14 years ago by Ryan J Ollos

Replying to anonymous:

The upgrade after first installation still doesn't seem to work.

Some information about your Trac installation would be necessary to work on this issues.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Colin Guthrie.
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.