Bug 322463

Summary: "Error: Failed to configure report " when using SQL backend.
Product: [Applications] kmymoney Reporter: Justin Zane Chudgar <justin>
Component: generalAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: RESOLVED DUPLICATE    
Severity: major CC: onet.cristian
Priority: NOR    
Version: 4.6.3   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Justin Zane Chudgar 2013-07-17 00:16:14 UTC
I cannot edit **any** reports or charts. No matter how significant or minor the change in the report/chart config; I inevitable get the following error dialog:

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

Note that I generalized the server, dbname and "R0000%02d" parts. 



Reproducible: Always

Steps to Reproduce:
1. Open report/chart for customization
2. change **anything**
3. click "ok" **or** "cancel"
4. < error >
Actual Results:  
see message above.

Expected Results:  
edited config saved
Comment 1 Cristian OneČ› 2013-09-12 08:48:00 UTC

*** This bug has been marked as a duplicate of bug 312676 ***