id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 8625,Drop SQLite2 support,anatoly techtonik ,Remy Blank,"When trying to run 0.11.x Trac on an old sqlite2 DB the following error is displayed. {{{ Traceback (most recent call last): File ""m:\p\trac\trac-0.11dev\trac\web\api.py"", line 377, in send_error 'text/html') File ""m:\p\trac\trac-0.11dev\trac\web\chrome.py"", line 727, in render_template req.chrome[type_].append( File ""m:\p\trac\trac-0.11dev\trac\web\api.py"", line 195, in __getattr__ value = self.callbacks[name](self) File ""m:\p\trac\trac-0.11dev\trac\web\chrome.py"", line 488, in prepare_request for category, name, text in contributor.get_navigation_items(req): File ""m:\p\trac\trac-0.11dev\trac\ticket\web_ui.py"", line 163, in get_navigation_items if 'TICKET_CREATE' in req.perm: File ""m:\p\trac\trac-0.11dev\trac\perm.py"", line 527, in has_permission return self._has_permission(action, resource) File ""m:\p\trac\trac-0.11dev\trac\perm.py"", line 541, in _has_permission check_permission(action, perm.username, resource, perm) File ""m:\p\trac\trac-0.11dev\trac\perm.py"", line 428, in check_permission perm) File ""m:\p\trac\trac-0.11dev\trac\perm.py"", line 285, in check_permission get_user_permissions(username) File ""m:\p\trac\trac-0.11dev\trac\perm.py"", line 360, in get_user_permissions for perm in self.store.get_user_permissions(username): File ""m:\p\trac\trac-0.11dev\trac\perm.py"", line 178, in get_user_permissions cursor.execute(""SELECT username,action FROM permission"") File ""m:\p\trac\trac-0.11dev\trac\db\util.py"", line 60, in execute return self.cursor.execute(sql) File ""m:\p\trac\trac-0.11dev\trac\db\sqlite_backend.py"", line 58, in execute args or []) File ""m:\p\trac\trac-0.11dev\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 }}} The proposal is to drop support for SQLite2 format and display message with a link to convert instructions when an old format is detected. http://trac.edgewall.org/wiki/PySqlite#TheSQLitelibrary See also Debian bug: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=501338",defect,closed,normal,0.12,database backend,0.11-stable,normal,fixed,pysqlite,,,,,