SQL error on Trac 0.12

[Daniel Westermann-Clark]

On Trac 0.12, an error results when moving a ticket:

ProgrammingError: operator does not exist: text = integer LINE 1: SELECT * FROM attachment WHERE id=17 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

This occurs on PostgreSQL databases, at least, due to its use of strict type checking.

A simple fix is to quote the value in the SQL statement. This works on PostgreSQL and SQLite databases.

​http://github.com/dwc/dwc-overlay/blob/master/dev-python/trac-ticket-mover/files/trac-ticket-mover-sql-quoting.patch