Bug 400642 - Cannot save after manual price entry
Summary: Cannot save after manual price entry
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: database (show other bugs)
Version: unspecified
Platform: Kubuntu Linux
: NOR critical
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-04 00:36 UTC by Tony
Modified: 2019-02-18 04:33 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 Tony 2018-11-04 00:36:14 UTC
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
Comment 1 Tony 2018-11-04 00:37:28 UTC
Using postgresql 10 back end
Comment 2 Thomas Baumgart 2019-01-19 10:55:32 UTC
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?
Comment 3 Bug Janitor Service 2019-02-03 04:33:07 UTC
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!
Comment 4 Bug Janitor Service 2019-02-18 04:33:08 UTC
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!