[kmymoney4] [Bug 378676] New: 4.8.0 multiple installation problems on windows

[Gary]

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