[kmymoney] [Bug 390411] Sqlite opening broken

[bugzilla_noreply at kde.org]

https://bugs.kde.org/show_bug.cgi?id=390411

kde1 at openken.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kde1 at openken.com

--- Comment #19 from kde1 at openken.com ---
I ran into the same issue today after upgrading to Ubuntu 18.04.1 LTS with
kmymoney v5.0.1-2.

Neither the UI or command line works for me. In the software itself it won't
open the sqlite file. 

On the command line the error looks like this:

$ kmymoney sql:/tmp/kmy.sqlite3?driver=QSQLITE
WebConnect: Try to connect to WebConnect server
WebConnect: Connect to server failed
WebConnect: Starting server failed. Try to remove stale socket.
WebConnect: Running in server mode
Invalid Context= "stock" line for icon theme: 
"/usr/share/icons/ubuntu-mono-light/stock/16/"
Invalid Context= "stock" line for icon theme: 
"/usr/share/icons/ubuntu-mono-light/stock/22/"
Invalid Context= "stock" line for icon theme: 
"/usr/share/icons/ubuntu-mono-light/stock/24/"
Invalid Context= "stock" line for icon theme: 
"/usr/share/icons/ubuntu-mono-light/stock/32/"
Invalid Context= "stock" line for icon theme: 
"/usr/share/icons/ubuntu-mono-light/stock/48/"
Invalid Context= "stock" line for icon theme: 
"/usr/share/icons/ubuntu-mono-light/stock/64/"
Invalid Context= "stock" line for icon theme: 
"/usr/share/icons/ubuntu-mono-light/stock/128/"
Plugins: checkprinting loaded
Plugins: csvexporter loaded
Plugins: csvimporter loaded
Plugins: gncimporter loaded
Plugins: icalendarexporter loaded
Plugins: kbanking loaded
KBankingPlugin: No AqB4 config found.
KBankingPlugin: No AqB3 config found.
Plugins: kbanking pluged
Plugins: ofximporter loaded
Plugins: qifexporter loaded
Plugins: qifimporter loaded
Plugins: reconciliation report loaded
Plugins: weboob loaded
Online plugins found 3
Cost center model created with items 0
Payees model created with items 0
Error in function bool MyMoneyStorageSqlPrivate::alterTable(const
MyMoneyDbTable&, int) : Error inserting into new table kmmSecurities
Driver = QSQLITE, Host = , User = , Database = /tmp/kmy.sqlite3
Driver Error: 
Database Error No -1: 
Text:  
Error type 0
Executed: INSERT INTO kmmSecurities (id, name, symbol, type, typeString,
smallestAccountFraction, pricePrecision, tradingMarket, tradingCurrency) SELECT
id, name, symbol, type, typeString, smallestAccountFraction, pricePrecision,
tradingMarket, tradingCurrency FROM kmmtmpSecurities;
Query error No -1: No query Unable to fetch row
Error type 1
void MyMoneyStorageSql::cancelCommitUnit(const QString&) - bool
MyMoneyStorageSqlPrivate::alterTable(const MyMoneyDbTable&, int) s/be int
MyMoneyStorageSqlPrivate::upgradeToV11()
terminate called after throwing an instance of 'MyMoneyException'
Aborted (core dumped)


It's worth noting that the same file opened fine yesterday before the upgrade,
which I believe was kmymoney v4.x (forgot the minor version number) on Ubuntu
16.04 LTS.

-- 
You are receiving this mail because:
You are the assignee for the bug.