[kmymoney] [Bug 410091] New: Open sqlite database under kmymoney versions >= 5.0

[Thomas Baumgart]

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 at kde.org
          Reporter: tbaumgart at 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.