| irc.libera.chat #tryton log beginning Fri Nov 17 12:10:01 AM CET 2023 | ||
| -!- springwurm(~springwur@2a01:76c0:100:f500:3c19:428d:179d:faca) has joined #tryton | 06:03 | |
| -!- mrichez(~Maxime@mail.saluc.com) has joined #tryton | 07:24 | |
| -!- udono(~udo@227-139-067-156.ip-addr.inexio.net) has joined #tryton | 07:30 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 07:47 | |
| -!- ChanServ changed mode/#tryton -> +o cedk | 07:47 | |
| -!- acaubet(~Thunderbi@194.224.31.235) has joined #tryton | 08:53 | |
| mrichez | hi, on tryton 6.8, got this error when trying to do a sale return: The number of digits in the value "1.5800000000000000000" for field "Unite Price" in .... of "Sale Line" exceeds the limit of "8" | 10:09 |
|---|---|---|
| mrichez | known bug ? | 10:09 |
| pokoli | mrichez: using custom code or just using tryton modules? | 10:28 |
| pokoli | mrichez: this error is raised since https://foss.heptapod.net/tryton/tryton/-/commit/cfbc9e902c1d | 10:31 |
| pokoli | Normally the problem is that a round_price call is missing on some code | 10:32 |
| mrichez | pokoli: probably this issue, i'll try to apply patch on 6.8 | 10:39 |
| mrichez | pokoli: in my case, i'm just trying to return a sale (don't think my custom modules are involved in this case). I could retry also on a clean version. | 10:40 |
| pokoli | mrichez: probably the problem is that you have wrong data in the database | 10:45 |
| mrichez | pokoli: all the unit prices in the database have a lot of zero's : ex. 0.0010900000000000 | 10:54 |
| mrichez | how to fix ? | 10:54 |
| pokoli | mrichez: update xxxx set unit_price = round_price(unit_price, 4) for each table you have wrong values | 10:55 |
| pokoli | make sure to update the 4 with the number of digits your work with | 10:55 |
| mrichez | pokoli: ok, thanks, but i should also apply patch otherwise the problem will be still there... | 10:56 |
| mrichez | pokoli: i think it's linked to this MR : https://foss.heptapod.net/tryton/tryton/-/merge_requests/925 | 10:59 |
| mrichez | is the windows gtk client 6.8 updated with this MR ? | 11:00 |
| pokoli | the patch is server side, I do not think you need to do something on tryton client | 11:02 |
| mrichez | pokoli: MR 925 is on client | 11:03 |
| pokoli | yes but your issue is related to a server side validation and the commit I mentioned is on server side | 11:06 |
| pokoli | We have the same issue on a production database for one of our customers, doing the update fixed the problem | 11:06 |
| mrichez | pokoli: ok, thanks for explanations | 11:56 |
| -!- nicoe(~nicoe@2a02:2788:54:1ff:d654:8bff:fefd:e27e) has joined #tryton | 12:31 | |
| -!- springwurm(~springwur@2a01:76c0:100:f500:d139:7204:1356:b542) has joined #tryton | 13:14 | |
| -!- htgoebel(~Thunderbi@p200300d5df35fe00c929f6a4195b1784.dip0.t-ipconnect.de) has joined #tryton | 16:46 | |
| -!- nicoe(~nicoe@2a02:578:852a:c00:d654:8bff:fefd:e27e) has joined #tryton | 19:58 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 20:59 | |
| -!- ChanServ changed mode/#tryton -> +o cedk | 20:59 | |
| -!- udono(~udo@227-139-067-156.ip-addr.inexio.net) has joined #tryton | 21:45 | |
| -!- sharkcz(~sharkcz@85-71-161-19.rce.o2.cz) has joined #tryton | 22:28 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!