id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 9698,"invalid input syntax for integer: ""timeline.authors""",zoltan@…,John Hampton,"Hi, I tried to convert my trac/sqlite database into PostgreSQL, but there is an error: {{{ $ ./sqlite2pg -e /var/trac -p 'postgres://trac:trac@localhost/trac' Exception AssertionError: AssertionError() in > ignored 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/lib64/python2.7/site-packages/Trac-0.13dev_r10849-py2.7.egg/trac/db/util.py"", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) psycopg2.DataError: invalid input syntax for integer: ""timeline.authors"" LINE 1: ...INTO session VALUES ('c86170f57c3062a3d0ba73b3',0,'timeline.... ^ }}} I am using PostgreSQL 9.1.1 and psycopg 2.4.2 on Gentoo Linux. I got an almost empty database with the following number of entries in the tables: * auth_cookie - 1 * component - 2 * enum - 13 * milestone - 4 * permission - 24 * report - 8 * system - 3 * version - 2 Thanks for any help in advance!",defect,closed,normal,SqliteToPgScript,normal,invalid,,,0.12