On Wed, Aug 6, 2014 at 9:35 AM, Jared Bownds <[email protected]> wrote:
Hi everyone,
>
> I'm reaching out for advise on how to handle recent errors that have come
> up since attempting to migrate from SQLite to PostgreSQL.
>
> First has to do with the sub-tickets plugin. Since upgrading, no tickets
> can be accessed due to the error outlined below.
>
> ==== 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) ` [[br]]
> `[GCC 4.4.4 20100726 (Red Hat 4.4.4-13)]` ||
> || '''`Python`''' || `2.6.6 (r266:84292, Apr 11 2011, 15:50:32) ` [[br]]
> `[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
> ^
>
> }}}
>
Check if there is a table subtickets in the database, and if not, then
something went wrong in your migration.
Why did you decide to migrate to PostgreSQL?
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.
