| 156 | The latest version of trac on Debian/Lenny is not Postgresql-8.3 compatible. To get it to work, apply this patch with |
| 157 | |
| 158 | {{{ |
| 159 | cd /usr/share/python-support/trac/ && patch -p0 < trac_cache.patch |
| 160 | }}} |
| 161 | |
| 162 | {{{ |
| 163 | --- trac/versioncontrol/cache.orig 2008-02-04 00:13:50.000000000 +0100 |
| 164 | +++ trac/versioncontrol/cache.py 2008-02-04 00:12:04.000000000 +0100 |
| 165 | @@ -244,7 +244,7 @@ |
| 166 | self.authz = authz |
| 167 | cursor = self.db.cursor() |
| 168 | cursor.execute("SELECT time,author,message FROM revision " |
| 169 | - "WHERE rev=%s", (rev,)) |
| 170 | + "WHERE rev=%s", (str(rev),)) |
| 171 | row = cursor.fetchone() |
| 172 | if row: |
| 173 | date, author, message = row |
| 174 | @@ -256,7 +256,7 @@ |
| 175 | cursor = self.db.cursor() |
| 176 | cursor.execute("SELECT path,node_type,change_type,base_path,base_rev " |
| 177 | "FROM node_change WHERE rev=%s " |
| 178 | - "ORDER BY path", (self.rev,)) |
| 179 | + "ORDER BY path", (str(self.rev),)) |
| 180 | for path, kind, change, base_path, base_rev in cursor: |
| 181 | if not self.authz.has_permission(path): |
| 182 | # FIXME: what about the base_path? |
| 183 | }}} |