[Kmymoney-devel] [kmymoney4] [Bug 322463] New: "Error: Failed to configure report " when using SQL backend.

[Justin Chudgar]

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

            Bug ID: 322463
           Summary: "Error: Failed to configure report " when using SQL
                    backend.
    Classification: Unclassified
           Product: kmymoney4
           Version: 4.6.3
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: general
          Assignee: kmymoney-devel at kde.org
          Reporter: justin at justinzane.com

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

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