| chat.freenode.net #tryton log beginning Tue 08 Oct 2019 12:00:01 AM CEST | ||
| -!- fransuar_bio(~fran@45.224.188.186) has joined #tryton | 22:13 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 01:11 | |
| -!- thaneor1(~lenovo3@179.26.56.162) has joined #tryton | 02:20 | |
| -!- yangoon(~mathiasb@191-166-142-46.pool.kielnet.net) has joined #tryton | 02:29 | |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 04:57 | |
| -!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton | 05:10 | |
| -!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton | 06:10 | |
| -!- mrichez(~Maxime@mail.saluc.com) has joined #tryton | 06:21 | |
| -!- rpit(~rpit@p200300C88F1AFC00E5271953866667B8.dip0.t-ipconnect.de) has joined #tryton | 06:38 | |
| -!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton | 06:42 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 07:53 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:ad81:6d9e:2ef4:b78) has joined #tryton | 07:57 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:ad81:6d9e:2ef4:b78) has left #tryton | 07:57 | |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 08:49 | |
| -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton | 09:12 | |
| -!- rpit(~rpit@p4FFB7CA1.dip0.t-ipconnect.de) has joined #tryton | 09:24 | |
| -!- nicoe(~nicoe@2a02:2788:54:5a3:7e2a:31ff:fe5e:b25d) has joined #tryton | 09:26 | |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 09:55 | |
| -!- mariomop(~quassel@host3.201-253-199.telecom.net.ar) has joined #tryton | 11:04 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 12:03 | |
| -!- smorillo(8965fb90@gateway/web/cgi-irc/kiwiirc.com/ip.137.101.251.144) has joined #tryton | 13:52 | |
| -!- thaneor(~lenovo3@179.26.107.254) has joined #tryton | 14:24 | |
| -!- sebste(~sebste@x4db58e5e.dyn.telefonica.de) has joined #tryton | 14:29 | |
| sebste | Hi 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? | 15:15 |
|---|---|---|
| pokoli | sebste: you should use the trytond-admin command to upgrade your database before connecting to the client | 15:21 |
| pokoli | sebste: trytond-admin -d <db_name> --all -vv | 15:21 |
| pokoli | sebste: where db name is your database name | 15:21 |
| sebste | pokoli: well I tried that before, but it gave the same results | 15:22 |
| pokoli | sebste: 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 option | 15:23 |
| sebste | Yes, I did that, just tried again - exact same result: sqlite3.OperationalError: no such column: a.month | 15:26 |
| sebste | Is it possible I forgot to upgrade a module? I thought pip3 takes care of dependencies? | 15:27 |
| pokoli | sebste: you should exec that with the new version, not the older one | 15:30 |
| sebste | pokoli: sorry, what do you mean? You mean i should restart trytond before running trytond-admin? | 15:32 |
| pokoli | sebste: from which version to which version are you migration? | 15:32 |
| sebste | 5.2 | 15:34 |
| sebste | 5.2.6 to 5.2.7 | 15:36 |
| sebste | Well thats what trytond --version said | 15:38 |
| sebste | Modules are mostly 5.2.0 to 5.2.1 - thats a bit confusing | 15:38 |
| pokoli | sebste: sorry but have you go | 15:44 |
| pokoli | sebste: but it seems that you are mixing some list of modules | 15:44 |
| pokoli | sebste: you should check that all the installed modules are from the same series (first two digits of the version) | 15:44 |
| sebste | pokoli: alright, I'llk check that, thanks for your help! | 15:45 |
| sebste | OK, first two digits are all 5.2 | 15:46 |
| sebste | pokoli: thanks again. have a good one! | 15:46 |
| cedk | sebste: could you check the schema of the table account_invoice_payment_term_line_delta | 15:59 |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 16:03 | |
| sebste | cedk: sorry just saw your message right now. How would I do that? | 16:17 |
| cedk | with sqlite3 and the command: .schema account_invoice_payment_term_line_delta | 16:19 |
| sebste | sqlite> .schema account_invoice_payment_term_line_delta | 16:21 |
| sebste | CREATE 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 |
| cedk | sebste: hum, it looks that the migration did not run completly on the first time | 16:24 |
| cedk | you have _temp_ columns | 16:24 |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 16:24 | |
| sebste | cedk: ok is there a way to redo it? | 16:26 |
| cedk | sebste: I guess the best would be to rename _temp_month into month | 16:27 |
| cedk | sebste: but rename column in SQLite is not easy | 16:28 |
| cedk | that's also a reason for which we do not recommend to use sqlite backend for production | 16:28 |
| sebste | cedk: I see. I will try that later like so: https://www.sqlitetutorial.net/sqlite-rename-column/ | 16:32 |
| cedk | so schema alteration on SQLite is not transactional that's bad | 16:33 |
| sebste | cedk: thanks for your help | 16:33 |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 16:34 | |
| sebste | cedk: ill let you know whow it went. Do you think it is likely, that other tables might also be affected? | 16:52 |
| -!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton | 16:53 | |
| cedk | sebste: I do not think because the process must have stopped in this particular migration otherwise the temp column would have been dropped | 16:59 |
| sebste | ok, I'll give it a shot. Thanks! | 17:00 |
| -!- andrespoliti(~andrespol@200.50.173.5) has joined #tryton | 18:32 | |
| andrespoliti | hi, i started a docker instance of tryton as per the instructions in docker hub page https://hub.docker.com/r/tryton/tryton | 18:33 |
| andrespoliti | but when i open localhost:8000 i get no login dialog, only the tryton logo | 18:33 |
| andrespoliti | i tried with the 5.2 and 5.0 images | 18:34 |
| andrespoliti | okey, it worked but i had to go to 0.0.0.0:8000 | 18:41 |
| andrespoliti | now i get a very weird error where the stacktrace has all the dots removed | 18:41 |
| andrespoliti | File "/usr/local/lib/python35/dist-packages/trytond/backend/postgresql/databasepy", line 67, in execute | 18:41 |
| andrespoliti | cursorexecute(self, sql, args) | 18:41 |
| andrespoliti | psycopg2ProgrammingError: column cactive does not exist | 18:41 |
| andrespoliti | LINE 1: id" = "b""group") WHERE ((("c""id" IN (1)) AND ("c""activ | 18:41 |
| -!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton | 18:50 | |
| -!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton | 18:56 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 19:21 | |
| andrespoliti | im running trytond 5.2 in docker and im getting a concurrency exception when i try to mark a module for activation | 19:31 |
| andrespoliti | could it be that my postgres container is in a different timezone than my trytond container? | 19:38 |
| andrespoliti | this is the output of date from trytond docker: Tue Oct 8 19:37:41 UTC 2019 | 19:39 |
| andrespoliti | this is the output of date from postgres docker: Tue 08 Oct 2019 07:37:46 PM UTC | 19:40 |
| andrespoliti | the same happens in my machine and in play-with-docker.com | 19:46 |
| -!- sebste(~sebste@HSI-KBW-46-223-248-155.hsi.kabel-badenwuerttemberg.de) has joined #tryton | 20:04 | |
| -!- sebste(~sebste@HSI-KBW-46-223-248-155.hsi.kabel-badenwuerttemberg.de) has joined #tryton | 20:04 | |
| -!- ubtel(~ubtel@ptr-fyom2pibfkkt7em0xe9.18120a2.ip6.access.telenet.be) has joined #tryton | 20:27 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!