Edgewall Software

Opened 13 years ago

Closed 13 years ago

#8129 closed defect (invalid)

trac-admin upgrade from 0.9.6 to 0.11.3 fails

Reported by: marco.weber@… Owned by:
Priority: normal Milestone:
Component: admin/console Version: none
Severity: normal Keywords: trac-admin upgrade
Cc: marco.weber@… Branch:
Release Notes:
API Changes:
Internal Changes:


My Server is a Ubuntu Linux 8.04. I've installed trac 0.11 with easy_install.
Newly created trac environments do work.
But my old trac environments ( from a 0.9.6 Trac ) don't work with trac 0.11, because i cannot upgrade. :(

When i try to do an upgrade i get the following error on the shell:

root@xyz:~# trac-admin /trac-projects/myOldTracProject upgrade

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/api.py", line 367, in send_error
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/chrome.py", line 708, in render_template
    data = self.populate_data(req, data)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/chrome.py", line 618, in populate_data
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/api.py", line 194, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/chrome.py", line 476, in prepare_request
    for category, name, text in contributor.get_navigation_items(req):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/ticket/web_ui.py", line 163, in get_navigation_items
    if 'TICKET_CREATE' in req.perm:
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 524, in has_permission
    return self._has_permission(action, resource)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 538, in _has_permission
    check_permission(action, perm.username, resource, perm)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 425, in check_permission
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 282, in check_permission
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 357, in get_user_permissions
    for perm in self.store.get_user_permissions(username):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 175, in get_user_permissions
    cursor.execute("SELECT username,action FROM permission")
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
DatabaseError: file is encrypted or is not a database

Attachments (0)

Change History (3)

comment:1 by Emmanuel Blot, 13 years ago

Resolution: invalid
Status: newclosed

Two reasons to close this ticket as invalid:

  1. This is an installation issue, so re-read NewTicketGuidelines
  2. This is a frequent duplicate, and searching for the error would have given you a long list of duplicates

Finally, check out PySqlite#DatabaseError:fileisencryptedorisnotadatabase

comment:2 by anonymous, 13 years ago

Resolution: invalid
Status: closedreopened

In my opinion, the trac-admin upgrade tool should be capable of upgrading 0.9.x environments to 0.11.x ( currently it does just display an error message ) …

However, i would be glad, to get a bit help on how to proceed. The links you've provided me didn't help. I'm still unable to upgrade my old trac environments.

This link didn't help me http://trac.edgewall.org/wiki/0.10/TracUpgrade.

Please help meee with better links ;)

comment:3 by Christian Boos, 13 years ago

Resolution: invalid
Status: reopenedclosed

You'll first need to convert your SQLite 2 database to a SQLite 3 database, as explained in details in 0.10/TracUpgrade.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.