IRC logs of #tryton for Wednesday, 2021-09-01

irc.libera.chat #tryton log beginning Wed Sep 1 12:00:01 AM CEST 2021
-!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton04:44
-!- timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton06:15
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton07:06
-!- ChanServ changed mode/#tryton -> +o cedk 07:06
-!- acaubet(~Thunderbi@194.224.31.235) has joined #tryton07:06
-!- springwurm(~springwur@5.104.149.54) has joined #tryton08:00
-!- nicoe(~nicoe@2a02:2788:54:1ff:18c2:1aff:fef9:2b7f) has joined #tryton08:24
-!- udono(~udono@068-137-067-156.ip-addr.inexio.net) has joined #tryton08:37
-!- udono1(~udono@068-137-067-156.ip-addr.inexio.net) has joined #tryton09:08
-!- nicoe(~nicoe@host-82-212-178-227.dynamic.voo.be) has joined #tryton09:08
-!- catonano(~catonano@151.50.177.254) has joined #tryton10:30
-!- springwurm(~springwur@5.104.149.54) has joined #tryton11:59
-!- barns(~barns@102.222.12.22) has joined #tryton12:19
barnsHi, quick question. I've not used tryton in quite a while (few years) but now have a need for a small project. I'm trying to set it up on a box that has Python 3.6.9 (which might be an issue?) but I'm running into a sqlite3.OperationalError when trying to initialise a database. Could this have something to do with the Python version or am I doing12:21
barnssomething else wrong.12:21
barns-> trytond-admin -v -c test.conf -d test --all12:26
barnsTraceback (most recent call last):12:26
barns  File "/home/redacted/tryton/venv/bin/trytond-admin", line 23, in <module>12:26
barns    admin.run(options)12:26
barns  File "/home/redacted/tryton/venv/lib/python3.6/site-packages/trytond/admin.py", line 31, in run12:26
barns    database.init()12:26
barns  File "/home/redacted/tryton/venv/lib/python3.6/site-packages/trytond/backend/sqlite/database.py", line 518, in init12:26
barns    cursor.execute(*insert)12:26
barnssqlite3.OperationalError: near "AS": syntax error12:26
barnsthis is the specific error12:26
pokolibarns: which tryton version are you using'12:44
barnsits a fresh install from pypi12:44
barnsso 6.0.512:45
pokolibarns: our test suite is working correctly on 6.0 series using sqlite: https://drone.tryton.org/tryton/trytond/775/1012:45
pokolibarns: maybe you are using an outdated sqlite version12:45
barnsthe installed sqlite binary seems to be 3.22.0 on this machine, does the python sqlite module use the system sqlite?12:47
barnsI've never really thought about it12:47
barnsits certainly quite a number of point releases behind, but is the latest available on Ubuntu 18.04 which is what this machine is12:48
-!- catonano(~catonano@151.50.177.254) has joined #tryton14:07
cedkFYI the problem come from this feature https://python-sql.tryton.org/bug7114:49
cedkwhich is only available on recent sqlite version14:49
cedkbut it is difficult to know when something was added to SQLite14:52
cedkany way SQLite is only used for testing14:52
-!- catonano(~catonano@151.50.177.254) has joined #tryton14:58
-!- catonano(~catonano@151.50.177.254) has joined #tryton15:14
-!- catonano(~catonano@151.50.177.254) has joined #tryton15:39
-!- catonano(~catonano@151.50.177.254) has joined #tryton15:44
-!- catonano(~catonano@151.50.177.254) has joined #tryton15:45
-!- catonano(~catonano@151.50.177.254) has joined #tryton16:12
-!- catonano(~catonano@151.50.177.254) has joined #tryton21:08

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