This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Sqlite

Tags: None
(comma "," separated)
Anonymous Osprey
Karma
0

Sqlite

Mon May 14, 2018 5:03 pm
I have updated from Kubuntu 17.10 to Kubuntu 18.4.
With the new version it is not possible to open an existing kmymoney sql-database. Any idea how to fix this or is this a bug in kmymoney?

Erich
User avatar
ostroffjh
Registered Member
Posts
253
Karma
0
OS

Re: Sqlite

Thu May 17, 2018 5:15 pm
Please provide some more information. What version of KMyMoney is it? Which sql are you using? Do you get any error message? If not, try running from a command line, as there may be more diagnostic output that way.

Separately, have you tried opening the database directly with sql? That would help determine if the problem is with the database itself (either the actual database, or the database software) or with how KMM is trying to access it.
mreinemann
Registered Member
Posts
3
Karma
0

Re: Sqlite available, but not MySQL

Sat May 19, 2018 5:17 am
It seems I have the same issue.
I worked before with Ubuntu 16.04 and KmyMoney 4.7 using MySQL database.
After I updated to Ubuntu 18.04 including KmyMoney 5.0 no option is available to change the database type from SQLite Version 3.0 to MySQL within the File - open database menu.
I just reinstalled MySQL-Server but without any success :-(
mreinemann
Registered Member
Posts
3
Karma
0

Re: Sqlite

Tue Oct 30, 2018 6:59 am
after I installed the complete kubuntu-desktop the menu was available
but it doesn't work because of an qt error . . .
User avatar
ostroffjh
Registered Member
Posts
253
Karma
0
OS

Re: Sqlite

Tue Oct 30, 2018 4:25 pm
I"m not sure why I didn't see your previous post, but now, if you want any help, you need to provide some additional information - such as what is the error?

In terms of changing from SQLite to MySQL, I think it might be that you first need to save as a file, and then when you save as SQL you should have the choice of which sql engine to use.
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: Sqlite

Tue Oct 30, 2018 5:40 pm
It won't work with any of the released 5.0.[0-1] version. If you want to try, you need to use the appimage. But be aware that this is produced off the unstable master branch and you mileage may vary.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Google [Bot], Yahoo [Bot]