Modify

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

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

Action
as closed The owner will remain coling.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.