IRC logs of #tryton for Wednesday, 2016-12-07 #tryton log beginning Wed Dec 7 00:00:01 CET 2016
-!- kstenger1( has joined #tryton00:48
-!- morfeokmg(~smuxi@ has joined #tryton01:10
-!- morfeokmg_(~Mutter@ has joined #tryton01:13
-!- nicoe(~nicoe@ has joined #tryton03:29
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton03:33
-!- morfeokmg(~smuxi@ has joined #tryton04:06
-!- thaneor1(~ldlc6@ has joined #tryton04:38
-!- JosDzGx( has joined #tryton07:13
-!- estan_( has joined #tryton07:14
-!- dj_xatra(~dj_xatra@ has joined #tryton07:50
-!- apostatize(~visavis@unaffiliated/apostatize) has joined #tryton08:11
-!- rpit( has joined #tryton08:25
-!- morfeokmg(~smuxi@ has joined #tryton08:44
-!- JanGB( has joined #tryton08:50
-!- pokoli2(5b7e4c02@gateway/web/freenode/ip. has joined #tryton08:59
-!- pokoli2(5b7e4c02@gateway/web/freenode/ip. has left #tryton09:00
-!- mrichez( has joined #tryton09:01
-!- flachtassekasse( has joined #tryton09:21
-!- udono( has joined #tryton09:51
-!- elbenfreund(~elbenfreu@ has joined #tryton10:16
-!- pokoli( has joined #tryton11:19
-!- pokoli( has joined #tryton11:20
-!- pokoli( has joined #tryton11:22
-!- flachtassekasse( has joined #tryton11:47
-!- elbenfreund( has joined #tryton11:55
-!- mariomop( has joined #tryton12:06
-!- smarro(~sebastian@ has joined #tryton13:22
-!- tryingtryton(94002863@gateway/web/freenode/ip. has joined #tryton13:37
-!- flachtassekasse( has joined #tryton14:00
-!- kstenger( 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:
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_( 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( has joined #tryton15:28
pokolitryingtryton: for example: the product.tempalte name, the product.product description the payment_term name and description15:32
-!- morfeokmg(~smuxi@ 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( has joined #tryton16:40
-!- thaneor(~ldlc6@ has joined #tryton16:41
-!- JanGB( has joined #tryton17:15
-!- rpit( has joined #tryton17:29
-!- Telesight( has joined #tryton18:14
-!- JanGB( has joined #tryton18:22
tryingtrytonpokoli:  It's a two-part query:18:44
tryingtrytonDELETE FROM ir_translation where id in (SELECT from ir_translation as x, ir_translation as y where = 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( has joined #tryton19:34
-!- tbruyere( has joined #tryton19:48
-!- tbruyere( has joined #tryton20:05
-!- udono( has joined #tryton20:09
-!- Timitos( has joined #tryton20:36
-!- udono( has joined #tryton20:41
-!- tbruyere( has joined #tryton20:53
-!- tbruyere( has joined #tryton21:03
-!- JanGB( has joined #tryton21:34
-!- tbruyere( has joined #tryton21:36
-!- tbruyere( 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( 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( has joined #tryton22:53
-!- JanGB( has joined #tryton23:17
-!- tbruyere( has joined #tryton23:19
-!- tbruyere( has joined #tryton23:40

Generated by 2.11.0 by Marius Gedminas - find it at!