id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
7272,Installation / update trac.db does not work with sqlite,hju,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",defect,closed,normal,ClientsPlugin,normal,fixed,,,0.11