id summary reporter owner description type status priority component severity resolution keywords cc release 7925 trac-admin upgrade fails on postgresql/sqlite anonymous Colin Guthrie "Failing line is: ERROR: WorklogPlugin Exception: ERROR: syntax error at or near ""CHANGE"" LINE 1: ALTER TABLE client CHANGE COLUMN default_rate default_rate DECIMAL(10,2) In api.py I did a quick fix, commented out the V6 update, and changed from integer to decimal(10,2) cursor.execute('CREATE TABLE client (' 'name TEXT,' 'description TEXT,' 'default_rate DECIMAL(10,2),' 'currency TEXT' ')') cursor.execute('INSERT INTO client SELECT name, description, default_rate, currency FROM client_tmp') cursor.execute('DROP TABLE client_tmp') #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)') " defect closed normal ClientsPlugin normal fixed 0.11