Opened 4 years ago

Closed 2 years ago

#7272 closed defect (fixed)

Installation / update trac.db does not work with sqlite

Reported by: hju Owned by: coling
Priority: normal Component: ClientsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11


The Update-process ´do_db_upgrade´ ( is not running with sqlite

            if self.db_installed_version < 6:
                print 'Updating clients table (v6)'
                cursor.execute('ALTER TABLE client '
                               'CHANGE COLUMN default_rate default_rate DECIMAL(10,2)')

The ALTER TABLE statement in SQLITE does not understand CHANGE COLUMN.
The update-process indicates no error. The error is only found in trag.log

 * Upgrading db
Creating client table
Updating clients table (v3)
Updating clients table (v4)
Updating clients table (v5)
Updating clients table (v6)
 * Upgrading reports
Done Upgrading
Upgrade done.

I managed the installation by creating the table clients with the column default_rate in format 10.2 and setting clients_plugin_version to 6 manualy

Attachments (0)

Change History (1)

comment:1 Changed 2 years ago by rjollos

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

This seems to have been fixed in [9476]. Please test and report back if you can, though be aware of #10253, in which Trac 0.11 compatibility of the trunk will be restored.

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.