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-de...@kde.org Reporter: a...@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 watching all bug changes.