Bug 248546 - Duplicate transaction numbers prevent using MySQL database.
Summary: Duplicate transaction numbers prevent using MySQL database.
Status: RESOLVED DUPLICATE of bug 246108
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: openSUSE Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-20 21:50 UTC by Russ Fineman
Modified: 2010-08-20 21:58 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***