https://bugs.kde.org/show_bug.cgi?id=410091
Bug ID: 410091
Summary: Open sqlite database under kmymoney versions >= 5.0
Product: kmymoney
Version: 5.0.5
Platform: Other
OS: Linux
Status: REPORTED
Severity: major
Priority: NOR
Component: database
Assignee: kmymoney-devel@kde.org
Reporter: tbaumg...@kde.org
Target Milestone: ---
Created attachment 121671
--> https://bugs.kde.org/attachment.cgi?id=121671&action=edit
Empty database showing the problem
SUMMARY
An sqlite database created with a prior version of KMyMoney (e.g. 4.7.2) cannot
be opened with recent versions (>= 5.0)
STEPS TO REPRODUCE
1. Open existing database created with older version of KMyMoney
OBSERVED RESULT
An error is displayed, that the database cannot be opened.
EXPECTED RESULT
Database opens without problems
ADDITIONAL INFORMATION
The problem has initially been reported on
https://forum.kde.org/viewtopic.php?f=69&t=161485
The database can be opened using e.g. sqlitebrowser and seems to be ok
(contains all tables and data items).
The details of the error message contain the following information:
Error in function bool MyMoneyStorageSqlPrivate::alterTable(const
MyMoneyDbTable&, int) : Error dropping index from kmmSplits
Driver = QSQLITE, Host = localhost, User = thb, Database = //home/thb/xxx.db
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed:
Query error No 6: database table is locked Unable to fetch row
Error type 1
It is unsure if this also applies to MySQL databases.
--
You are receiving this mail because:
You are the assignee for the bug.
