PeerReview fails after install

[erne.castro@…]

After installing PeerReview plugin, both globally or local to a particular Trac environment, I can't use the plugin.

One clue: After installing, it didn't make me upgrade the environment.

The traceback is:

Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/codereview/peerReviewMain.py", line 75, in process_request
  File "build/bdist.linux-x86_64/egg/codereview/dbBackend.py", line 38, in getMyCodeReviews
  File "build/bdist.linux-x86_64/egg/codereview/dbBackend.py", line 174, in execCodeReviewQuery
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
ProgrammingError: relation "codereviews" does not exist

[anonymous]

I have actually the same error:

relation "codereviews" does not exist

I did get a notification to upgrade the environment, this error was shown after the environment was upgraded.

Trac. 0.11.3

[Daniel Ziegenberg]

Same to me.
Trac 0.12dev

[Geoff Jacobs]

presume this is related to #4698 have the same problem with 0.11

[Peter]

Let me guess: this bug only manifests itself on Postgres backend. PeerReview plugin uses uppercase letters in it's tables and columns names, and for this to work on PG all names have to be double-quoted. Solution is to manually change all table & field names in DB to lowercase

[anonymous]

I have the same problem, but when I upgrade environment I get a message:

Database is up to date, no upgrade necessary.

But Trac doesn't work and says that I have to upgrade environment. What to do?

[anonymous]

Replying to goldman:

Solution is to manually change all table & field names in DB to lowercase

Not manually though, see ​here.

Just remember not to use '\r' if you're running proper OS with '\n'-lineends

Nasty bug, though.

[anonymous]

Another alternative is to change db_default.py prior to compiling / installing so each of the table and column names are lowercase.

[Ryan J Ollos]

This issue seems to be fixed on the trunk since proper use is now being made of the Trac API. Please reopen if you continue to have trouble with the latest trunk version.

[Ryan J Ollos]

#4673 could be related.