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

chat.freenode.net #tryton log beginning Wed Dec 7 00:00:01 CET 2016
2016-12-07 00:48 -!- kstenger1(~karla@r190-133-241-233.dialup.adsl.anteldata.net.uy) has joined #tryton
2016-12-07 01:10 -!- morfeokmg(~smuxi@201.130.57.144) has joined #tryton
2016-12-07 01:13 -!- morfeokmg_(~Mutter@200.68.129.184) has joined #tryton
2016-12-07 03:29 -!- nicoe(~nicoe@183.182.115.224) has joined #tryton
2016-12-07 03:33 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2016-12-07 04:06 -!- morfeokmg(~smuxi@189.146.42.144) has joined #tryton
2016-12-07 04:38 -!- thaneor1(~ldlc6@179.26.60.29) has joined #tryton
2016-12-07 07:13 -!- JosDzGx(~Thunderbi@fixed-188-72-187-188-72-36.iusacell.net) has joined #tryton
2016-12-07 07:14 -!- estan_(~astan@90-231-138-16-no13.tbcn.telia.com) has joined #tryton
2016-12-07 07:50 -!- dj_xatra(~dj_xatra@217.166.83.130) has joined #tryton
2016-12-07 08:11 -!- apostatize(~visavis@unaffiliated/apostatize) has joined #tryton
2016-12-07 08:25 -!- rpit(~rpit@aftr-37-24-151-3.unity-media.net) has joined #tryton
2016-12-07 08:44 -!- morfeokmg(~smuxi@189.146.42.144) has joined #tryton
2016-12-07 08:50 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2016-12-07 08:59 -!- pokoli2(5b7e4c02@gateway/web/freenode/ip.91.126.76.2) has joined #tryton
2016-12-07 09:00 -!- pokoli2(5b7e4c02@gateway/web/freenode/ip.91.126.76.2) has left #tryton
2016-12-07 09:01 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 09:21 -!- flachtassekasse(~flachtass@p5DD1863C.dip0.t-ipconnect.de) has joined #tryton
2016-12-07 09:51 -!- udono(~udono@tmo-100-59.customers.d1-online.com) has joined #tryton
2016-12-07 10:16 -!- elbenfreund(~elbenfreu@87.172.158.6) has joined #tryton
2016-12-07 11:19 -!- pokoli(~pokoli@mail.koolpi.com) has joined #tryton
2016-12-07 11:20 -!- pokoli(~pokoli@mail.koolpi.com) has joined #tryton
2016-12-07 11:22 -!- pokoli(~pokoli@mail.koolpi.com) has joined #tryton
2016-12-07 11:47 -!- flachtassekasse(~flachtass@p5DD18CD2.dip0.t-ipconnect.de) has joined #tryton
2016-12-07 11:55 -!- elbenfreund(~elbenfreu@p57AC9E06.dip0.t-ipconnect.de) has joined #tryton
2016-12-07 12:06 -!- mariomop(~quassel@host216.186-125-122.telecom.net.ar) has joined #tryton
2016-12-07 13:22 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2016-12-07 13:37 -!- tryingtryton(94002863@gateway/web/freenode/ip.148.0.40.99) has joined #tryton
2016-12-07 14:00 -!- flachtassekasse(~flachtass@p5DD18CD2.dip0.t-ipconnect.de) has joined #tryton
2016-12-07 14:10 -!- kstenger(~karla@r167-56-243-101.dialup.adsl.anteldata.net.uy) has joined #tryton
2016-12-07 14:32 <tryingtryton> Adding and saving a new Location and getting this: The value "en_US" of field "Language" on "Translation" is not in the selection.
2016-12-07 14:33 <pokoli> tryingtryton: which version are you using?
2016-12-07 14:34 <tryingtryton> 4.2, updated from 4.0
2016-12-07 14:34 <tryingtryton> against pgsql db
2016-12-07 14:34 <pokoli> tryingtryton: languages have been updated to 2 digits on 4.2
2016-12-07 14:34 <pokoli> tryingtryton: have yo updated your translations on the database?
2016-12-07 14:34 <pokoli> tryingtryton: see: https://discuss.tryton.org/t/migration-from-4-0-to-4-2/161
2016-12-07 14:36 <tryingtryton> I get: "duplicate key value violates unique contraint 'ir_translation_translation_md5_uniq'
2016-12-07 14:37 <tryingtryton> detail: key (name, res_id, lang, type, src_md5, module)=(webdav.share,user, -1, en, field, $MD%, webdav) already exists
2016-12-07 14:38 -!- mamcode_(~mamcode@190-204-2-151.dyn.dsl.cantv.net) has joined #tryton
2016-12-07 14:40 <pokoli> tryingtryton: because this should be done before updating the database
2016-12-07 14:40 <tryingtryton> so, what's the fix?
2016-12-07 14:41 <pokoli> tryingtryton: in your case I think you should only update the ones that don't come from a module
2016-12-07 14:41 <pokoli> tryingtryton: so adding where module is null should fix the problem
2016-12-07 14:44 <tryingtryton> That query worked, but i get the warning upon saving the location still.
2016-12-07 14:46 <tryingtryton> probably because the update query matched zero records
2016-12-07 14:48 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2016-12-07 14:52 <tryingtryton> There's >13k entries with en_US and >6k with en.
2016-12-07 14:54 <tryingtryton> any other way to convert those?
2016-12-07 15:01 <tryingtryton> pokoli: ?
2016-12-07 15:03 <pokoli> tryingtryton: probabilly all the en_US are duplicated, as when upgradint to 4.2 you created the new translations for en_US
2016-12-07 15:04 <tryingtryton> Then, those could be deleted safely?
2016-12-07 15:04 <pokoli> tryingtryton: you should update the translations of database records, for example custom locations products
2016-12-07 15:08 <tryingtryton> pokoli: That's basically what i'm asking you how to do. There's no lang or lang_id field in stock_location.
2016-12-07 15:09 <pokoli> tryingtryton: the name field is translatable, and the translation is stored on the ir_translation table
2016-12-07 15:11 <pokoli> tryingtryton: btw, do you have the main_language set on trytond.conf file?
2016-12-07 15:11 <tryingtryton> crap, it was en_US still
2016-12-07 15:13 <tryingtryton> OK, changing that and restarting the server worked.
2016-12-07 15:13 <pokoli> tryingtryton: default value is en, so if you remove it you will not have to worry on the future ;)
2016-12-07 15:14 <pokoli> tryingtryton: you still have to update custom translations (product names, discriptions) for other languages than main language
2016-12-07 15:14 <pokoli> tryingtryton: main language is stored on the table, so don't need to worry about it
2016-12-07 15:17 <tryingtryton> Is there a quick way to see which of those 13k entries are "custom"?
2016-12-07 15:28 <pokoli> tryingtryton: it depends on the modules installed, but they are for all the translatable fields in the database
2016-12-07 15:28 <pokoli> tryingtryton: translatable fields are those that have a flag in the field
2016-12-07 15:28 -!- sebd(~seb@aditu.ldd.fr) has joined #tryton
2016-12-07 15:32 <pokoli> tryingtryton: for example: the product.tempalte name, the product.product description the payment_term name and description
2016-12-07 15:33 -!- morfeokmg(~smuxi@189.146.42.144) has joined #tryton
2016-12-07 15:58 <tryingtryton> pokoli: I'm looking for a query to run against the DB to find all those easily.
2016-12-07 16:04 <pokoli> tryingtryton: it will be great if you can share it :)
2016-12-07 16:40 -!- JanGB(~jan@x59cc9a10.dyn.telefonica.de) has joined #tryton
2016-12-07 16:41 -!- thaneor(~ldlc6@179.26.117.254) has joined #tryton
2016-12-07 17:15 -!- JanGB(~jan@x59cc8b42.dyn.telefonica.de) has joined #tryton
2016-12-07 17:29 -!- rpit(~rpit@aftr-37-24-151-3.unity-media.net) has joined #tryton
2016-12-07 18:14 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton
2016-12-07 18:22 -!- JanGB(~jan@dslb-088-073-246-007.088.073.pools.vodafone-ip.de) has joined #tryton
2016-12-07 18:44 <tryingtryton> pokoli: It's a two-part query:
2016-12-07 18:45 <tryingtryton> DELETE 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' ) ;
2016-12-07 18:45 <tryingtryton> UPDATE ir_translation set lang = 'en' where lang = 'en_US';
2016-12-07 18:49 <tryingtryton> You 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.
2016-12-07 19:34 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 19:48 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 20:05 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 20:09 -!- udono(~udono@tmo-100-59.customers.d1-online.com) has joined #tryton
2016-12-07 20:36 -!- Timitos(~kpreisler@tmo-109-157.customers.d1-online.com) has joined #tryton
2016-12-07 20:41 -!- udono(~udono@tmo-100-59.customers.d1-online.com) has joined #tryton
2016-12-07 20:53 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 21:03 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 21:34 -!- JanGB(~jan@dslb-088-073-246-007.088.073.pools.vodafone-ip.de) has joined #tryton
2016-12-07 21:36 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 22:08 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 22:24 <tryingtryton> What's the next step in the workflow after processing a sale?
2016-12-07 22:29 <kstenger> tryingtryton: you continue with the shipments to send the associated goods
2016-12-07 22:34 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 22:35 <tryingtryton> I'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?
2016-12-07 22:53 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 23:17 -!- JanGB(~jan@dslb-088-073-246-007.088.073.pools.vodafone-ip.de) has joined #tryton
2016-12-07 23:19 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton
2016-12-07 23:40 -!- tbruyere(~smuxi@mail.saluc.com) has joined #tryton

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