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.
