On Thursday, 1 June 2017 05:10:47 UTC-6, Sergi Almacellas Abellana wrote: > > El 01/06/17 a les 13:06, Mark Shane Hayden ha escrit: > > I have already confirmed I am connecting to the right database. When I > > go to the production database in PSQL it shows the NEW descriptions when > > I query. In the Tryton client it shows all the OLD descriptions. When > > I change the description of one of the products to something totally > > different using the Tryton client and click save, then re-run the exact > > same query in PSQL in the exact same connection it still shows all the > > old descriptions, EXCEPT FOR THE ONE I CHANGED, which matches what I > > entered in Tryton client. > > > > It really does seem to be running into some cache issue due to directly > > altering the database or something like that... > > As you talk about the descritpion field maybe it's something related to > languages. Which languages do you have activated on the database? Which > language has your user set on preferences? The tryton client always > reads/writes using the tryton language. You can use the flag button on > the description field to see it's translations. > > Thanks this helps a lot! I have English and French activated on this setup, though at the moment I am only using English (we want to be able to accommodate business in Quebec in the future but we haven't translated anything yet).
Despite the fact I have only been using English the site appears to have the descriptions in both the product table AND the translation table. When I edit the values in Tryton client they BOTH change, but my updates only changed the main table and it seems the Tryton client and my flask web shop pull the value out of the translation. I will have a look at my setup to see if there is anythong weird, however I have not specified a main language in the config file, and all the translations have a language "en". Would there be any damage in removing those offending translation records? I really only need them for French in the future. Tryton by default only stores the main language on the database table, > but stores the translations on the ir.translation table. By default the > main language is 'en' (but you can customize on the tryton.cfg file). > > Hope it helps. > > -- > Sergi Almacellas Abellana > www.koolpi.com > Twitter: @pokoli_srk > -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/b7f48cb0-d4a8-4deb-98df-3b2295aa3dcc%40googlegroups.com.
