On Thursday, 1 June 2017 03:38:55 UTC-6, Sergi Almacellas Abellana wrote: > > El 01/06/17 a les 11:35, Mark Shane Hayden ha escrit: > > Here is the scenario: > > > > 1. We made some changes in a development environment and things tested > > OK. The changes involved installing product_attributes module, then > > adding attributes and removing the redundant information from the > > description in all the variant (product_product) records. > > 2. Once everything was confirmed in dev the production trytond was shut > > down, and we used SQL updates to updated the information from dev to > > production. > > 3. Upon connecting when we open up the product variants in the tryton > > client, or on the web shop front end the OLD descriptions show up, > > even though the database clearly has the new ones in place > > 4. I can update records manually in the Tryton client but all changes > > that were done by database queries on the product description have > > no effect outside the database! > > > > Clearly there is a cache issue of some kind, though the documentation > > suggests the default is memory cache (we have not specified anything > > different in the configs) and I have even completely rebooted the server > > to no effect. > > > > How do I ensure that Tryton reads the proper data from the database? > It does, just check you are using the proper database when connecting > throw the client and the trytond.conf file contains the expected URL. > > Thanks for the prompt reply. >
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... -- > 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/38c5c6bf-0bfc-4c55-9afa-2891b6742be7%40googlegroups.com.
