Reg : Restore issue with new ubuntu version

[Kalings Rajan]

I installed trac and configured in new ubuntu system.I restore the file backups to new trac location.

After restart its showing plugin error, Kindly please Support it. error message below,

Please check screenshot also,

Front login Page showing like this::

Oops…

Trac detected an internal error:OperationalError: no such column: ipnr

This is probably a local installation issue.

Found a bug in Trac?

If you think this should work and you can reproduce the problem, you should consider creating a bug report.

Note that the following plugins seem to be involved: trac.web.main, trac.wiki.web-ui, trac.attachment, trac.db.api, trac.db.sqlite-backend Please report this issue to the plugin maintainer.

Before you do that, though, please first try searching for similar issues, as it is quite likely that this problem has been reported before. For questions about installation and configuration of Trac or its plugins, please try the mailing list instead of creating a ticket.

Python traceback

Most recent call last:

• File "/usr/lib/python2.7/dist-packages/trac/web/main.py", line 613, in _dispatch_request
• File "/usr/lib/python2.7/dist-packages/trac/web/main.py", line 253, in dispatch
• File "/usr/lib/python2.7/dist-packages/trac/wiki/web_ui.py", line 191, in process_request
  Code fragment:Line186
  format = req.args.get('format')187
  if format:188
  Mimeview(self.env).send_converted(req, 'text/x-trac-wiki',189
  versioned_page.text,190
  format, versioned_page.name)191
  return self._render_view(req, versioned_page)192
   193
  # ITemplateProvider methods194
   195
  def get_htdocs_dirs(self):196
  return []
  Local variables:NameValueaction
  'view'format
  Noneold_version
  Nonepage
  <WikiPage u'TracModWSGI@2'>pagename
  u'TracModWSGI'req
  <RequestWithSession "GET '/wiki/TracModWSGI'">self
  <Component trac.wiki.web_ui.WikiModule>version
  Noneversioned_page
  <WikiPage u'TracModWSGI@2'>
• File "/usr/lib/python2.7/dist-packages/trac/wiki/web_ui.py", line 725, in _render_view
• File "/usr/lib/python2.7/dist-packages/trac/attachment.py", line 264, in attachment_data
  Code fragment:Line259
   260
  def attachment_data(self, context):261
  """Return a data dictionary describing the list of viewable262
  attachments in the current context.263
  """264
  attachments = self.viewable_attachments(context)265
  parent = context.resource266
  total_size = sum(attachment.size for attachment in attachments)267
  new_att = parent.child(self.realm)268
  return {'attach_href': get_resource_url(self.env, new_att,269
  context.href),
  Local variables:NameValuecontext
  <RenderingContext <Resource u'wiki:TracModWSGI'>>self
  <Component trac.attachment.AttachmentModule>
• File "/usr/lib/python2.7/dist-packages/trac/attachment.py", line 255, in viewable_attachments
• File "/usr/lib/python2.7/dist-packages/trac/attachment.py", line 885, in select
• File "/usr/lib/python2.7/dist-packages/trac/db/api.py", line 122, in execute
  Code fragment:Line117
  self.dbmgr = DatabaseManager(env)118
   119
  def execute(self, query, params=None):120
  """Shortcut for directly executing a query."""121
  with self as db:122
  return db.execute(query, params)123
   124
  __call__ = execute125
   126
  def executemany(self, query, params=None):127
  """Shortcut for directly calling "executemany" on a query."""
  Local variables:NameValuedb
  <trac.db.util.ConnectionWrapper object at 0x7f6961cffbe0>params
  ('wiki', u'TracModWSGI')query
  '\n SELECT filename, description, size, time, author, ...self
  <trac.db.api.QueryContextManager object at 0x7f6961dcc450>
• File "/usr/lib/python2.7/dist-packages/trac/db/util.py", line 128, in execute
• File "/usr/lib/python2.7/dist-packages/trac/db/util.py", line 72, in execute
• File "/usr/lib/python2.7/dist-packages/trac/db/sqlite_backend.py", line 88, in execute
• File "/usr/lib/python2.7/dist-packages/trac/db/sqlite_backend.py", line 64, in execute
• File "/usr/lib/python2.7/dist-packages/trac/db/sqlite_backend.py", line 55, in _rollback_on_error

System information

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36

PackageVersionTrac
1.2Babel
2.4.0Docutils
0.14Genshi
0.7 (with speedups)mod_python
3.3.1Pygments
2.2.0pysqlite
2.6.0Python
2.7.17 (default, Feb 27 2021, 15:10:58) [GCC 7.5.0]pytz
2018.3setuptools
39.0.1SQLite
3.22.0jQuery
3.2.1jQuery UI
1.12.1jQuery Timepicker
1.2

Installed pluginsNameVersionLocationtrac.about
N/A
/usr/lib/python2.7/dist-packages/trac/about.pyctrac.admin.api
N/A
/usr/lib/python2.7/dist-packages/trac/admin/api.pyctrac.admin.console
N/A
/usr/lib/python2.7/dist-packages/trac/admin/console.pyctrac.admin.web-ui
N/A
/usr/lib/python2.7/dist-packages/trac/admin/web_ui.pyctrac.attachment
N/A
/usr/lib/python2.7/dist-packages/trac/attachment.pyctrac.cache
N/A
/usr/lib/python2.7/dist-packages/trac/cache.pyctrac.config
N/A
/usr/lib/python2.7/dist-packages/trac/config.pyctrac.db.api
N/A
/usr/lib/python2.7/dist-packages/trac/db/api.pyctrac.db.sqlite-backend
N/A
/usr/lib/python2.7/dist-packages/trac/db/sqlite_backend.pyctrac.env
N/A
/usr/lib/python2.7/dist-packages/trac/env.pyctrac.mimeview.api
N/A
/usr/lib/python2.7/dist-packages/trac/mimeview/api.pyctrac.mimeview.patch
N/A
/usr/lib/python2.7/dist-packages/trac/mimeview/patch.pyctrac.mimeview.pygments
N/A
/usr/lib/python2.7/dist-packages/trac/mimeview/pygments.pyctrac.mimeview.rst
N/A
/usr/lib/python2.7/dist-packages/trac/mimeview/rst.pyctrac.notification.api
N/A
/usr/lib/python2.7/dist-packages/trac/notification/api.pyctrac.notification.mail
N/A
/usr/lib/python2.7/dist-packages/trac/notification/mail.pyctrac.notification.prefs
N/A
/usr/lib/python2.7/dist-packages/trac/notification/prefs.pyctrac.perm
N/A
/usr/lib/python2.7/dist-packages/trac/perm.pyctrac.prefs.web-ui
N/A
/usr/lib/python2.7/dist-packages/trac/prefs/web_ui.pyctrac.resource
N/A
/usr/lib/python2.7/dist-packages/trac/resource.pyctrac.search.web-ui
N/A
/usr/lib/python2.7/dist-packages/trac/search/web_ui.pyctrac.ticket.admin
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/admin.pyctrac.ticket.api
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/api.pyctrac.ticket.batch
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/batch.pyctrac.ticket.default-workflow
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/default_workflow.pyctrac.ticket.model
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/model.pyctrac.ticket.notification
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/notification.pyctrac.ticket.query
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/query.pyctrac.ticket.report
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/report.pyctrac.ticket.roadmap
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/roadmap.pyctrac.ticket.web-ui
N/A
/usr/lib/python2.7/dist-packages/trac/ticket/web_ui.pyctrac.timeline.web-ui
N/A
/usr/lib/python2.7/dist-packages/trac/timeline/web_ui.pyctrac.versioncontrol.admin
N/A
/usr/lib/python2.7/dist-packages/trac/versioncontrol/admin.pyctrac.versioncontrol.api
N/A
/usr/lib/python2.7/dist-packages/trac/versioncontrol/api.pyctrac.versioncontrol.svn-authz
N/A
/usr/lib/python2.7/dist-packages/trac/versioncontrol/svn_authz.pyctrac.versioncontrol.web-ui.browser
N/A
/usr/lib/python2.7/dist-packages/trac/versioncontrol/web_ui/browser.pyctrac.versioncontrol.web-ui.changeset
N/A
/usr/lib/python2.7/dist-packages/trac/versioncontrol/web_ui/changeset.pyctrac.versioncontrol.web-ui.log
N/A
/usr/lib/python2.7/dist-packages/trac/versioncontrol/web_ui/log.pyctrac.web.auth
N/A
/usr/lib/python2.7/dist-packages/trac/web/auth.pyctrac.web.chrome
N/A
/usr/lib/python2.7/dist-packages/trac/web/chrome.pyctrac.web.main
N/A
/usr/lib/python2.7/dist-packages/trac/web/main.pyctrac.web.session
N/A
/usr/lib/python2.7/dist-packages/trac/web/session.pyctrac.wiki.admin
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/admin.pyctrac.wiki.api
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/api.pyctrac.wiki.intertrac
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/intertrac.pyctrac.wiki.interwiki
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/interwiki.pyctrac.wiki.macros
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/macros.pyctrac.wiki.parser
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/parser.pyctrac.wiki.web-api
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/web_api.pyctrac.wiki.web-ui
N/A
/usr/lib/python2.7/dist-packages/trac/wiki/web_ui.pyc

[RjOllos]

On Thursday, September 16, 2021 at 10:08:10 AM UTC-7 kal...@gmail.com wrote:

I installed trac and configured in new ubuntu system.I restore the file backups to new trac location.

After restart its showing plugin error, Kindly please Support it. error message below,

It seems that your old Trac version must have been newer than the version 1.2 that you have installed into. There's no standard mechanism to downgrade a Trac environment, so you should use the same or newer version that you had in your old installation.

[Kalings Rajan]

Hi

Thank you its working now.