[kmymoney] [Bug 501591] Error in function QMap MyMoneyStorageSql::fetchPayees(const QStringList&, bool) const : reading Payee
https://bugs.kde.org/show_bug.cgi?id=501591 --- Comment #2 from Marco Di Fresco --- llo, A few notes as requested: it was an upgrade from 5.1.3; the DB is MariaDB 5.5.68 (it is on a NAS, so I don't think I can upgrade it outside NAS firmware updates); here the columns in kmmPayees: id name reference email addressStreet addressCity addressZipcode addressState telephone notes defaultAccountId matchData matchIgnoreCase matchKeys Best regards. -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 501591] Error in function QMap MyMoneyStorageSql::fetchPayees(const QStringList&, bool) const : reading Payee
https://bugs.kde.org/show_bug.cgi?id=501591 --- Comment #7 from Marco Di Fresco --- Done: https://bugs.gentoo.org/951486 -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 501591] Error in function QMap MyMoneyStorageSql::fetchPayees(const QStringList&, bool) const : reading Payee
https://bugs.kde.org/show_bug.cgi?id=501591 --- Comment #4 from Marco Di Fresco --- (In reply to Jack from comment #3) > The field it can't find was added four months ago, but only in master > branch, not the 5.1 branch, which is why it is not in your data. In the > short term, using any version of KMyMoney from the 5.1 branch should be able > to read your existing database. You can either dig up the 5.1.3 ebuild from > git, or use the 5.1.3 appimage I mentioned above. > Separately, we'll have to figure out why the new version didn't recognize > that your database needed to be updated, and get that code added. OK, thanks. Should I also open a bug report on Gentoo? Since 5.1.92 is now the only version on their tree, other may have the same problem too and therefore they should revert back to 5.1.3 until migrating-version is available. -- You are receiving this mail because: You are the assignee for the bug.
[kmymoney] [Bug 501591] New: Error in function QMap MyMoneyStorageSql::fetchPayees(const QStringList&, bool) const : reading Payee
https://bugs.kde.org/show_bug.cgi?id=501591 Bug ID: 501591 Summary: Error in function QMap 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@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 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.
