Query() reads old data from already updated CMS

Ask the community
, ,
1

Dear Wix Community,

I’ve built a small tool for private purposes consisting of two separate sub-domains on my website.
The “User Page” is for displaying information from a CMS table, so this page is only reading from the CMS table.
The “Admin Page” is for editing the information in the same CMS table, so this page is both reading and writing information in the CMS table.

This worked perfectly for many months. But now the query() function on both pages gets old information from the CMS table after I changed the information on the “Admin Page”.

For example:
I change some information on the “Admin Page”. This is triggering an update() function which updates the information in the CMS table - which works perfectly. The new information is visible in the CMS table in the WIX Website Editor just a few milliseconds later.
Now I’m refreshing either the “Admin Page” or the “User Page”, which triggers a query() function to get the current information from the CMS table. But instead of getting the new information which I changed just a few seconds ago and which is visible in the CMS table in the WIX website overview, I receive the old information which is already overwritten in the CMS table.

But as soon as I publish my website again - even if I made no changes to the code or website - the query() function will finally get the new information.

More interesting: This problem does not exist in Preview Mode. New information will be displayed with no problem after restarting preview mode without re-publishing the entire website.

Does anyone have a clue how it’s possible to get information from a CMS table which are not even existing anymore and already overwritten?

Furthermore, maybe you have a clue why this is happening for the first time after months of zero problems and zero changes?

Some more information which might be interesting:
I’m using the WIX website editor, not WIX Studio.

Thank you!

2

Hi @Falko_Partzsch possibly there has been some changes to API’s. Hard to tell what the issue may be without seeing the codes you are using.

also note from this document - Query | Velo

  • When using the query() or get() functions or another data retrieval method following a change to your database collection, the data retrieved may not contain your most recent changes. See [Wix Data and Eventual Consistency]Velo Wix Data Introduction | Velo) for more information. To solve this problem, you can use the setTimeout() function to delay retrieving data following any changes to your database collection.
  • To speed up data retrieval, the results of certain data queries are cached. Learn more about caching data query results.