[kmymoney] [Bug 501591] New: Error in function QMap<QString, MyMoneyPayee> MyMoneyStorageSql::fetchPayees(const QStringList&, bool) const : reading Payee

[Marco Di Fresco]

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-devel at kde.org
          Reporter: marco.difresco at 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 the assignee for the bug.