Installation / update trac.db does not work with sqlite
|Reported by:||hju||Owned by:||coling|
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