| chat.freenode.net #tryton log beginning Mon 22 Jul 2019 12:00:01 AM CEST | ||
| -!- ubtel(~ubtel@ptr-fyom2pgyty5y2kk0si4.18120a2.ip6.access.telenet.be) has joined #tryton | 22:07 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 00:30 | |
| -!- yangoon(~mathiasb@106-162-142-46.pool.kielnet.net) has joined #tryton | 02:46 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 05:08 | |
| -!- rpit(~rpit@p200300C88F18D500344F4A8A86A72020.dip0.t-ipconnect.de) has joined #tryton | 06:36 | |
| -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | 06:43 | |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 06:52 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 07:10 | |
| -!- rpit(~rpit@p4FD192A6.dip0.t-ipconnect.de) has joined #tryton | 07:19 | |
| -!- smorillo(5ef87bd2@gateway/web/cgi-irc/kiwiirc.com/ip.94.248.123.210) has joined #tryton | 07:23 | |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 07:29 | |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 08:35 | |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 08:56 | |
| -!- smorillo(5ef87bd2@gateway/web/cgi-irc/kiwiirc.com/ip.94.248.123.210) has joined #tryton | 09:30 | |
| -!- jan_s904(~jan@pD9582A06.dip0.t-ipconnect.de) has joined #tryton | 09:32 | |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 10:36 | |
| -!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton | 10:51 | |
| -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | 10:51 | |
| -!- mariomop(~quassel@181.90.110.93) has joined #tryton | 11:20 | |
| -!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton | 11:23 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 12:01 | |
| -!- jan_s904(d9582a06@pD9582A06.dip0.t-ipconnect.de) has joined #tryton | 12:12 | |
| -!- udono(~udono@5.146.222.35) has joined #tryton | 12:17 | |
| -!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton | 12:29 | |
| -!- jan_sro(d9582a06@pD9582A06.dip0.t-ipconnect.de) has joined #tryton | 12:39 | |
| -!- jan_sro(d9582a06@pD9582A06.dip0.t-ipconnect.de) has joined #tryton | 12:53 | |
| jan_sro | Hello, I, have an issue in upgrading from 4.2.3 to 5.2.2 through the route 4.6. -> 4.8. -> 5.0 -> 5.2. I have taken into account the migration topics. | 12:53 |
|---|---|---|
| jan_sro | After upgrade, when I create a duplicate of an invoice the following message is shown:The value for field "Account" in "Invoice" is not valid according to its domain. | 12:53 |
| jan_sro | Tracing this to validate_relation_domain(field, records, Relation, domain) in model/modelstorage.py:field = <trytond.model.fields.many2one.Many2One object at 0x7f0c429aac50>records = [Pool().get('account.invoice')(294)]Relation = <class 'trytond.modules.account.account.Account'>domain = ('OR', (('id', 'in', (7,)), (('company', '=', 1), ('type.payab | 12:55 |
| jan_sro | le', '=', True)))) | 12:55 |
| jan_sro | Sorry for messing up: | 12:55 |
| jan_sro | field = <trytond.model.fields.many2one.Many2One object at 0x7f0c429aac50> | 12:55 |
| jan_sro | records = [Pool().get('account.invoice')(294)] | 12:55 |
| jan_sro | Relation = <class 'trytond.modules.account.account.Account'> | 12:55 |
| jan_sro | domain = ('OR', (('id', 'in', (7,)), (('company', '=', 1), ('type.payable', '=', True)))) | 12:55 |
| jan_sro | Furthermore under "Finance" / "Configuration" / "Account Configuration" the entries for Default Account Receivable, Payable, Revenue, Expense are empty. When I search for them by clicking on the magnifier, there are no search results. | 12:57 |
| jan_sro | Any help or pointers are greatly apreciated. | 12:58 |
| -!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton | 13:11 | |
| cedk | jan_sro: It looks like the chart of account has not been updated | 13:12 |
| cedk | jan_sro: it is probably because the account of the invoice has not a type with the receivable or payable flag | 13:12 |
| jan_sro | cedk: I have already tried that, but it didn't resolve the issue. | 13:12 |
| jan_sro | cedk: how can I check if the account of the invoice has the according type? | 13:14 |
| cedk | jan_sro: opening the account and check the type | 13:16 |
| jan_sro | cedk: Thanks Cédric, I checked "Main Payable" which is of type "Minimal Account Type Chart\Liability\Current\Payable" | 13:21 |
| jan_sro | cedk: how can I check if this type has the receivable or payable flag? | 13:21 |
| cedk | jan_sro: by opening the Payable type and look at the checkboxes | 13:23 |
| pokoli | jan_sro: you should probably update your char of accounts from the template | 13:23 |
| jan_sro | pokoli: Thanks pokoli, I already tried that, but didn't solve the issue. | 13:24 |
| pokoli | jan_sro: then you should manually update the checkboxes of the types | 13:24 |
| jan_sro | pokoli: I have opened different account types but can't locate any corresponding checkboxes. Could you help me find them? | 13:28 |
| -!- ubtel(~ubtel@ptr-377whsjprabucojkerpf.18120a2.ip6.access.telenet.be) has joined #tryton | 13:33 | |
| jan_sro | cedk: the account type (and also its parent types) only have a checkbox for "stock" shown. | 13:41 |
| jan_sro | cedk: I created a new database in paralel just to check and in this database there is also a flag for payable | 13:42 |
| jan_sro | cedk: is there any way to make these checkboxes appear? | 13:43 |
| cedk | jan_sro: maybe the data are not synchronized | 13:44 |
| cedk | jan_sro: in Administration > Models > Models > Data | 13:45 |
| jan_sro | cedk: I went to models / model / data and synchronised all before, however they remain in the tab "out of sync" | 13:45 |
| cedk | is someone know what is going on, we doubled the number of visitor today: http://moretus.b2ck.com/ | 13:45 |
| cedk | jan_sro: have you the last bugfix version? | 13:46 |
| pokoli | cedk: maybe somebody launching the CI proecess with hg.tryton.org? | 13:50 |
| cedk | pokoli: but it will not have so much unique IP | 13:54 |
| -!- jan_sro(~jan@pD9582A06.dip0.t-ipconnect.de) has joined #tryton | 13:55 | |
| -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | 13:58 | |
| -!- jan_sro(~jan@pD9582A06.dip0.t-ipconnect.de) has joined #tryton | 13:59 | |
| cedk | on discuss dashboard, I see an increasing of crawlers | 14:02 |
| cedk | so I guess it is linked to me registration to the webmaster tools of bing and yandex last week | 14:02 |
| cedk | jan_sro: so you should provide a sample of unsynchronized records | 14:05 |
| jan_sro | cedk: Thanks. The Models/Data now actually shows all entries with "Out of Sync" blank, however they remain listed in the tab "Out of Sync". I'll try to compare the ir_ tables with the new installation. | 14:13 |
| cedk | jan_sro: I do not understand | 14:14 |
| jan_sro | cedk: sorry, I oversaw that the max nr. of records is 1000. I went to synchronising them all, but journal_type_general, journal_type_revenue, journal_type_expense, journal_type_cash, journal_type_situation, journal_type_write_off refuse to sync, no error message is shown, they simply remain unsynched. | 14:27 |
| pokoli | jan_sro: could you export it's data? Especially the database value and the filesystem values? | 14:34 |
| pokoli | jan_sro: which trytond version are you runnning? | 14:35 |
| jan_sro | pokoli: trytond version 5.2.3 | 14:36 |
| jan_sro | pokoli: I can export its data. I can also help debug it if you give me a pointter where to start. | 14:37 |
| pokoli | jan_sro: we should try to understand why they are not syncronized | 14:40 |
| pokoli | jan_sro: probably the issue is here: http://hg.tryton.org/trytond/file/5.2/trytond/ir/model.py#l1255 | 14:40 |
| pokoli | this is the code which is executed when the sync button is pressed | 14:41 |
| jan_sro | pokoli: Is the method | 14:43 |
| jan_sro | Pokoli: OK, I'll set a breakpoint at the start of the function and step through. If you're interested, I can also send you the DB. | 14:45 |
| -!- udono(~udono@5.146.222.35) has joined #tryton | 14:46 | |
| pokoli | jan_sro: if you don't mind about sending the database backup it will be great to create a bug report with the backup attached | 14:48 |
| pokoli | jan_sro: so we can restore and test with the data | 14:48 |
| jan_sro | pokoli: which tables would you need? Do you need the complete DB? | 14:51 |
| pokoli | jan_sro: the information is only about ir_model_data and the out of sync records | 14:52 |
| jan_sro | pokoli: pool.get(data.model) throws an KeyError: 'account.journal.type' | 14:52 |
| pokoli | jan_sro: that's why I pointed about restoring | 14:52 |
| pokoli | jan_sro: that's because we changed the structure in 4.8 and this model no longer exists | 14:52 |
| jan_sro | pokoli: can I then leave tables with customer data out of the db dump? | 14:54 |
| cedk | jan_sro: that's normal journal type has been removed | 14:54 |
| pokoli | jan_sro: yes, but I think the issue should be reproducible on a fresh database | 14:54 |
| cedk | pokoli: we are missing a migration SQL for issue7451 | 14:55 |
| pokoli | cedk: a migration that update ir.model.data records? | 14:56 |
| cedk | pokoli: remove those from the model deleted | 15:05 |
| cedk | pokoli: it is done when XML data is removed but here as we remove the Model also I think it did not work | 15:05 |
| pokoli | cedk: done in https://discuss.tryton.org/t/migration-from-4-8-to-5-0/596 | 15:09 |
| pokoli | jan_sro: you should execute the sql_query I included on migration from 4.8 to 5.0 | 15:09 |
| jan_sro | pokoli: I executed the query: DELETE 6, afterwards there are no unsynched Model Data items left. However, the Account Types still don't show checkboxes for payable. | 15:15 |
| pokoli | jan_sro: which is the value of statment field of the type? | 15:16 |
| pokoli | jan_sro: payables are onl shown for balance statement types | 15:17 |
| cedk | jan_sro: did you update the chart of account after? | 15:17 |
| jan_sro | pokoli: it's empty, should I override the Template and configure accordingly? | 15:17 |
| pokoli | jan_sro: you should update the chart and the correct values should be set from the template | 15:18 |
| jan_sro | cedk: I didn't update the chart of accounts after the SQL, doing it right now. | 15:18 |
| jan_sro | cedk: It worked, now "Payable" is selected. | 15:20 |
| jan_sro | cedk: I can now also select the accounts in the Account Configuration, also Invoice Duplicatoin works! | 15:21 |
| jan_sro | Merci Cedric, thank you pokoli! | 15:30 |
| pokoli | jan_sro: you are welcome :) | 15:31 |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 15:42 | |
| -!- jcm(~jcm@78.194.214.115) has joined #tryton | 16:42 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 17:12 | |
| -!- csotelo_(~csotelo@190.234.41.50) has joined #tryton | 17:42 | |
| -!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton | 18:12 | |
| -!- ubtel_(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton | 18:23 | |
| -!- csotelo_(~csotelo@190.234.41.50) has joined #tryton | 19:17 | |
| -!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton | 19:24 | |
| -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | 20:01 | |
| -!- smorillo(250f6762@gateway/web/cgi-irc/kiwiirc.com/ip.37.15.103.98) has joined #tryton | 20:49 | |
| -!- csotelo_(~csotelo@190.234.41.50) has joined #tryton | 21:51 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!