id summary reporter owner description type status priority component severity resolution keywords cc release 5608 trac-admin upgrade with PostgreSQL fails due, some specific SQL syntax required anonymous Steffen Hoffmann "I'm forced to do a --no-backup upgrade during the installation, since we don't use SQLite (we use PostgreSQL). The install then fails thusly: {{{ dev trac # trac-admin ./SV upgrade --no-backup Traceback (most recent call last): File ""/usr/bin/trac-admin"", line 8, in load_entry_point('Trac==0.11.2', 'console_scripts', 'trac-admin')() File ""//usr/lib/python2.5/site-packages/trac/admin/console.py"", line 1294, in run return admin.onecmd(command) File ""//usr/lib/python2.5/site-packages/trac/admin/console.py"", line 123, in onecmd rv = cmd.Cmd.onecmd(self, line) or 0 File ""/usr/lib/python2.5/cmd.py"", line 219, in onecmd return func(arg) File ""//usr/lib/python2.5/site-packages/trac/admin/console.py"", line 1144, in do_upgrade self.__env.upgrade(backup=do_backup) File ""//usr/lib/python2.5/site-packages/trac/env.py"", line 449, in upgrade participant.upgrade_environment(db) File ""build/bdist.linux-i686/egg/tracforms/tracdb.py"", line 137, in upgrade_environment File ""build/bdist.linux-i686/egg/tracforms/formdb.py"", line 208, in dbschema_2008_06_15_0000 File ""build/bdist.linux-i686/egg/tracforms/tracdb.py"", line 87, in __call__ File ""build/bdist.linux-i686/egg/tracforms/tracdb.py"", line 42, in execute psycopg2.ProgrammingError: syntax error at or near ""AUTOINCREMENT"" LINE 3: ... tracform_id INTEGER PRIMARY KEY AUTOINCREM... ^ }}} I tried download zip's of 0.2 and 0.3. Setting severity to 'blocker' since the plugin is completely uninstallable at this point." defect closed normal TracFormsPlugin blocker fixed PostgreSQL compatibility dicianno@… Peter 0.11