[Kmymoney-devel] [kmymoney4] [Bug 356166] New: Attempts to create duplicate record in MySQL for customised report

[Alan Prescott via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=356166

            Bug ID: 356166
           Summary: Attempts to create duplicate record in MySQL for
                    customised report
           Product: kmymoney4
           Version: 4.7.2
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: database
          Assignee: kmymoney-devel at kde.org
          Reporter: ajp at fudokai.org.uk

I tried to create a customised version of the Transactions by Category report
and received the following error message ...

Failed to configure report: Error in function void
MyMoneyStorageSql::writeReport(const MyMoneyReport&, QSqlQuery&) : writing
Reports
Driver = QMYSQL, Host = zanshin, User = alan, Database = KMyMoney
Driver Error: 
Database Error No -1: 
Text:  
Error type 0
Executed: INSERT INTO kmmReportConfig (name, XML, id) VALUES (?, ?, ?);
Query error No 1062: Duplicate entry 'R000002' for key 'PRIMARY' QMYSQL3:
Unable to execute statement
Error type 2 

I logged out and back in again and tried again but had the same error message
but this time referring to 'R000003'.

FYI kmmReportConfig currently holds records up to 'R000014'.

This is a MySQL database version on a remote host so that my wife can also
access the family accounts from her Windoze box.

Reproducible: Always

Steps to Reproduce:
1. Edit a standard report
2. Save changes
3.

Actual Results:  
Fails to save the changes and reports a duplicate key error

Expected Results:  
Create nre, customised copy of the report

MySQL version of the KMyMoney database running on a remote host.
The user 'alan' has full privileges to the KMyMoney database

-- 
You are receiving this mail because:
You are the assignee for the bug.