https://bugs.kde.org/show_bug.cgi?id=378676
Bug ID: 378676 Summary: 4.8.0 multiple installation problems on windows Product: kmymoney4 Version: unspecified Platform: MS Windows OS: MS Windows Status: UNCONFIRMED Severity: normal Priority: NOR Component: database Assignee: kmymoney-de...@kde.org Reporter: gf...@twoshoelaces.com Target Milestone: --- Been using 4.7.2 on Windows, trying to install 4.8.0 on Windows (via http://sourceforge.net/projects/kmymoney2/files/KMyMoney-Windows/4.8.0/kmymoney-x86-setup-4.8.0.exe/download) using MySQL. After program is installed, File -> Save as Database results in multiple errors: 1) CREATE TABLE kmmAccountsPayeeIdentifier (accountId varchar(32) NOT NULL, "order" smallint unsigned NOT NULL, identifierId varchar(32) NOT NULL, PRIMARY KEY (accountId, "order")) ENGINE = InnoDB; dies due to using "order", per bug #365615. I changed 4 instances in the SQL calls (2 each in creating tables kmmAccountsPayeeIdentifier and kmmPayeesPayeeIdentifier ) from order to userOrder 2) What appears to be a typo in INSERT INTO kmmFileInfo row, hiPayeeIdentifierId data is NULLentifierId when I'm guessing it should be NULL? After making the above changes, the SQL tables create successfully, but the program dies when using File -> Open database. Another instance of Bug 365615, hardcoded "order" instead of userOrder in the query ORDER BY, here is error text: Cannot open file as requested. Error was: Error in function const class QMap<class QString,class MyMoneyPayee> __thiscall MyMoneyStorageSql::fetchPayees(const class QStringList &,bool) const : reading Payee Driver = QMYSQL, Host = localhost, User = root, Database = kmymoney2 Driver Error: Database Error No -1: 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 FROM ( SELECT * FROM kmmPayees ) kmmPayees LEFT OUTER JOIN kmmPayeesPayeeIdentifier ON kmmPayees.Id = kmmPayeesPayeeIdentifier.payeeId ORDER BY kmmPayees.id, kmmPayeesPayeeIdentifier."order"; Query error No 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"order"' at line 1 QMYSQL: Unable to execute query Error type 2 Is there a way to modify the SQL code given that I'm running it using the Windows .exe installer? -- You are receiving this mail because: You are watching all bug changes.