Openning of Databases fails

[Thomas Baumgart]

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?
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 225 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20161204/b22e9782/attachment.sig>