SUMMARY: Manual price entry worked as expected. Multiple price entries can be accepted. On saving an error occurred: STEPS TO REPRODUCE 1. Enter a price for a security through the Exchange rate/price editor 2. Click on File- Save OBSERVED RESULT 3. A window appears titled Error-Kmymoney, with the message faild to save your storage. 4: message datas are: Error in function void MyMoneyStorageSqlPrivate::writeFileInfo() : writing FileInfo Driver = QPSQL, Host = localhost, User = tonbaz, Database = kmymoney Driver Error: Database Error No -1: Text: Error type 0 Executed: UPDATE kmmFileInfo SET version = ?, fixLevel = ?, created = ?, lastModified = ?, baseCurrency = ?, dateRangeStart = ?, dateRangeEnd = ?, hiInstitutionId = ?, hiPayeeId = ?, hiTagId = ?, hiAccountId = ?, hiTransactionId = ?, hiScheduleId = ?, hiSecurityId = ?, hiReportId = ?, hiBudgetId = ?, hiOnlineJobId = ?, hiPayeeIdentifierId = ?, encryptData = ?, updateInProgress = ?, logonUser = ?, logonAt = ?, institutions = ?, accounts = ?, payees = ?, tags = ?, transactions = ?, splits = ?, securities = ?, prices = ?, currencies = ?, schedules = ?, reports = ?, kvps = ?, budgets = ?; Query error No 22003: ERROR: bigint out of range (22003) QPSQL: Unable to create query Error type 2 /home/appimage/workspace/KMyMoney_Nightly_Appimage_Build/kmymoney/kmymoney/plugins/sql/mymoneystoragesql_p.h:802 EXPECTED RESULT Normal saving action SOFTWARE VERSIONS KDE Frameworks 5.51.0 Qt 5.11.2 (built against 5.11.2) The xcb windowing system ADDITIONAL INFORMATION Using nightly build #72
Using postgresql 10 back end
Query error No 22003: ERROR: bigint out of range seems to be the problem. I don't see why any of the numeric values at this point should be out of bounds. Does this only happen when you enter a price or also when you change other objects (transactions, accounts, payees, ...)? Can you try the following (possibly with a fresh nightly build): 1) load the database 2) save as XML file 3) restart KMyMoney 4) load XML file 5) Store as database (a new one) 6) add price entry 7) Save Does the problem persist?
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!