IRC logs of #tryton for Tuesday, 2019-10-08

chat.freenode.net #tryton log beginning Tue 08 Oct 2019 12:00:01 AM CEST
-!- fransuar_bio(~fran@45.224.188.186) has joined #tryton00:10
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton03:10
-!- thaneor1(~lenovo3@179.26.56.162) has joined #tryton04:10
-!- yangoon(~mathiasb@191-166-142-46.pool.kielnet.net) has joined #tryton04:10
-!- odicha(~odicha@91.142.107.66) has joined #tryton06:10
-!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton07:10
-!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton08:10
-!- mrichez(~Maxime@mail.saluc.com) has joined #tryton08:10
-!- rpit(~rpit@p200300C88F1AFC00E5271953866667B8.dip0.t-ipconnect.de) has joined #tryton08:10
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton08:10
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:10
-!- JanGB(~jan@2a02:810a:1440:64da:ad81:6d9e:2ef4:b78) has joined #tryton09:10
-!- JanGB(~jan@2a02:810a:1440:64da:ad81:6d9e:2ef4:b78) has left #tryton09:10
-!- odicha(~odicha@91.142.107.66) has joined #tryton10:10
-!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton11:10
-!- rpit(~rpit@p4FFB7CA1.dip0.t-ipconnect.de) has joined #tryton11:10
-!- nicoe(~nicoe@2a02:2788:54:5a3:7e2a:31ff:fe5e:b25d) has joined #tryton11:10
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton11:10
-!- mariomop(~quassel@host3.201-253-199.telecom.net.ar) has joined #tryton13:10
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton14:10
-!- smorillo(8965fb90@gateway/web/cgi-irc/kiwiirc.com/ip.137.101.251.144) has joined #tryton15:10
-!- thaneor(~lenovo3@179.26.107.254) has joined #tryton16:10
-!- sebste(~sebste@x4db58e5e.dyn.telefonica.de) has joined #tryton16:10
sebsteHi all! Got a little problem with upgrading tryton. I upgrades tryton and trytond and all my installed modules using "pip3 install --upgrade". I then wanted to upgrade dem modules using the client (Administration->Modules). This fails with an Application Error: Fault: no such column: a.month Traceback here: https://pastebin.com/d8XsW6L8 Any idea what I did wrong or how to fix it?17:10
pokolisebste: you should use the trytond-admin command to upgrade your database before connecting to the client17:10
pokolisebste: trytond-admin -d <db_name> --all -vv17:10
pokolisebste: where db name is your database name17:10
sebstepokoli: well I tried that before, but it gave the same results17:10
pokolisebste: you should probably also use the -c flag to specify the route to your config file. I will recomend having a look at the help of the trytond-admin command to see the available option17:10
sebsteYes, I did that, just tried again - exact same result: sqlite3.OperationalError: no such column: a.month17:10
sebsteIs it possible I forgot to upgrade a module? I thought pip3 takes care of dependencies?17:10
pokolisebste: you should exec that with the new version, not the older one17:10
sebstepokoli: sorry, what do you mean? You mean i should restart trytond before running trytond-admin?17:10
pokolisebste: from which version to which version are you migration?17:10
sebste5.217:10
sebste5.2.6 to 5.2.717:10
sebsteWell thats what trytond --version said17:10
sebsteModules are mostly 5.2.0 to 5.2.1 - thats a bit confusing17:10
pokolisebste: sorry but have you go17:10
pokolisebste: but it seems that you are mixing some list of modules17:10
pokolisebste: you should check that all the installed modules are from the same series (first two digits of the version)17:10
sebstepokoli: alright, I'llk check that, thanks for your help!17:10
sebsteOK, first two digits are all 5.217:10
sebstepokoli: thanks again. have a good one!17:10
cedksebste: could you check the schema of the table account_invoice_payment_term_line_delta17:10
-!- odicha(~odicha@91.142.107.66) has joined #tryton18:10
sebstecedk: sorry just saw your message right now. How would I do that?18:10
cedkwith sqlite3 and the command: .schema account_invoice_payment_term_line_delta18:10
sebstesqlite> .schema account_invoice_payment_term_line_delta18:10
sebsteCREATE TABLE IF NOT EXISTS "account_invoice_payment_term_line_delta" (id INTEGER PRIMARY KEY AUTOINCREMENT, "create_date" TIMESTAMP, "create_uid" INTEGER, "day" INTEGER, "days" INTEGER, "line" INTEGER, "months" INTEGER, "sequence" INTEGER, "weeks" INTEGER, "write_date" TIMESTAMP, "write_uid" INTEGER, "_temp_month" INTEGER, "weekday" INTEGER);18:10
cedksebste: hum, it looks that the migration did not run completly  on the first time18:10
cedkyou have _temp_ columns18:10
-!- odicha(~odicha@91.142.107.66) has joined #tryton18:10
sebstecedk: ok is there a way to redo it?18:10
cedksebste: I guess the best would be to rename _temp_month into month18:10
cedksebste: but rename column in SQLite is not easy18:10
cedkthat's also a reason for which we do not recommend to use sqlite backend for production18:10
sebstecedk: I see. I will try that later like so: https://www.sqlitetutorial.net/sqlite-rename-column/18:10
cedkso schema alteration on SQLite is not transactional that's bad18:10
sebstecedk: thanks for your help18:10
-!- odicha(~odicha@91.142.107.66) has joined #tryton18:10
sebstecedk: ill let you know whow it went. Do you think it is likely, that other tables might also be affected?18:10
-!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton18:10
cedksebste: I do not think because the process must have stopped in this particular migration otherwise the temp column would have been dropped18:10
sebsteok, I'll give it a shot. Thanks!19:10
-!- andrespoliti(~andrespol@200.50.173.5) has joined #tryton20:10
andrespolitihi, i started a docker instance of tryton as per the instructions in docker hub page https://hub.docker.com/r/tryton/tryton20:10
andrespolitibut when i open localhost:8000 i get no login dialog, only the tryton logo20:10
andrespolitii tried with the 5.2 and 5.0 images20:10
andrespolitiokey, it worked but i had to go to 0.0.0.0:800020:10
andrespolitinow i get a very weird error where the stacktrace has all the dots removed20:10
andrespoliti  File "/usr/local/lib/python35/dist-packages/trytond/backend/postgresql/databasepy", line 67, in execute20:10
andrespoliti    cursorexecute(self, sql, args)20:10
andrespolitipsycopg2ProgrammingError: column cactive does not exist20:10
andrespolitiLINE 1: id" = "b""group") WHERE ((("c""id" IN (1)) AND ("c""activ20:10
-!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton20:10
-!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton20:10
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton21:10
andrespolitiim running trytond 5.2 in docker and im getting a concurrency exception when i try to mark a module for activation21:10
andrespoliticould it be that my postgres container is in a different timezone than my trytond container?21:10
andrespolitithis is the output of date from trytond docker: Tue Oct  8 19:37:41 UTC 201921:10
andrespolitithis is the output of date from postgres docker: Tue 08 Oct 2019 07:37:46 PM UTC21:10
andrespolitithe same happens in my machine and in play-with-docker.com21:10
-!- sebste(~sebste@HSI-KBW-46-223-248-155.hsi.kabel-badenwuerttemberg.de) has joined #tryton22:10
-!- sebste(~sebste@HSI-KBW-46-223-248-155.hsi.kabel-badenwuerttemberg.de) has joined #tryton22:10
-!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton22:10

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