IRC logs of #tryton for Wednesday, 2016-12-07

chat.freenode.net #tryton log beginning Wed Dec 7 00:00:01 CET 2016
-!- kstenger1(~karla@r190-133-241-233.dialup.adsl.anteldata.net.uy) has joined #tryton00:48
-!- morfeokmg(~smuxi@201.130.57.144) has joined #tryton01:10
-!- morfeokmg_(~Mutter@200.68.129.184) has joined #tryton01:13
-!- nicoe(~nicoe@183.182.115.224) has joined #tryton03:29
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton03:33
-!- morfeokmg(~smuxi@189.146.42.144) has joined #tryton04:06
-!- thaneor1(~ldlc6@179.26.60.29) has joined #tryton04:38
-!- JosDzGx(~Thunderbi@fixed-188-72-187-188-72-36.iusacell.net) has joined #tryton07:13
-!- estan_(~astan@90-231-138-16-no13.tbcn.telia.com) has joined #tryton07:14
-!- dj_xatra(~dj_xatra@217.166.83.130) has joined #tryton07:50
-!- apostatize(~visavis@unaffiliated/apostatize) has joined #tryton08:11
-!- rpit(~rpit@aftr-37-24-151-3.unity-media.net) has joined #tryton08:25
-!- morfeokmg(~smuxi@189.146.42.144) has joined #tryton08:44
-!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton08:50
-!- pokoli2(5b7e4c02@gateway/web/freenode/ip.91.126.76.2) has joined #tryton08:59
-!- pokoli2(5b7e4c02@gateway/web/freenode/ip.91.126.76.2) has left #tryton09:00
-!- mrichez(~smuxi@mail.saluc.com) has joined #tryton09:01
-!- flachtassekasse(~flachtass@p5DD1863C.dip0.t-ipconnect.de) has joined #tryton09:21
-!- udono(~udono@tmo-100-59.customers.d1-online.com) has joined #tryton09:51
-!- elbenfreund(~elbenfreu@87.172.158.6) has joined #tryton10:16
-!- pokoli(~pokoli@mail.koolpi.com) has joined #tryton11:19
-!- pokoli(~pokoli@mail.koolpi.com) has joined #tryton11:20
-!- pokoli(~pokoli@mail.koolpi.com) has joined #tryton11:22
-!- flachtassekasse(~flachtass@p5DD18CD2.dip0.t-ipconnect.de) has joined #tryton11:47
-!- elbenfreund(~elbenfreu@p57AC9E06.dip0.t-ipconnect.de) has joined #tryton11:55
-!- mariomop(~quassel@host216.186-125-122.telecom.net.ar) has joined #tryton12:06
-!- smarro(~sebastian@181.16.7.104) has joined #tryton13:22
-!- tryingtryton(94002863@gateway/web/freenode/ip.148.0.40.99) has joined #tryton13:37
-!- flachtassekasse(~flachtass@p5DD18CD2.dip0.t-ipconnect.de) has joined #tryton14:00
-!- kstenger(~karla@r167-56-243-101.dialup.adsl.anteldata.net.uy) has joined #tryton14:10
tryingtrytonAdding and saving a new Location and getting this:  The value "en_US" of field "Language" on "Translation" is not in the selection.14:32
pokolitryingtryton: which version are you using?14:33
tryingtryton4.2, updated from 4.014:34
tryingtrytonagainst pgsql db14:34
pokolitryingtryton: languages have been updated to 2 digits on 4.214:34
pokolitryingtryton: have yo updated your translations on the database?14:34
pokolitryingtryton: see: https://discuss.tryton.org/t/migration-from-4-0-to-4-2/16114:34
tryingtrytonI get: "duplicate key value violates unique contraint 'ir_translation_translation_md5_uniq'14:36
tryingtrytondetail: key (name, res_id, lang, type, src_md5, module)=(webdav.share,user, -1, en, field, $MD%, webdav) already exists14:37
-!- mamcode_(~mamcode@190-204-2-151.dyn.dsl.cantv.net) has joined #tryton14:38
pokolitryingtryton: because this should be done before updating the database14:40
tryingtrytonso, what's the fix?14:40
pokolitryingtryton: in your case I think you should only update the ones that don't come from a module14:41
pokolitryingtryton: so adding where module is null should fix the problem14:41
tryingtrytonThat query worked, but i get the warning upon saving the location still.14:44
tryingtrytonprobably because the update query matched zero records14:46
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton14:48
tryingtrytonThere's >13k entries with en_US and >6k with en.14:52
tryingtrytonany other way to convert those?14:54
tryingtrytonpokoli: ?15:01
pokolitryingtryton: probabilly all the en_US are duplicated, as when upgradint to 4.2 you created the new translations for en_US15:03
tryingtrytonThen, those could be deleted safely?15:04
pokolitryingtryton: you should update the translations of database records, for example custom locations products15:04
tryingtrytonpokoli: That's basically what i'm asking you how to do. There's no lang or lang_id field in stock_location.15:08
pokolitryingtryton: the name field is translatable, and the translation is stored on the ir_translation table15:09
pokolitryingtryton: btw, do you have the main_language set on trytond.conf file?15:11
tryingtrytoncrap, it was en_US still15:11
tryingtrytonOK, changing that and restarting the server worked.15:13
pokolitryingtryton: default value is en, so if you remove it you will not have to worry on the future ;)15:13
pokolitryingtryton: you still have to update custom translations (product names, discriptions) for other languages than main language15:14
pokolitryingtryton: main language is stored on the table, so don't need to worry about it15:14
tryingtrytonIs there a quick way to see which of those 13k entries are "custom"?15:17
pokolitryingtryton: it depends on the modules installed, but they are for all the translatable fields in the database15:28
pokolitryingtryton: translatable fields are those that have a flag in the field15:28
-!- sebd(~seb@aditu.ldd.fr) has joined #tryton15:28
pokolitryingtryton: for example: the product.tempalte name, the product.product description the payment_term name and description15:32
-!- morfeokmg(~smuxi@189.146.42.144) has joined #tryton15:33
tryingtrytonpokoli: I'm looking for a query to run against the DB to find all those easily.15:58
pokolitryingtryton: it will be great if you can share it :)16:04
-!- JanGB(~jan@x59cc9a10.dyn.telefonica.de) has joined #tryton16:40
-!- thaneor(~ldlc6@179.26.117.254) has joined #tryton16:41
-!- JanGB(~jan@x59cc8b42.dyn.telefonica.de) has joined #tryton17:15
-!- rpit(~rpit@aftr-37-24-151-3.unity-media.net) has joined #tryton17:29
-!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton18:14
-!- JanGB(~jan@dslb-088-073-246-007.088.073.pools.vodafone-ip.de) has joined #tryton18:22
tryingtrytonpokoli:  It's a two-part query:18:44
tryingtrytonDELETE FROM ir_translation where id in (SELECT x.id from ir_translation as x, ir_translation as y where x.name = y.name and x.res_id = y.res_id and x.type=y.type and x.src_md5 = y.src_md5 and x.module=y.module and x.lang ='en_US' and y.lang='en' ) ;18:45
tryingtrytonUPDATE ir_translation set lang = 'en' where lang = 'en_US';18:45
tryingtrytonYou might want to move that update query from "should" to "must", and consider adding the above two in case someone forgot or didn't read the docs.18:49
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton19:34
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton19:48
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton20:05
-!- udono(~udono@tmo-100-59.customers.d1-online.com) has joined #tryton20:09
-!- Timitos(~kpreisler@tmo-109-157.customers.d1-online.com) has joined #tryton20:36
-!- udono(~udono@tmo-100-59.customers.d1-online.com) has joined #tryton20:41
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton20:53
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton21:03
-!- JanGB(~jan@dslb-088-073-246-007.088.073.pools.vodafone-ip.de) has joined #tryton21:34
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton21:36
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton22:08
tryingtrytonWhat's the next step in the workflow after processing a sale?22:24
kstengertryingtryton: you continue with the shipments to send the associated goods22:29
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton22:34
tryingtrytonI'm seeing the sale amount getting debited from the warehouse. If i have other locations with the product (from the warehouse via internal moves), how do i sell from those locations as  well?22:35
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton22:53
-!- JanGB(~jan@dslb-088-073-246-007.088.073.pools.vodafone-ip.de) has joined #tryton23:17
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton23:19
-!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton23:40

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!