Bug 248546

Summary: Duplicate transaction numbers prevent using MySQL database.
Product: [Applications] kmymoney Reporter: Russ Fineman <upscope>
Component: generalAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: openSUSE   
OS: Linux   
Latest Commit: Version Fixed In:

Description Russ Fineman 2010-08-20 21:50:29 UTC
Version:           unspecified (using KDE 4.5.0) 
OS:                Linux

openSUSE 11.3

KMyMoney
Version 4.5.0
Using KDE Development Platform 4.5.00 (KDE 4.5.0)

Only seems to be problem using MySQL database. If just use KMyMoney.kmy appears to not effect it.As stated in Bug 246108, there is a duplicated transaction (actually about 6). They all appear to be tranactions that were carried over from my old bank to the new one because they had not cleared before then. 

Problem defined in Bug 246108 still exists. Bug marked resolved. 



Reproducible: Always

Steps to Reproduce:
Not sure how to reproduce. But here's output looking at KMyMoney.kmy of the first dup. transaction. There are about 6 of them I found, all from the time around switching banks, etc. (Aug 2005)

see actual results. This still causes error shown in the above bug report.

Actual Results:  
<TRANSACTION postdate="2004-11-16" commodity="USD" memo=""
id="T000000000000000001" entrydate="2005-03-12">
   <SPLITS>
    <SPLIT payee="P000001" reconcileflag="2" shares="-2500/100"
reconciledate="2005-03-07" action="Check" bankid="" account="A000192"
number="11088" value="-2500/100" memo="" id="S0001"/>
    <SPLIT payee="" reconcileflag="0" shares="2500/100" reconciledate=""
action="Check" bankid="" account="A000262" number="" value="2500/100"
memo="" id="S0002"/>
   </SPLITS>
  </TRANSACTION>


  <TRANSACTION postdate="2010-06-26" commodity="USD" memo=""
id="T000000000000000001" entrydate="2010-
07-23">
   <SPLITS>
    <SPLIT payee="P000108" reconcileflag="0" shares="-6036/100"
reconciledate="" action="" bankid="" a
ccount="A000294" number="2024" value="-6036/100" memo="" id="S0001"/>
    <SPLIT payee="P000108" reconcileflag="0" shares="6036/100"
reconciledate="" action="" bankid="" ac
count="A000041" number="2024" value="6036/100" memo="" id="S0002"/>
   </SPLITS>
  </TRANSACTION>

Expected Results:  
Different transaction numbers. 

Also different Hardware from original early transaction. Moved from 32 bit system to 64 bit system. Can I just edit the transaction numbers to something else and not mess up the reconciliation etc? 

If you need additional information please let me know.
Comment 1 Alvaro Soliverez 2010-08-20 21:58:57 UTC
Reopen the original bug, do not open a new one

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