ProgrammingError: relation "subtickets" does not existLINE 1: SELECT parent, child FROM subtickets WHERE parent=1790 ^

[jared.bownds@…]

After migrating from SQLite to PostgreSQL, it seems certain plugins are not compatible. Any help or advise on resolving this particular error would be appreciated.

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'id': u'1790'}

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36

System Information

Trac	1.0
Trac	1.0
Babel	0.9.6
Genshi	0.6 (without speedups)
GIT	1.7.1
mod_wsgi	3.2 (WSGIProcessGroup trac-dev WSGIApplicationGroup trac-dev.agraquest.int|)
psycopg2	2.0.13
Python	2.6.6 (r266:84292, Apr 11 2011, 15:50:32) [GCC 4.4.4 20100726 (Red Hat 4.4.4-13)]
Python	2.6.6 (r266:84292, Apr 11 2011, 15:50:32) [GCC 4.4.4 20100726 (Red Hat 4.4.4-13)]
pytz	2010h
pytz	2010h
setuptools	0.6c11
setuptools	0.6c11
Subversion	1.6.15 (r1038135)
jQuery	1.7.2

Enabled Plugins

AutocompleteUsers	0.4.2dev
BlackMagicTicketTweaks	0.12r1
BreadCrumbsNav	0.2
ComponentDependencyPlugin	0.1
ContextChrome	0.3
graphviz	0.7.7dev
ReadonlySignedTickets	N/A
ScreenshotPaste	0.1.1
TicketSidebarProvider	0.0
TicketValidator	0.2dev
trac-MultiRepoSearchPlugin	0.6
trac-WorkflowNotificationPlugin	0.5
TracAccountManager	0.4.3
TracAnnouncer	1.0dev
TracAttachmentNotifyPlugin	1.0.1
TracAutoWikify	0.2dev
TracCustomFieldAdmin	0.2.8-r12166
TracDateField	2.0.0dev-r12118
TracDragDrop	0.12.0.11
TracHoursPlugin	0.6.0dev
TracHtmlNotificationPlugin	0.12.0.1
TracMigratePlugin	0.12.0.3
TracReportManager	0.1
TracSubTicketsPlugin	0.2.0.dev-20130908

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py", line 224, in dispatch
    self._post_process_request(req, *resp)
  File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py", line 338, in _post_process_request
    resp = f.post_process_request(req, *resp)
  File "build/bdist.linux-x86_64/egg/tracsubtickets/web_ui.py", line 73, in post_process_request
    children = self.get_children(ticket.id)
  File "build/bdist.linux-x86_64/egg/tracsubtickets/web_ui.py", line 107, in get_children
    (parent_id, ))
  File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: relation "subtickets" does not exist
LINE 1: SELECT parent, child FROM subtickets WHERE parent=1790
                                  ^

[Jun Omae]

PluginIssue (​th:SubTicketsPlugin).

[Jared Bownds <jared.bownds@…>]

Woops, from now on I will reach out and create an issue for each respective plugin. Thanks.