IRC logs of #tryton for Monday, 2019-07-22

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 #tryton22:07
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton00:30
-!- yangoon(~mathiasb@106-162-142-46.pool.kielnet.net) has joined #tryton02:46
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton05:08
-!- rpit(~rpit@p200300C88F18D500344F4A8A86A72020.dip0.t-ipconnect.de) has joined #tryton06:36
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton06:43
-!- odicha(~odicha@91.142.107.66) has joined #tryton06:52
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton07:10
-!- rpit(~rpit@p4FD192A6.dip0.t-ipconnect.de) has joined #tryton07:19
-!- smorillo(5ef87bd2@gateway/web/cgi-irc/kiwiirc.com/ip.94.248.123.210) has joined #tryton07:23
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton07:29
-!- odicha(~odicha@91.142.107.66) has joined #tryton08:35
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton08:56
-!- smorillo(5ef87bd2@gateway/web/cgi-irc/kiwiirc.com/ip.94.248.123.210) has joined #tryton09:30
-!- jan_s904(~jan@pD9582A06.dip0.t-ipconnect.de) has joined #tryton09:32
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton10:36
-!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton10:51
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton10:51
-!- mariomop(~quassel@181.90.110.93) has joined #tryton11:20
-!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton11:23
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton12:01
-!- jan_s904(d9582a06@pD9582A06.dip0.t-ipconnect.de) has joined #tryton12:12
-!- udono(~udono@5.146.222.35) has joined #tryton12:17
-!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton12:29
-!- jan_sro(d9582a06@pD9582A06.dip0.t-ipconnect.de) has joined #tryton12:39
-!- jan_sro(d9582a06@pD9582A06.dip0.t-ipconnect.de) has joined #tryton12:53
jan_sroHello, 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_sroAfter 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_sroTracing 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.payab12:55
jan_srole', '=', True))))12:55
jan_sroSorry for messing up:12:55
jan_srofield = <trytond.model.fields.many2one.Many2One object at 0x7f0c429aac50>12:55
jan_srorecords = [Pool().get('account.invoice')(294)]12:55
jan_sroRelation = <class 'trytond.modules.account.account.Account'>12:55
jan_srodomain = ('OR', (('id', 'in', (7,)), (('company', '=', 1), ('type.payable', '=', True))))12:55
jan_sroFurthermore 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_sroAny help or pointers are greatly apreciated.12:58
-!- ubtel(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton13:11
cedkjan_sro: It looks like the chart of account has not been updated13:12
cedkjan_sro: it is probably because the account of the invoice has not a type with the receivable or payable flag13:12
jan_srocedk: I have already tried that, but it didn't resolve the issue.13:12
jan_srocedk: how can I check if the account of the invoice has the according type?13:14
cedkjan_sro: opening the account and check the type13:16
jan_srocedk: Thanks Cédric, I checked "Main Payable" which is of type "Minimal Account Type Chart\Liability\Current\Payable"13:21
jan_srocedk: how can I check if this type has the receivable or payable flag?13:21
cedkjan_sro: by opening the Payable type and look at the checkboxes13:23
pokolijan_sro: you should probably update your char of accounts from the template13:23
jan_sropokoli: Thanks pokoli, I already tried that, but didn't solve the issue.13:24
pokolijan_sro: then you should manually update the checkboxes of the types13:24
jan_sropokoli: 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 #tryton13:33
jan_srocedk: the account type (and also its parent types) only have a checkbox for "stock" shown.13:41
jan_srocedk: I created a new database in paralel just to check and in this database there is also a flag for payable13:42
jan_srocedk: is there any way to make these checkboxes appear?13:43
cedkjan_sro: maybe the data are not synchronized13:44
cedkjan_sro: in Administration > Models > Models > Data13:45
jan_srocedk: I went to models / model / data and synchronised all  before, however they remain in the tab "out of sync"13:45
cedkis someone know what is going on, we doubled the number of visitor today: http://moretus.b2ck.com/13:45
cedkjan_sro: have you the last bugfix version?13:46
pokolicedk: maybe somebody launching the CI proecess with hg.tryton.org?13:50
cedkpokoli: but it will not have so much unique IP13:54
-!- jan_sro(~jan@pD9582A06.dip0.t-ipconnect.de) has joined #tryton13:55
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton13:58
-!- jan_sro(~jan@pD9582A06.dip0.t-ipconnect.de) has joined #tryton13:59
cedkon discuss dashboard, I see an increasing of crawlers14:02
cedkso I guess it is linked to me registration to the webmaster tools of bing and yandex last week14:02
cedkjan_sro: so you should provide a sample of unsynchronized records14:05
jan_srocedk: 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
cedkjan_sro: I do not understand14:14
jan_srocedk: 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
pokolijan_sro: could you export it's data? Especially the database value and the filesystem values?14:34
pokolijan_sro: which trytond version are you runnning?14:35
jan_sropokoli: trytond version 5.2.314:36
jan_sropokoli: I can export its data. I can also help debug it if you give me a pointter where to start.14:37
pokolijan_sro: we should try to understand why they are not syncronized14:40
pokolijan_sro: probably the issue is here: http://hg.tryton.org/trytond/file/5.2/trytond/ir/model.py#l125514:40
pokolithis is the code which is executed when the sync button is pressed14:41
jan_sropokoli: Is the method14:43
jan_sroPokoli: 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 #tryton14:46
pokolijan_sro: if you don't mind about sending the database backup it will be great to create a bug report with the backup attached14:48
pokolijan_sro: so we can restore and test with the data14:48
jan_sropokoli: which tables would you need? Do you need the complete DB?14:51
pokolijan_sro: the information is only about ir_model_data and the out of sync records14:52
jan_sropokoli: pool.get(data.model) throws an KeyError: 'account.journal.type'14:52
pokolijan_sro: that's why I pointed about restoring14:52
pokolijan_sro: that's because we changed the structure in 4.8 and this model no longer exists14:52
jan_sropokoli: can I then leave tables with customer data out of the db dump?14:54
cedkjan_sro: that's normal journal type has been removed14:54
pokolijan_sro: yes, but I think the issue should be reproducible on a fresh database14:54
cedkpokoli: we are missing a migration SQL for issue745114:55
pokolicedk: a migration that update ir.model.data records?14:56
cedkpokoli: remove those from the model deleted15:05
cedkpokoli: it is done when XML data is removed but here as we remove the Model also I think it did not work15:05
pokolicedk: done in https://discuss.tryton.org/t/migration-from-4-8-to-5-0/59615:09
pokolijan_sro: you should execute the sql_query I included on migration from 4.8 to 5.015:09
jan_sropokoli: 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
pokolijan_sro: which is the value of statment field of the type?15:16
pokolijan_sro: payables are onl shown for balance statement types15:17
cedkjan_sro: did you update the chart of account after?15:17
jan_sropokoli: it's empty, should I override the Template and configure accordingly?15:17
pokolijan_sro: you should update the chart and the correct values should be set from the template15:18
jan_srocedk: I didn't update the chart of accounts after the SQL, doing it right now.15:18
jan_srocedk: It worked, now "Payable" is selected.15:20
jan_srocedk: I can now also select the accounts in the Account Configuration, also Invoice Duplicatoin works!15:21
jan_sroMerci Cedric, thank you pokoli!15:30
pokolijan_sro: you are welcome :)15:31
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton15:42
-!- jcm(~jcm@78.194.214.115) has joined #tryton16:42
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton17:12
-!- csotelo_(~csotelo@190.234.41.50) has joined #tryton17:42
-!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton18:12
-!- ubtel_(~ubtel@78-22-29-42.access.telenet.be) has joined #tryton18:23
-!- csotelo_(~csotelo@190.234.41.50) has joined #tryton19:17
-!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton19:24
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton20:01
-!- smorillo(250f6762@gateway/web/cgi-irc/kiwiirc.com/ip.37.15.103.98) has joined #tryton20:49
-!- csotelo_(~csotelo@190.234.41.50) has joined #tryton21:51

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!