Modify

Opened 7 years ago

Closed 5 years ago

#7272 closed defect (fixed)

Installation / update trac.db does not work with sqlite

Reported by: hju Owned by: Colin Guthrie
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 5 years ago by Ryan J Ollos

Resolution: fixed
Status: newclosed

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Colin Guthrie.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.