After checking the postgres DB after the migration, there is no table
called subtickets. Perhaps the migration script is not equipped to include
this type of table?
On Wednesday, August 6, 2014 1:01:30 PM UTC-7, RjOllos wrote:
>
> On Wed, Aug 6, 2014 at 9:35 AM, Jared Bownds > 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 trac-users+unsubscr...@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at http://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.
