Opened 9 years ago

Closed 9 years ago

Last modified 7 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


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

Download all attachments as: .zip

Change History (4)

Changed 9 years ago by Shane Caraveo

Attachment: worklog-upgrade.patch added

comment:1 Changed 9 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 7 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 7 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
as closed The owner will remain Colin Guthrie.
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.