Opened 6 years ago

Closed 5 years ago

Last modified 4 years ago

#4356 closed defect (fixed)

upgrade fix

Reported by: mixedpuppy Owned by: coling
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 mixedpuppy 6 years ago.

Download all attachments as: .zip

Change History (4)

Changed 6 years ago by mixedpuppy

comment:1 Changed 5 years ago by coling

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

(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 follow-up: Changed 4 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 4 years ago by rjollos

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.

Add Comment

Modify Ticket

as closed .
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.