| chat.freenode.net #tryton log beginning Tue Sep 22 00:00:02 CEST 2009 | ||
| 2009-09-22 01:50 <CIA-2> vengfulsquirrel roundup * #1186/KeyError when completing inventory with deactivated products: [new] If a product was ever associated with a move and then you deactivate and then you try to complete an inventory you get this error. With the ... | ||
| 2009-09-22 01:50 <CIA-2> http://bugs.tryton.org/roundup/issue1186 | ||
| 2009-09-22 02:32 -!- woakas(n=woakas@190.144.69.234) has joined #tryton | ||
| 2009-09-22 03:40 -!- ikks_(n=ikks@190.158.100.203) has joined #tryton | ||
| 2009-09-22 05:19 -!- yangoon(n=mathiasb@p549F34C7.dip.t-dialin.net) has joined #tryton | ||
| 2009-09-22 07:08 <CIA-2> vengfulsquirrel roundup * #1187/Missing sequence_rename for shipment migration.: [new] I'm not sure if it was intentional but the sequences are not renamed when the packing->shipment tables are. I made a patch but since I'm no ... | ||
| 2009-09-22 07:08 <CIA-2> http://bugs.tryton.org/roundup/issue1187 | ||
| 2009-09-22 07:54 -!- MarkusB(n=burli@dslb-088-068-141-244.pools.arcor-ip.net) has joined #tryton | ||
| 2009-09-22 08:00 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton | ||
| 2009-09-22 08:05 <CIA-2> ced roundup * #1187/Missing sequence_rename for shipment migration.: [invalid] The sequence are renamed with table_rename | ||
| 2009-09-22 08:05 <CIA-2> http://bugs.tryton.org/roundup/issue1187 | ||
| 2009-09-22 08:09 -!- sharkcz(n=dan@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton | ||
| 2009-09-22 08:27 -!- carlos(n=carlos@173.156.221.87.dynamic.jazztel.es) has joined #tryton | ||
| 2009-09-22 08:29 -!- Timitos(n=timitos@88.217.184.172) has joined #tryton | ||
| 2009-09-22 08:31 <vengfulsquirrel> cedk: Hmm something weird seems to be happening, do I have to do anything for sequence renaming to take effect? | ||
| 2009-09-22 08:33 <cedk> vengfulsquirrel: it is done in the function rename_table | ||
| 2009-09-22 08:35 <vengfulsquirrel> Yeah I see now that the functions are identical, for some reason only the table is being renamed and the sequence is just recreated from scratch. | ||
| 2009-09-22 08:35 <vengfulsquirrel> I can't get the demo to reproduce the problem though so I guess maybe its something I've done that prevents it from happening. | ||
| 2009-09-22 08:36 -!- paepke(n=paepke@mail.metaldyne-nue.de) has joined #tryton | ||
| 2009-09-22 08:38 -!- dukai(n=quassel@77.46.176.142) has joined #tryton | ||
| 2009-09-22 08:42 <cedk> vengfulsquirrel: maybe if the sequence is not found then it is not renamed | ||
| 2009-09-22 09:10 -!- essich(n=essich@p4FCF9D6A.dip0.t-ipconnect.de) has joined #tryton | ||
| 2009-09-22 09:22 -!- bechamel(n=user@host-85-201-159-186.brutele.be) has joined #tryton | ||
| 2009-09-22 09:33 <vengfulsquirrel> cedk: Is the migration code only run via init=module_name ? | ||
| 2009-09-22 09:35 <cedk> vengfulsquirrel: also on update | ||
| 2009-09-22 09:45 <cedk> bechamel: http://hg.tryton.org/hgwebdir.cgi/modules/account_invoice/file/cb1385d2b448/invoice.py#l429 | ||
| 2009-09-22 09:46 <cedk> bechamel: the CAST doesn't seem to work with sqlite | ||
| 2009-09-22 09:46 <cedk> it returns a float | ||
| 2009-09-22 09:49 <bechamel> cedk: and it should be a decimal if I understand correctly | ||
| 2009-09-22 09:49 <cedk> bechamel: yes but sql doesn't run the adapter for it | ||
| 2009-09-22 09:53 <cedk> it seems that it is the sum that change the type | ||
| 2009-09-22 09:53 <bechamel> cedk: vengfulsquirrel: a fix for https://bugs.tryton.org/roundup/issue1186: http://codereview.appspot.com/121061 | ||
| 2009-09-22 09:56 <cedk> bechamel: put the codereview in roundup | ||
| 2009-09-22 09:58 <CIA-2> bch roundup * #1186/KeyError when completing inventory with deactivated products: | ||
| 2009-09-22 09:58 <CIA-2> [chatting] Fix available here: | ||
| 2009-09-22 09:58 <CIA-2> http://codereview.appspot.com/121061 | ||
| 2009-09-22 09:58 <CIA-2> http://bugs.tryton.org/roundup/issue1186 | ||
| 2009-09-22 10:09 <cedk> I read some doc and SQLite use float to make sum and CAST doesn't seem to make it call the adapter | ||
| 2009-09-22 10:09 <cedk> I can add a test after the query to convert the float into Decimal | ||
| 2009-09-22 10:10 <cedk> but we will have float operation where we need Decimal | ||
| 2009-09-22 10:14 <cedk> so this means that SQLite use never be use for critical accounting operation | ||
| 2009-09-22 10:15 <paepke> cedk: thats bad for SQLite... Cause the current common use case for tryton is ERP... | ||
| 2009-09-22 10:18 <bechamel> cedk: if someone is ready to do all the accounting by himself the odds are high that there are several users (and btw is quicker to install postgresql than to do all the account setup) | ||
| 2009-09-22 10:19 -!- yangoon1(n=mathiasb@p549F6AE5.dip.t-dialin.net) has joined #tryton | ||
| 2009-09-22 10:22 <vengfulsquirrel> bechamel: Thanks but I won't be able to try until tomorrow. | ||
| 2009-09-22 10:23 <cedk> paepke, bechamel: until now we always say that SQLite is beta for demo and testing | ||
| 2009-09-22 10:24 <paepke> cedk: i understand. for me postgres setup is the better solution. in any way. | ||
| 2009-09-22 10:24 -!- tekknokrat(n=gthieleb@dslb-088-074-151-144.pools.arcor-ip.net) has joined #tryton | ||
| 2009-09-22 10:25 <paepke> cedk: regarding to neso its an issue? | ||
| 2009-09-22 10:25 <paepke> is there something similar to mysql-embedded from the postgres guys? | ||
| 2009-09-22 10:26 <CIA-2> ced roundup * #1184/TypeError: unsupported operand type(s) for /: 'float' and 'Decimal': | ||
| 2009-09-22 10:26 <CIA-2> [testing] Patches to convert into Decimal after a sum for SQLite: | ||
| 2009-09-22 10:26 <CIA-2> http://codereview.appspot.com/121062 | ||
| 2009-09-22 10:26 <CIA-2> http://codereview.appspot.com/121063 | ||
| 2009-09-22 10:26 <CIA-2> http://bugs.tryton.org/roundup/issue1184 | ||
| 2009-09-22 10:28 <cedk> paepke: I don't know | ||
| 2009-09-22 10:38 <bechamel> cedk: "SQLite use never be use for critical accounting": otoh I know other ERP that does all the accounting in float :) | ||
| 2009-09-22 10:38 -!- paepke(n=paepke@mail.metaldyne.de) has joined #tryton | ||
| 2009-09-22 11:00 -!- tekknokrat(n=gthieleb@dslb-088-074-151-144.pools.arcor-ip.net) has left #tryton | ||
| 2009-09-22 11:11 -!- gour(n=Gour@87.252.146.13) has joined #tryton | ||
| 2009-09-22 11:20 <gour> hiya aa_ | ||
| 2009-09-22 11:20 <gour> aa_: what are you doing here? ;) | ||
| 2009-09-22 11:23 <yangoon1> bechamel: cedk I am really not pleased to have code in modules for SQLite issues. Even if the current proposals for patches are surely more accurate than to do SQLite accounting in float, I would prefer the latter. We ever said that SQlite is for demo and testing purposes, because it cannot handle some requirements, that other more capable DBMS are able to do. | ||
| 2009-09-22 11:25 <cedk> yangoon1: what is your solution? | ||
| 2009-09-22 11:25 <yangoon1> I think we should clarify explicetely whereever there is a place to do it, that the use of SQLite doesn't provide accurate results in some situations. | ||
| 2009-09-22 11:26 <cedk> yangoon1: simple sum of numerics return float | ||
| 2009-09-22 11:27 <yangoon1> cedk: the test should be done in SQLite backend | ||
| 2009-09-22 11:28 <yangoon1> cedk: wouldn't it be possible to look for calls for SUM and convert adequately? | ||
| 2009-09-22 11:30 <cedk> yangoon1: no except if you write an SQL parser | ||
| 2009-09-22 11:34 <yangoon1> cedk: If I see correctly there alrady are replacement actions in the sql in execute of Cursor | ||
| 2009-09-22 11:35 <cedk> yangoon1: a replacement will not fix | ||
| 2009-09-22 11:35 <yangoon1> cedk: yes, but it is 'kind' of sql parser | ||
| 2009-09-22 11:39 <cedk> yangoon1: it is far from a parser | ||
| 2009-09-22 11:40 <udono> yangoon1: are you talking about http://codereview.appspot.com/121062/diff/1/4 | ||
| 2009-09-22 11:40 <udono> ? | ||
| 2009-09-22 11:41 <yangoon1> udono: yes | ||
| 2009-09-22 11:41 <yangoon1> udono: and http://codereview.appspot.com/121063 | ||
| 2009-09-22 11:46 <yangoon1> for me the question is: couldn't we parse in line 257 of http://hg.tryton.org/hgwebdir.cgi/trytond/file/bf57d6085f20/trytond/backend/sqlite/database.py for SUM and convert the result by default to decimal? | ||
| 2009-09-22 11:48 <udono> yangoon1: but what if the sum needs to be integer? | ||
| 2009-09-22 11:50 <udono> yangoon1: and a working parser for SQL would be an ambitious project. | ||
| 2009-09-22 11:51 <yangoon1> anyone knows if sqlalchemy handles it? | ||
| 2009-09-22 11:52 <cedk> yangoon1: I check it and it doesn't seem to handle it | ||
| 2009-09-22 11:55 <udono> cedk: yangoon1: I found 0.5.0rc1: Added func.min(), func.max(), func.sum() as "generic functions", which basically allows for their return type to be determined automatically. Helps with dates on SQLite, decimal types, others. [ticket:1160] | ||
| 2009-09-22 11:55 <yangoon1> udono: just looking into the same... | ||
| 2009-09-22 11:56 <cedk> udono: url ? | ||
| 2009-09-22 11:56 <udono> http://svn.sqlalchemy.org/sqlalchemy/trunk/CHANGES | ||
| 2009-09-22 11:56 <udono> cedk: | ||
| 2009-09-22 12:00 -!- bechamel(n=user@host-85-201-159-186.brutele.be) has joined #tryton | ||
| 2009-09-22 12:02 <cedk> udono: it doesn't solve the issue | ||
| 2009-09-22 12:10 <cedk> udono, yangoon1 : one solution would have to fix sqlite to handle properly CAST | ||
| 2009-09-22 12:11 <yangoon1> cedk: ack, it would be THE solution | ||
| 2009-09-22 13:03 -!- ikks(n=ikks@190.158.100.203) has joined #tryton | ||
| 2009-09-22 14:15 <yangoon1> cedk: udono http://www.sqlite.org/src/tktview?name=a8b1e82b8f | ||
| 2009-09-22 14:25 <CIA-2> matb roundup * #1184/TypeError: unsupported operand type(s) for /: 'float' and 'Decimal': JFTR: Issue posted at http://www.sqlite.org/src/tktview?name=a8b1e82b8f | ||
| 2009-09-22 14:25 <CIA-2> http://bugs.tryton.org/roundup/issue1184 | ||
| 2009-09-22 14:33 -!- _TiN_(i=ahenze@190.0.162.41) has joined #tryton | ||
| 2009-09-22 15:18 -!- tekknokrat(n=gthieleb@dslb-088-074-151-144.pools.arcor-ip.net) has joined #tryton | ||
| 2009-09-22 15:18 -!- tekknokrat(n=gthieleb@dslb-088-074-151-144.pools.arcor-ip.net) has left #tryton | ||
| 2009-09-22 15:23 -!- woakas(n=woakas@190.144.69.234) has joined #tryton | ||
| 2009-09-22 16:03 <CIA-2> C?dric Krier <ced@b2ck.com> default * 29:46cc67c3c4c0 calendar/caldav.py: Add _log_exception | ||
| 2009-09-22 16:03 <CIA-2> http://hg.tryton.org/modules/calendar/rev/46cc67c3c4c0 | ||
| 2009-09-22 16:03 <CIA-2> C?dric Krier <ced@b2ck.com> default * 30:744e7ba86dbe calendar/calendar.py: Use BrowseRecord in _fbtype for easier extend | ||
| 2009-09-22 16:03 <CIA-2> http://hg.tryton.org/modules/calendar/rev/744e7ba86dbe | ||
| 2009-09-22 16:03 <CIA-2> C?dric Krier <ced@b2ck.com> default * 31:179de3a2af73 calendar/de_DE.csv: merge | ||
| 2009-09-22 16:03 <CIA-2> http://hg.tryton.org/modules/calendar/rev/179de3a2af73 | ||
| 2009-09-22 16:03 <CIA-2> C?dric Krier <ced@b2ck.com> default * 13:c329e54651bc calendar_todo/caldav.py: Remove print statement | ||
| 2009-09-22 16:03 <CIA-2> http://hg.tryton.org/modules/calendar_todo/rev/c329e54651bc | ||
| 2009-09-22 16:03 <CIA-2> C?dric Krier <ced@b2ck.com> default * 14:b1d0133c9c42 calendar_todo/ (__tryton__.py de_DE.csv): merge | ||
| 2009-09-22 16:03 <CIA-2> http://hg.tryton.org/modules/calendar_todo/rev/b1d0133c9c42 | ||
| 2009-09-22 16:09 <CIA-2> C?dric Krier <ced@b2ck.com> default * 370:c6f5c78e64e9 account_invoice/invoice.py: Fix SUM with SQLite for issue1184 | ||
| 2009-09-22 16:09 <CIA-2> http://hg.tryton.org/modules/account_invoice/rev/c6f5c78e64e9 | ||
| 2009-09-22 16:09 <CIA-2> ced roundup * #1184/TypeError: unsupported operand type(s) for /: 'float' and 'Decimal': [resolved] Fix with changeset c6f5c78e64e9 | ||
| 2009-09-22 16:09 <CIA-2> http://bugs.tryton.org/roundup/issue1184 | ||
| 2009-09-22 16:09 <CIA-2> C?dric Krier <ced@b2ck.com> default * 506:658f3b5c8c90 account/ (account.py move.py party.py tax.py): Fix SUM with SQLite for issue1184 | ||
| 2009-09-22 16:09 <CIA-2> http://hg.tryton.org/modules/account/rev/658f3b5c8c90 | ||
| 2009-09-22 16:26 -!- jerojasro(n=jerojasr@190.144.69.234) has joined #tryton | ||
| 2009-09-22 16:27 -!- jerojasro(n=jerojasr@190.144.69.234) has joined #tryton | ||
| 2009-09-22 16:44 <CIA-2> ced roundup * #1185/Localized year format in timesheet reports: | ||
| 2009-09-22 16:44 <CIA-2> [testing] Patch to review: | ||
| 2009-09-22 16:44 <CIA-2> http://codereview.appspot.com/121066 | ||
| 2009-09-22 16:44 <CIA-2> http://bugs.tryton.org/roundup/issue1185 | ||
| 2009-09-22 16:46 <CIA-2> C?dric Krier <ced@b2ck.com> default * 2020:1019bd97831c trytond/trytond/tools/misc.py: Use cast into int for range to prevent warning | ||
| 2009-09-22 16:46 <CIA-2> http://hg.tryton.org/trytond/rev/1019bd97831c | ||
| 2009-09-22 16:46 <CIA-2> C?dric Krier <ced@b2ck.com> default * 2021:fa8788a27292 trytond/trytond/tools/misc.py: merge | ||
| 2009-09-22 16:46 <CIA-2> http://hg.tryton.org/trytond/rev/fa8788a27292 | ||
| 2009-09-22 16:51 <CIA-2> ced roundup * #1180/KeyError: 'webdav.collection': I don't see the 401 in the dump | ||
| 2009-09-22 16:51 <CIA-2> http://bugs.tryton.org/roundup/issue1180 | ||
| 2009-09-22 17:43 <CIA-2> matb roundup * #1180/KeyError: 'webdav.collection': Second dump should contain whole sync trial. | ||
| 2009-09-22 17:43 <CIA-2> http://bugs.tryton.org/roundup/issue1180 | ||
| 2009-09-22 17:48 <CIA-2> ced roundup * #1180/KeyError: 'webdav.collection': Ok, I see it seems that it requests PROPFIND on root which is linked to any database and so it must not. So it is either a misconfiguration or an ... | ||
| 2009-09-22 17:48 <CIA-2> http://bugs.tryton.org/roundup/issue1180 | ||
| 2009-09-22 18:50 -!- yangoon(n=mathiasb@p549F6AE5.dip.t-dialin.net) has joined #tryton | ||
| 2009-09-22 18:51 <CIA-2> matb roundup * #1180/KeyError: 'webdav.collection': | ||
| 2009-09-22 18:51 <CIA-2> Just checked again configuration on the iphone, tried with terminating slash and without for URI: http://servername:8080/test_dav/Calendars/dav1/ | ||
| 2009-09-22 18:51 <CIA-2> ... | ||
| 2009-09-22 18:51 <CIA-2> http://bugs.tryton.org/roundup/issue1180 | ||
| 2009-09-22 19:01 <CIA-2> ced roundup * #1180/KeyError: 'webdav.collection': On 22/09/09 18:51 +0200, Mathias Behrle wrote: > > Mathias Behrle <mathias.behrle@gmx.de> added the comment: > > Just checked again configuratio ... | ||
| 2009-09-22 19:01 <CIA-2> http://bugs.tryton.org/roundup/issue1180 | ||
| 2009-09-22 19:43 -!- paepke(n=paepke@R8d4e.r.pppool.de) has joined #tryton | ||
| 2009-09-22 19:50 -!- vengfulsquirrel(n=plinux@216.170.122.150) has joined #tryton | ||
| 2009-09-22 20:13 -!- carlos(n=carlos@173.156.221.87.dynamic.jazztel.es) has joined #tryton | ||
| 2009-09-22 21:00 <vengfulsquirrel> If a product must be replaced what is the best method of operations? Create a return shipment from that sale with onyl the returned items on it and then create a custmer shipment with the new items on it ? | ||
| 2009-09-22 21:10 <cedk> vengfulsquirrel: why not. But it depends of the internal rules of your company | ||
| 2009-09-22 21:15 <vengfulsquirrel> cedk: Just checking to see if it was way off, yeah I'm making the internal rules right now I guess. Its pretty much do what you want now, but with a computerized element rules are mandatory to keep reality in sync with the computer. | ||
| 2009-09-22 21:16 <cedk> vengfulsquirrel: yes but you may perhaps want to make more tracks by creating a new Model for return with comments, etc. that will generate the shipment and other stuffs | ||
| 2009-09-22 21:23 <vengfulsquirrel> oh right, yeah but I'm just trying to get a working minimal system right now | ||
| 2009-09-22 21:23 <vengfulsquirrel> I have both nurseries trying to use the system now and all kinds of edge cases are cropping up. | ||
| 2009-09-22 22:19 <CIA-2> vengfulsquirrel roundup * #1186/KeyError when completing inventory with deactivated products: | ||
| 2009-09-22 22:19 <CIA-2> The patch prevents an exception but then results in this error: | ||
| 2009-09-22 22:19 <CIA-2> The value of the field "Product" on "Stock Inventory Line" is not valid accordi ... | ||
| 2009-09-22 22:19 <CIA-2> http://bugs.tryton.org/roundup/issue1186 | ||
| 2009-09-22 22:24 <CIA-2> bch roundup * #1186/KeyError when completing inventory with deactivated products: Yes inactive product shouldn't appear in the inventory, but the patch is still useful if the product is set inactive while it appears in in a draf ... | ||
| 2009-09-22 22:24 <CIA-2> http://bugs.tryton.org/roundup/issue1186 | ||
| 2009-09-22 22:31 -!- MarkusB(n=burli@dslb-088-068-141-244.pools.arcor-ip.net) has joined #tryton | ||
| 2009-09-22 23:10 <CIA-2> vengfulsquirrel roundup * #1186/KeyError when completing inventory with deactivated products: | ||
| 2009-09-22 23:10 <CIA-2> Yes but complete inventory button still will not work. | ||
| 2009-09-22 23:10 <CIA-2> Or at least its not working for me unless you don't specify specific products to invento ... | ||
| 2009-09-22 23:10 <CIA-2> http://bugs.tryton.org/roundup/issue1186 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!