Installation / update trac.db does not work with sqlite

[hju]

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

[Ryan J Ollos]

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.