Edgewall Software
Modify

Opened 15 years ago

Closed 14 years ago

#8712 closed defect (wontfix)

Detect old sqlite2 DB format and display link to update

Reported by: anatoly techtonik <techtonik@…> Owned by: Christian Boos
Priority: low Milestone:
Component: database backend Version: 0.11.5
Severity: minor Keywords: needpatch sqlite
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

Yet another user on IRC encountered the message "sqlite3.DatabaseError: file is encrypted or is not a database"

It would be better if an exception handler that is responsible for this error made additional read from DB file to check if its first line contains SQLite2 format signature.

** This file contains an SQLite 2.1 database **

Attachments (0)

Change History (5)

comment:1 by anatoly techtonik <techtonik@…>, 15 years ago

Well, yes, and displayed a warning with link to upgrade instructions at PySqlite

comment:2 by Christian Boos, 15 years ago

Keywords: needpatch added

Patch welcomed.

comment:3 by anatoly techtonik <techtonik@…>, 15 years ago

Well I have some incomplete work based on patch in #8647, but I am not sure it works now when #8625 is closed. I still haven't found a proper place where to put this DB check - see comment:12:ticket:8625

comment:4 by Christian Boos, 14 years ago

Keywords: sqlite added
Milestone: 0.12
Owner: set to Christian Boos
Priority: normallow
Severity: normalminor

comment:5 by Christian Boos, 14 years ago

Milestone: 0.12
Resolution: wontfix
Status: newclosed

I think it's simple enough to realize what has to be done when seeing this error message, given all the troubleshooting information that is available:

google:"DatabaseError: file is encrypted or is not a database"

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Christian Boos.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Christian Boos 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.