upgrade fix

[Shane Caraveo]

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.

[Colin Guthrie]

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

[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';

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