IRC logs of #tryton for Tuesday, 2019-10-08 #tryton log beginning Tue 08 Oct 2019 12:00:01 AM CEST
-!- fransuar_bio(~fran@ has joined #tryton22:13
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton01:11
-!- thaneor1(~lenovo3@ has joined #tryton02:20
-!- yangoon( has joined #tryton02:29
-!- odicha(~odicha@ has joined #tryton04:57
-!- ubtel( has joined #tryton05:10
-!- ubtel( has joined #tryton06:10
-!- mrichez( has joined #tryton06:21
-!- rpit( has joined #tryton06:38
-!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton06:42
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton07:53
-!- JanGB(~jan@2a02:810a:1440:64da:ad81:6d9e:2ef4:b78) has joined #tryton07:57
-!- JanGB(~jan@2a02:810a:1440:64da:ad81:6d9e:2ef4:b78) has left #tryton07:57
-!- odicha(~odicha@ has joined #tryton08:49
-!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton09:12
-!- rpit( has joined #tryton09:24
-!- nicoe(~nicoe@2a02:2788:54:5a3:7e2a:31ff:fe5e:b25d) has joined #tryton09:26
-!- nicoe( has joined #tryton09:55
-!- mariomop( has joined #tryton11:04
-!- springwurm(~Springwur@ has joined #tryton12:03
-!- smorillo(8965fb90@gateway/web/cgi-irc/ has joined #tryton13:52
-!- thaneor(~lenovo3@ has joined #tryton14:24
-!- sebste( has joined #tryton14:29
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: Any idea what I did wrong or how to fix it?15:15
pokolisebste: you should use the trytond-admin command to upgrade your database before connecting to the client15:21
pokolisebste: trytond-admin -d <db_name> --all -vv15:21
pokolisebste: where db name is your database name15:21
sebstepokoli: well I tried that before, but it gave the same results15:22
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 option15:23
sebsteYes, I did that, just tried again - exact same result: sqlite3.OperationalError: no such column: a.month15:26
sebsteIs it possible I forgot to upgrade a module? I thought pip3 takes care of dependencies?15:27
pokolisebste: you should exec that with the new version, not the older one15:30
sebstepokoli: sorry, what do you mean? You mean i should restart trytond before running trytond-admin?15:32
pokolisebste: from which version to which version are you migration?15:32
sebste5.2.6 to 5.2.715:36
sebsteWell thats what trytond --version said15:38
sebsteModules are mostly 5.2.0 to 5.2.1 - thats a bit confusing15:38
pokolisebste: sorry but have you go15:44
pokolisebste: but it seems that you are mixing some list of modules15:44
pokolisebste: you should check that all the installed modules are from the same series (first two digits of the version)15:44
sebstepokoli: alright, I'llk check that, thanks for your help!15:45
sebsteOK, first two digits are all 5.215:46
sebstepokoli: thanks again. have a good one!15:46
cedksebste: could you check the schema of the table account_invoice_payment_term_line_delta15:59
-!- odicha(~odicha@ has joined #tryton16:03
sebstecedk: sorry just saw your message right now. How would I do that?16:17
cedkwith sqlite3 and the command: .schema account_invoice_payment_term_line_delta16:19
sebstesqlite> .schema account_invoice_payment_term_line_delta16:21
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);16:21
cedksebste: hum, it looks that the migration did not run completly  on the first time16:24
cedkyou have _temp_ columns16:24
-!- odicha(~odicha@ has joined #tryton16:24
sebstecedk: ok is there a way to redo it?16:26
cedksebste: I guess the best would be to rename _temp_month into month16:27
cedksebste: but rename column in SQLite is not easy16:28
cedkthat's also a reason for which we do not recommend to use sqlite backend for production16:28
sebstecedk: I see. I will try that later like so:
cedkso schema alteration on SQLite is not transactional that's bad16:33
sebstecedk: thanks for your help16:33
-!- odicha(~odicha@ has joined #tryton16:34
sebstecedk: ill let you know whow it went. Do you think it is likely, that other tables might also be affected?16:52
-!- ubtel( has joined #tryton16:53
cedksebste: I do not think because the process must have stopped in this particular migration otherwise the temp column would have been dropped16:59
sebsteok, I'll give it a shot. Thanks!17:00
-!- andrespoliti(~andrespol@ has joined #tryton18:32
andrespolitihi, i started a docker instance of tryton as per the instructions in docker hub page
andrespolitibut when i open localhost:8000 i get no login dialog, only the tryton logo18:33
andrespolitii tried with the 5.2 and 5.0 images18:34
andrespolitiokey, it worked but i had to go to
andrespolitinow i get a very weird error where the stacktrace has all the dots removed18:41
andrespoliti  File "/usr/local/lib/python35/dist-packages/trytond/backend/postgresql/databasepy", line 67, in execute18:41
andrespoliti    cursorexecute(self, sql, args)18:41
andrespolitipsycopg2ProgrammingError: column cactive does not exist18:41
andrespolitiLINE 1: id" = "b""group") WHERE ((("c""id" IN (1)) AND ("c""activ18:41
-!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton18:50
-!- ubtel( has joined #tryton18:56
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton19:21
andrespolitiim running trytond 5.2 in docker and im getting a concurrency exception when i try to mark a module for activation19:31
andrespoliticould it be that my postgres container is in a different timezone than my trytond container?19:38
andrespolitithis is the output of date from trytond docker: Tue Oct  8 19:37:41 UTC 201919:39
andrespolitithis is the output of date from postgres docker: Tue 08 Oct 2019 07:37:46 PM UTC19:40
andrespolitithe same happens in my machine and in play-with-docker.com19:46
-!- sebste( has joined #tryton20:04
-!- sebste( has joined #tryton20:04
-!- ubtel( has joined #tryton20:27

Generated by 2.17.3 by Marius Gedminas - find it at!