Openning of Databases fails

[Christian Dávid]

Hi Thomas,

without further investigating, I asume that the INSERT INTO is executed before the update was done. Due to the error the update will never be executed.

Greetings
Christian

> Thomas Baumgart <thb at net-bembel.de> hat am 4. Dezember 2016 um 10:01 geschrieben:
> 
> 
> Hi,
> 
> your remark about the backend is also my opinion (gut feeling based).
> 
> The problem you encounter should not happen as I added logic to add the column 
> to the DB once you open an older version. Why does this not get executed?
> 
> Thomas
> 
> 
> On Saturday 03 December 2016 21:23:29 Christian David wrote:
> 
> > Hello,
> > 
> > I cannot open my old databases anymore. The query which causes the problem
> > is attached. Note that there are more colums in INSERT INTO than in the
> > SELECT (the costCenterId) — which will obviously fail.
> > 
> > We really need a new strategy for the database backend, the current state is
> > not tenable.
> > 
> > Greetings
> > Christian
> > 
> > 
> > Driver = QSQLITE, Host = localhost, User = xxx, Database = xxx/kmymoney-
> > testfiles/tset.sqlite
> > Driver Error:
> > Database Error No -1:
> > Text:
> > Error type 0
> > Executed: INSERT INTO kmmSplits (transactionId, txType, splitId, payeeId,
> > reconcileDate, action, reconcileFlag, value, valueFormatted, shares,
> > sharesFormatted, price, priceFormatted, memo, accountId, costCenterId,
> > checkNumber, postDate, bankId) SELECT transactionId, txType, splitId,
> > payeeId, reconcileDate, action, reconcileFlag, value, valueFormatted,
> > shares, sharesFormatted, price, priceFormatted, memo, accountId,
> > checkNumber, postDate, bankId FROM kmmtmpSplits;
> > Query error No -1: No query Unable to fetch row
> > Error type 1
> > void MyMoneyStorageSql::cancelCommitUnit(const QString&) - bool
> > MyMoneyStorageSql::alterTable(const MyMoneyDbTable&, int) s/be int
> > MyMoneyStorageSql::upgradeToV9()
> > terminate called after throwing an instance of 'MyMoneyException'
> -- 
> 
> Regards
> 
> Thomas Baumgart
> 
> GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
> -------------------------------------------------------------
> A: Because it destroys the flow of the conversation
> Q: Why is top-posting bad?
> A: Top-posting
> Q: What is the most annoying thing in e-mail?
> -------------------------------------------------------------