Ticket #4356 (closed defect: fixed)

Opened 4 years ago

Last modified 2 years ago

upgrade fix

Reported by: mixedpuppy Assigned to: coling
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

worklog-upgrade.patch (3.5 kB) - added by mixedpuppy on 01/01/09 17:57:53.

Change History

01/01/09 17:57:53 changed by mixedpuppy

  • attachment worklog-upgrade.patch added.

09/02/09 11:35:13 changed by coling

  • status changed from new to closed.
  • resolution set to fixed.

(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.

(follow-up: ↓ 3 ) 01/13/11 18:49:16 changed 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';

(in reply to: ↑ 2 ) 01/20/11 06:08:14 changed 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/Change #4356 (upgrade fix)




Change Properties
Action