Hi all,
I am using KMyMoney and I stored the data on my NAS’ MySQL instance.
Today I cannot longer open it as I get the following error:
Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) : opening database
Driver = QMYSQL, Host = , User = , Database =
Driver Error: Driver not loaded
Database Error No -1: Driver not loaded
Text: Driver not loaded Driver not loaded
Error type 1
Executed:
Query error No -1: Driver not loaded Driver not loaded
Error type 1
Ho can I solve it?
Thanks in advance.
Hi Marco,
You can start by telling us which OS/Distribution you are using, which version of KMyMoney you are using, and whether you changed versions recently. Separately, can you open the data file directly, using sqlite or sqlite-browser?
The message about driver not loaded suggests that either your version of KMyMoney was not built with sqlite support, or else you are missing one of the sqlite or qt-sql libraries.
Hello,
I am using KMyMoney 5.1.3 on Gentoo.
I cannot pinpoint any particular change (being a rolling release it always changes and I don’t use KMyMoney daily), but I recall that a couple of days ago Emerge suggested to remove some QT5 libraries as no longer needed as dependencies.
I can open the data phpMyAdmin.
I’m also on Gentoo, but I use the live version of KMM, so I’ll have to dig through the 5.1.3 ebuild to see if something is amiss. What versions of sqlcipher and qtsql do you have installed?
[edit to add] Also, does qtsql have the sqlite USE flag set?]
dev-db/sqlcipher 4.5.5
dev-qt/qtsql 5.15.14
Yes, qtsql has sqlite active. But not mysql; should I enable this since the data is in a MySQL (MariaDB) instance?
Sorry - not sure why I focused on sqlite. Yes, enable mysql use flag for qtsql. What I’m not sure of is whether this is just something the user should need to do, or if portage should be able to figure it out. Probably the former, since there is no sql use flag for kmymoney so the system really has no way of knowing you need it.
It worked. Now I am able again to access my data.
Strange it was working and then suddenly not.
Thanks for your help.
You can use “genlop -t qtsql” (not sure of package containing that program) to list all emerges of that package (check man page to be sure it is using old emerge.log files and not just current one assuming you use logrotate) although that doesn’t tell you WHY it was re-emerged, nor changes to use flags, but it might give some hint.
With the command you provided I can see that it had re-emerged on Oct 6 for some reason.
Looks like when KMyMoney stop working (immediately after that I went on vacation, so I haven’t used until today).
Very odd. The stabilization of 5.15.14 and removal of 5.15.13 was done early June. All I can imagine is something else may have changed a required use flag, causing a rebuild. One of the things you learn to look out for if you use Gentoo.
BTW, you mentioned you use the live version; how is it? Is it fairly stable?
Generally 5.1.3 is good, but (beside the above problem) I am looking to solve another bug: for some time (a couple of months or a little bit more) the homepage of KMM is blank; not a major problem as the rest of the app is working fine, but it is annoying to miss the summary of my financial situation.
The 9999 ebuild in Gentoo builds from git head master branch. 9999 ebuilds are always labelled as unstable and potentially dangerous, but there are a number of folks who have been using this KMM version for day to day work without major problems. As always, back up early and often.
The blank home page is a known issue, but I’m not sure we have found a consistent solution. The issue is that the home page (and many other pieces of the GUI, such as reports) are displayed using HTML, and some of the pieces end up not playing nice with the others. Much of how KMM uses HTML (the specific libraries used) has changed in master branch, decreasing the chance of such problems.
Thank you very much for the infos.