MyMoneyStorageSql::upgradeToV1() uses the query "ALTER TABLE kmmSplits ADD PRIMARY KEY (transactionId, splitId);" which will always fail in SQLite because it does not support adding primary keys in alter table (http://sqlite.org/lang_altertable.html). KMyMoney will not open SQLite databases of version 0 - that issue must be there for five years already. So we have to decide if it will be fixed as nobody complained before. I found it only because the databasemrgtest persistently fails/crashes on my system.
Git commit d30be72a46be9450a0f205d7c615b96f34a8bf0a by Christian Dávid. Committed on 10/01/2015 at 16:20. Pushed by christiand into branch 'master'. Database version is set after creating tables So the upgrade routine is not executed starting from version 0 - which is useless as the database should be the most recent version anyway. Also removed the version param from createTables(int version). It was not used and was totaly useless as createTables() calls upgradeDb(). This is also a workaround for bug 341304 as the upgradeToV1() won't be called after creation of tables anymore. The bug persists if the user has a version 0 database. REVIEW: 121288 M +1 -1 kmymoney/mymoney/storage/mymoneydatabasemgrtest.cpp M +16 -8 kmymoney/mymoney/storage/mymoneystoragesql.cpp M +1 -1 kmymoney/mymoney/storage/mymoneystoragesql.h http://commits.kde.org/kmymoney/d30be72a46be9450a0f205d7c615b96f34a8bf0a
Thank you for reporting this bug in KDE software. As it has been a while since this issue was reported and confirmed, can we please ask you to see if you can reproduce the issue with a recent software version? If you can reproduce the issue, please change the status to "CONFIRMED" when replying. Thank you!
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please mark the bug as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!
This bug has been in NEEDSINFO status with no change for at least 30 days. The bug is now closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging Thank you for helping us make KDE software even better for everyone!