Firefox 20 incorrectly caching data from MySQL database
I am developing an AJAX-enhanced website with data in a MySQL database displayed in HTML tables. After entering data using AJAX the new data displays without a page refresh. If, still with no page refresh, the newly entered data is then altered using a further AJAX call and jQuery update of the HTML, the updated data is immediately displayed as intended.
However, if F5 is then pressed, Firefox displays the value of the fields muddled across records, i.e. with the value of Record A, Field 1 appearing for instance as Record C, Field 1. If CTRL+F5 is pressed, the issue is resolved.
There is no issue in any other browsers I have tried so this seems to be due to FF caching.
Do you know of any solution to this?
All Replies (2)
This is really hard to debug, since you did not provide any sort of code or examples. For a better result, you should try and implement this as a JS Fiddle or similar.
What comes to mind from me is that you are running into form persistence. When you return to a page, Firefox tries to fill in the forms with previous values, and it must be getting confused about which element is which. Are you using ids to reference the elements? Is it possible you have duplicated the ids of some of them? In this case, I think Firefox will select the last element on the page.
Again, this is a pretty difficult to answer question, because it is a very complex subject, and you haven't provided a lot of concrete information.
Firefox can be pretty aggressive about caching. If you want to bar Firefox from caching that page, check out this article for suggestions: https://developer.mozilla.org/docs/Using_Firefox_1.5_caching