id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 7441,sqlite2pg dies with an SQL error,Joshua Kugler,John Hampton,"When trying to run sqlite2pg like so: `./sqlite2pg -e /path/to/trac -p postgres://trac:password@localhost/trac` I'm getting this error: {{{ Traceback (most recent call last): File ""./sqlite2pg"", line 335, in sys.exit(main(sys.argv[1:])) File ""./sqlite2pg"", line 331, in main Main(opts) File ""./sqlite2pg"", line 250, in Main rc = tmigration.migrateTable(tname) or rc File ""./sqlite2pg"", line 72, in migrateTable rc = self.default_copy(table) File ""./sqlite2pg"", line 93, in default_copy pgcur.execute(insert_into, row) File ""/usr/lib/python2.6/dist-packages/trac/db/util.py"", line 64, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""/usr/lib/python2.6/dist-packages/trac/db/util.py"", line 64, in execute return self.cursor.execute(sql_escape_percent(sql), args) psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block }}} According to question ""I receive the error current transaction is aborted, commands ignored until end of transaction block and can’t do anything else!"" at http://initd.org/psycopg/docs/faq.html it does seem be an error in the SQL queries issued by sqlite2pg. This is with Trac 0.11.7 on Ubuntu 10.04.",defect,closed,high,SqliteToPgScript,blocker,wontfix,,,0.11