Kmymoney crashes when opening ledgers tab with such error: Error in function bool MyMoneyStorageSql::isReferencedByTransaction(const QString &) const : error retrieving reference count Driver = QSQLITE, Host = , User = , Database = /home/username/kmymoney.sqlite Driver Error: Database Error No -1: Text: Error type 0 Executed: SELECT COUNT(*) FROM kmmTransactions INNER JOIN kmmSplits ON kmmTransactions.id = kmmSplits.transactionId WHERE kmmTransactions.currencyId = :ID OR kmmSplits.payeeId = :ID OR kmmSplits.accountId = :ID OR kmmSplits.costCenterId = :ID Query error No -1: Parameter count mismatch Error type 2 Error retrieving reference count Kmymoney version 5.0.1 from Neon repo. This started hapening after upgrading Neon Plasma from 5.11 to 5.13 version. Downgrading Kmymoney to 5.0.1-2+16.04+xenial+build1 build didn't solved. I have 5.0.1-2+16.04+xenial+build1 build on other non KDE machine and it doesn't crash on the same database.
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version? If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please mark the bug as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!
Kmymoney 5.1.2 from Neon distribution still crashes when trying to open sqlite database, but now it prints "Cannot mix incompatible Qt library (5.15.3) with this library (5.15.7)" to stderr. OS information provided by kinfocenter: KDE Neon 5.26 20.04 user edition KDE Frameworks version 5.99.0 Qt version: 5.15.7 Appimage version of Kmymoney 5.1.3 from https://binary-factory.kde.org/view/AppImage/job/KMyMoney_Release_appimage-centos7/ doesn't crash though, so it's probably packaging issue due to messing with qt libs versions.
You need to report that to Neon. It sounds like the KMM they are distributing was built with Qt 5.15.3, even though the rest of the distro is up to 5.15.7. If so, they just need to rebuild KMM using the newer Qt. Looking at your original report, you had the error on Neon but not on a non-KDE machine, so I'll wait a bit and then close this as DOWNSTREAM.
Instead of closing here, I can just reassign to Neon. Neon team: this looks like KMyMoney needs to be rebuilt using the same Qt version you distribute.