Internal Error when submitting a review

Using Trac 1.0 via Apache (SSL) and PostgreSQL back-end, Python 2.7. Compiled source to python egg and installed as usual. Install seems to go well. However, when I try submit a peer review to an existing change set, I get a Trac error:

We are using SVN (multiple named repos). I'm not a Python expert by any means but I've looked at your source code and I believe the issue may be on or about line 93 in model.py where you are doing a db insert:

Based on the "index out of range" error I'm getting, the only piece of data in that SQL statement that is an integer type is the 'time' variable who's value is passed by 'when' . A few lines up you do this:

when = int(time.time() * self.EPOCH_MULTIPLIER)

Not sure if this is the issue or not but that's what I'm looking at right now.

This is due postgresql table schema problems, the codereview table is using a small integer data type... you can fix it with this:

alter table codereviewer alter COLUMN "time" type bigint;

Add Comment

This ticket has been modified since you started editing. You should review the
other modifications which have been appended above,
and any conflicts shown in the preview below.
You can nevertheless proceed and submit your changes if you wish so.