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

Saving updates to SQL database error

Tags: None
(comma "," separated)
kde-mprowe
Registered Member
Posts
1
Karma
0
This is my setup
Operating System: openSUSE Leap 15.2
KDE Plasma Version: 5.18.6
KDE Frameworks Version: 5.71.0
Qt Version: 5.12.7
Kernel Version: 5.3.18-lp152.66-default
OS Type: 64-bit
Processors: 4 × Intel® Core™ i5 CPU 760 @ 2.80GHz
Memory: 7.8 GiB of RAM
(Cut 'n Paste from KInfoCenter)
KMyMoney: Version 5.1.1
Maria Database Server: mysql Ver 15.1 Distrib 10.4.17-MariaDB, for Linux (x86_64) using EditLine wrapper

In KMyMoney, I have been able to "File | Save As..." which has created the database:
Code: Select all
MariaDB [(none)]> use KMyMoney
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [KMyMoney]> Show tables;
+----------------------------+
| Tables_in_KMyMoney         |
+----------------------------+
| kmmAccounts                |
| kmmAccountsPayeeIdentifier |
| kmmBalances                |
| kmmBudgetConfig            |
| kmmCostCenter              |
| kmmCurrencies              |
| kmmFileInfo                |
| kmmInstitutions            |
| kmmKeyValuePairs           |
| kmmNationalAccountNumber   |
| kmmOnlineJobs              |
| kmmPayeeIdentifier         |
| kmmPayees                  |
| kmmPayeesPayeeIdentifier   |
| kmmPluginInfo              |
| kmmPrices                  |
| kmmReportConfig            |
| kmmSchedulePaymentHistory  |
| kmmSchedules               |
| kmmSecurities              |
| kmmSplits                  |
| kmmTagSplits               |
| kmmTags                    |
| kmmTransactions            |
+----------------------------+
24 rows in set (0.000 sec)

MariaDB [KMyMoney]>

I believe that I have access to the database:
Code: Select all
MariaDB [KMyMoney]> show grants for 'mprowe'@'localhost';
+------------------------------------------------------------------------------------------------------------------------+
| Grants for mprowe@localhost                                                                                            |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `mprowe`@`localhost` IDENTIFIED BY PASSWORD '*40FF34C70B392322670FE0224DB80F074CD06EC4' |
+------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
MariaDB [KMyMoney]>

On opening KMyMoney I can "File | Open Database" and reload the data. Up to this point all looks good. But...

If I make any changes, I am unable to save them?
Image

If I was able to "Save As..." the PlugIn must be available? Or no...?
What is the "wonky" path at the bottom of the error screen all about?

Regards, Martin


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot]