ProgrammingError: relation "codereviews" does not existСТРОКА 1: ...iew, Author, Status, DateCreate, Name, Notes FROM CodeReview... ^

[olexander314@…]

How to Reproduce

While doing a GET operation on /peerReviewMain, Trac issued an internal error.

Download zip, build from 'trunk' directory with python setup.py bdist_egg command, then call trac /path/to/ upgrade and restart apache.

Request parameters:

{}

User agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Firefox/24.0

System Information

Trac	1.0.2dev
Babel	0.9.6
Docutils	0.10
Genshi	0.8dev (with speedups)
GIT	1.8.1.5
Mercurial	2.5.4
mod_wsgi	3.4 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})
psycopg2	2.4.6
Pygments	1.5
Python	2.7.3 (default, Mar 20 2013, 11:12:52) [GCC 4.6.3]
pytz	2012c
RPC	1.1.2
setuptools	0.6c11
jQuery	1.7.2

Enabled Plugins

AdvancedTicketWorkflowPlugin	0.11dev
AutocompleteUsers	0.4.2dev
BlockDiagPlugin	0.5.1
graphviz	0.7.5dev-r11777
GroupTicketFields	0.0.1dev
NavAdd	0.1
nevernotifyupdaterplugin	0.1.4
PlantUML	2.0dev-r12389
Roadmap-Plugin	0.4.1
Trac-jsGantt	0.10-r12440
TracAccountManager	0.3.2
TracCodeReview	2.2dev
TracHTTPAuth	1.1
TracKeywordSuggest	0.5.0dev
TracMasterTickets	3.0.3
TracMercurial	1.0.0.3dev
TracNewsFlash	1.0.1
TracPoll	0.3.0dev
TracSubTicketsPlugin	0.2.0.dev-20130218
TracXMLRPC	1.1.2
WikiCalendarMacro	2.0.0dev

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/codereview/peerReviewMain.py", line 76, in process_request
    codeReviewArray = dbBack.getMyCodeReviews(util.get_reporter_id(req))
  File "build/bdist.linux-x86_64/egg/codereview/dbBackend.py", line 38, in getMyCodeReviews
    return self.execCodeReviewQuery(query, False)
  File "build/bdist.linux-x86_64/egg/codereview/dbBackend.py", line 178, in execCodeReviewQuery
    cursor.execute(query)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
ProgrammingError: relation "codereviews" does not exist
СТРОКА 1: ...iew, Author, Status, DateCreate, Name, Notes FROM CodeReview...
                                                               ^

[Jun Omae]

A duplicate of #10812.

[Ryan J Ollos]

We'll need to quote the CamelCased table names, as described in ​SO:7262795, or change them to lowercase. We should probably change them to lowercase. The patch is simple enough, but we'll need to also write an upgrade step.

I might find time tomorrow morning to make the required changes.

peerreviewplugin/trunk/codereview/db_default.py

@@ -12 +12 @@
 
 
 # Version of Code Review schema
-version = 1
+version = 2
 
 #The tables for the Code Review Plugin
 tables = [
-    Table('CodeReviews', key='IDReview')[
+    Table('codereviews', key='IDReview')[
         Column('IDReview', auto_increment=True, type='int'),
         Column('Author'),
         Column('Status'),
@@ -24 +24 @@
         Column('Name'),
         Column('Notes'),
     ],
-    Table('Reviewers', key=('IDReview', 'Reviewer'))[
+    Table('reviewers', key=('IDReview', 'Reviewer'))[
         Column('IDReview', type='int'),
         Column('Reviewer'),
         Column('Status', type='int'),
         Column('Vote', type='int'),
     ],
-    Table('ReviewFiles', key='IDFile')[
+    Table('reviewfiles', key='IDFile')[
         Column('IDFile', auto_increment=True, type='int'),
         Column('IDReview', type='int'),
         Column('Path'),
@@ -38 +38 @@
         Column('LineEnd', type='int'),
         Column('Version', type='int'),
     ],
-    Table('ReviewComments', key='IDComment')[
+    Table('reviewcomments', key='IDComment')[
         Column('IDComment', auto_increment=True, type='int'),
         Column('IDFile', type='int'),
         Column('IDParent', type='int'),

[Ryan J Ollos]

Replying to jun66j5:

A duplicate of #10812.

Oh, thanks. I looked but didn't spot that one.