Modify

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

Description

The Update-process ´do_db_upgrade´ (api.py) 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

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.