[Kmymoney-devel] [Bug 246108] New: Consistency Check does not catch duplicate IDs

[Fernando Vilas]

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

           Summary: Consistency Check does not catch duplicate IDs
           Product: kmymoney4
           Version: unspecified
          Platform: openSUSE RPMs
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: kmymoney-devel at kde.org
        ReportedBy: fvilas at iname.com


Version:           unspecified (using KDE 4.4.4) 
OS:                Linux

The file consistency check does not find/fix duplicate IDs. This prevents users
from using the "Save as database" feature, since the IDs are used as primary
keys in the database backend.

Reproducible: Didn't try

Steps to Reproduce:
Create a file with at least 2 transactions. Ensure that there is a duplicate
transactionid. Run the consistency check to try to fix the duplication. Attempt
to save to a database.

Actual Results:  
The consistency check reports that no problems were found. Then an error
message occurs, complaining about a duplicate entry for a primary key in the
kmmTransactions table.

Expected Results:  
The consistency check should fix the duplicate transactionid issue by changing
all except one transaction to a new transactionid and update the transactionid
counter to avoid future duplication issues.

This was reported on the KMM2 developer list by upscope at nwi.net on 2010-07-24.
Tony B. attempted to resolve the database issue by recommending a consistency
check, but that did not solve the problem.

The fix will likely involve a string change, since the errors are reported to
the user.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.