Edgewall Software

Changes between Initial Version and Version 2 of Ticket #6274


Ignore:
Timestamp:
Oct 31, 2007, 3:29:24 PM (17 years ago)
Author:
Christian Boos
Comment:

Looks like this uncovers a non-consistent usage of the rev. It should really be handled as a string at the db level, but apparently no other backend/binding complained so far when given an int…

What bindings are you using? If you're not using psycopg2 already, can you try using those?

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #6274

    • Property Keywords postgres added
    • Property Milestone → 0.11.1
    • Property Component browser → version control
    • Property Severity major → normal

  • Ticket #6274 – Description

    initial v2  
    22Created a fresh trac environment, pointed it to an existing SVN repos, and clicked 'Browse Source'.  Returned the error:
    33
    4 {{{Trac detected an internal error:
     4{{{
     5Trac detected an internal error:
    56
    67ProgrammingError: operator does not exist: text = integer
    78LINE 1: SELECT time,author,message FROM revision WHERE rev=1
    89                                                          ^
    9 HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.}}}
     10HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
     11}}}
    1012
    1113This query works fine: