Failure to save as postgresql database

Jack ostroffjh at users.sourceforge.net
Fri Jan 1 00:02:08 GMT 2021


In looking at https://bugs.kde.org/show_bug.cgi?id=430163 I got both  
mariadb and postgresql set up.  I can save to mariadb (mysql) but not  
to postgresql.  The error I get is:

-----
Cannot save to current database: Error in function void  
MyMoneyStorageSqlPrivate::deleteKeyValuePairs(const QString&, const  
QVariantList&) : deleting kvp for STORAGE
Driver = QPSQL, Host = localhost, User = jack, Database = kmm
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed: DELETE FROM kmmKeyValuePairs WHERE kvpType = ? AND kvpId = ?;
Query error No 42601: ERROR:  syntax error at or near "("
LINE 1: EXECUTE  ('STORAGE', '')
                  ^
(42601) QPSQL: Unable to create query
Error type 2  
/var/tmp/portage/app-office/kmymoney-5.1.9999/work/kmymoney-5.1.9999/kmymoney/plugins/sql/mymoneystoragesql_p.h:1927
-----

In that call, kvpType is "STORAGE" and idList contains one empty  
string.  I have no idea where the question marks in the "Executed" line  
come from.  I see no obvious errors in the qSql code, other than  
perhaps wondering if the "" is getting correctly bound to :kvpID but I  
know I'm grabbing at straws here.

My other question is where LINE 1: EXECUTE('STORAGE','') comes from.   
Those would be the proper two values for the single execution of the  
DELETE statement, but that seems to have come from much deeper in the  
libraries, although I don't know if it's still within QSql orin actual  
Postgresql code.

Any suggestions on how to further troubleshoot will be appreciated,  
although I know my next effort will be to run under gdb.

Jack


More information about the KMyMoney-devel mailing list