| chat.freenode.net #tryton log beginning Thu Jan 21 12:00:02 AM CET 2021 | ||
| -!- xcodinas(~xcodinas@134.ip-5-196-28.eu) has joined #tryton | 23:18 | |
| -!- xcodinas(~xcodinas@unaffiliated/xcodinas) has joined #tryton | 23:18 | |
| -!- udono(~udono@091-057-210-188.ip-addr.inexio.net) has joined #tryton | 23:51 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 00:02 | |
| -!- srgdts(~srgdts@unaffiliated/srgdts) has joined #tryton | 02:05 | |
| -!- LordVan_(~LordVAn@gentoo/developer/LordVan) has joined #tryton | 03:45 | |
| -!- rat__(~LordVAn@gentoo/developer/LordVan) has joined #tryton | 04:50 | |
| -!- udono(~udono@091-057-210-188.ip-addr.inexio.net) has joined #tryton | 04:54 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 05:58 | |
| -!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton | 06:07 | |
| -!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton | 06:25 | |
| -!- thaneor2(~ldlc6@r167-61-141-143.dialup.adsl.anteldata.net.uy) has joined #tryton | 06:31 | |
| -!- thaneor3(~acer8@r167-61-141-143.dialup.adsl.anteldata.net.uy) has joined #tryton | 06:32 | |
| -!- Timitos(~kpreisler@2001:a61:578:ee01:762b:62ff:fe84:ed7e) has joined #tryton | 06:39 | |
| -!- rpit(~rpit@p200300c88f4cbb00cea2955fb3b32f1a.dip0.t-ipconnect.de) has joined #tryton | 07:02 | |
| LordVan | Hi | 07:28 |
|---|---|---|
| LordVan | I just noticed something .. peculiar .. | 07:28 |
| LordVan | it seems that tryton searches (party in this case) are case insensitive when it is non ASCII ? (talking about german umlauts ÖöÜüÄä here) | 07:29 |
| LordVan | is there a way to change/fix this easily? (I will look at the source later, but to be honest I am not sure where to start searching in this case) | 07:29 |
| LordVan | or is this a postgresql setting .. | 07:50 |
| LordVan | maybe .. postgres collation .. or I could make use of the unaccent extension of postgres and make rec_name unaccented .. not sure if that is a good idea or not though | 07:56 |
| LordVan | never mind .. my fault for not setting the correct collation when i created the DB here | 08:02 |
| -!- nicoe(~nicoe@2a02:578:852a:c00:7e2a:31ff:fe5e:b25d) has joined #tryton | 08:47 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 08:47 | |
| -!- thaneor(~ldlc6@r167-61-141-143.dialup.adsl.anteldata.net.uy) has joined #tryton | 09:38 | |
| pokoli | LordVan: if you activate the unnaccent extension in Postgres tryton will use it | 10:10 |
| udono | LordVan: Hi, I find it a little disrespectful cross posting your questions over multi channels and not close the other questions once you got an answer in one channel. | 10:31 |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 10:32 | |
| LordVan | udono, i cross - posted as it is quite relevant to german speakers .. and then I was afk so I just read the replies now | 10:57 |
| LordVan | pokoli, thanks. | 10:59 |
| mrichez | hi, need some help to update multiple columns at once. Got this error: cursor.execute(*sql_table.update( | 11:30 |
| mrichez | sqlite3.OperationalError: sub-select returns 6 columns - expected 1 | 11:30 |
| mrichez | here's my code: https://pastebin.com/ZvC69aQD | 11:32 |
| cedk | mrichez: I guess you must use an update-from: https://sqlite.org/lang_update.html#update_from | 11:35 |
| mrichez | cedk: ok will try this way, thanks! | 11:36 |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 12:53 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 13:07 | |
| -!- rpit(~rpit@p200300c88f4cbb00cea2955fb3b32f1a.dip0.t-ipconnect.de) has joined #tryton | 17:35 | |
| -!- lucascastro(~lucascast@177-185-139-41.dynamic.isotelco.net.br) has joined #tryton | 18:18 | |
| -!- thaneor1(~acer8@r167-61-10-204.dialup.adsl.anteldata.net.uy) has joined #tryton | 18:33 | |
| -!- thaneor2(~ldlc6@r167-61-10-204.dialup.adsl.anteldata.net.uy) has joined #tryton | 18:33 | |
| -!- yangoon(~mathiasb@p5dd08abd.dip0.t-ipconnect.de) has joined #tryton | 19:44 | |
| -!- lucascastro(~lucascast@177-185-131-162.corp.isotelco.net.br) has joined #tryton | 19:45 | |
| -!- lucascastro(~lucascast@177-185-131-162.corp.isotelco.net.br) has joined #tryton | 19:49 | |
| -!- lucascastro(~lucascast@177-185-139-41.dynamic.isotelco.net.br) has joined #tryton | 20:21 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!