https://bugs.kde.org/show_bug.cgi?id=501591
Bug ID: 501591
Summary: Error in function QMap<QString, MyMoneyPayee>
MyMoneyStorageSql::fetchPayees(const QStringList&,
bool) const : reading Payee
Classification: Applications
Product: kmymoney
Version: 5.1.92
Platform: Gentoo Packages
OS: Linux
Status: REPORTED
Severity: grave
Priority: NOR
Component: database
Assignee: kmymoney-de...@kde.org
Reporter: marco.difre...@gmail.com
Target Milestone: ---
I got today the update from 5.13 to 5.1.92 on my Gentoo PC. Unfortunately when
I start it I get the following error:
Error in function QMap<QString, MyMoneyPayee>
MyMoneyStorageSql::fetchPayees(const QStringList&, bool) const : reading Payee
Driver = QMYSQL, Host = 192.168.0.12, User = marco, Database = KMyMoney-CHF
Driver Error:
Database Error No :
Text:
Error type 0
Executed: SELECT kmmPayees.id AS id, kmmPayees.name AS name,
kmmPayees.reference AS reference, kmmPayees.email AS email,
kmmPayees.addressStreet AS addressStreet, kmmPayees.addressCity AS addressCity,
kmmPayees.addressZipcode AS addressZipcode, kmmPayees.addressState AS
addressState, kmmPayees.telephone AS telephone, kmmPayees.notes AS notes,
kmmPayees.defaultAccountId AS defaultAccountId, kmmPayees.matchData AS
matchData, kmmPayees.matchIgnoreCase AS matchIgnoreCase, kmmPayees.matchKeys
AS matchKeys, kmmPayeesPayeeIdentifier.identifierId AS identId,
kmmPayees.idPattern AS idPattern, kmmPayees.urlTemplate AS urlTemplate FROM (
SELECT * FROM kmmPayees ) kmmPayees LEFT OUTER JOIN kmmPayeesPayeeIdentifier
ON kmmPayees.Id = kmmPayeesPayeeIdentifier.payeeId ORDER BY kmmPayees.id,
kmmPayeesPayeeIdentifier.userOrder;
Query error No 1054: Unknown column 'kmmPayees.idPattern' in 'field list'
QMYSQL: Unable to execute query
Error type 2
/var/tmp/portage/app-office/kmymoney-5.1.92_p20250306/work/kmymoney-17859b4f0b2a654c11e8e209fdc7ea097c7f4ea5/kmymoney/plugins/sql/mymoneystoragesql.cpp:1338
Dismissing the error window lead to a fresh (empty) KMyMoney; therefore I
cannot access my accounting.
--
You are receiving this mail because:
You are watching all bug changes.
