Forum Moderators: phranque
first of all let me thank you for your atention, I'm going post about an issue,
that is not usual, actually never happened to me before, and its really hard
to someone understand it. Even tought this is not my native language, I'll
put all the necessary details. This issue was forwarded to ticket line support
system, and also live chat: Wish I thank both for the time taken to review it.
1. I've moved a website from a diferent shared host (http://69.16.239.71/~radiofaz/) to hostgator, lets call it HG, (http://174.132.157.5/~fazuma/).
2. After finishing moving to this new server (HG), there's some issues going on, explained:
a) When there's a new post entry to the blog (wish is the section called "Blogui" in the navigation bar), its imediattely acessible on the frontend, by navigating to "Blogui". Any one, who access (http://174.132.157.5/~fazuma/) see's the last post!
b) This website, has a "Latest news module" in the frontpage, that lists the last 4 entrys on that "Blogui" section of the page. In the old server, and LAN, it wost to show it immediately, but not right now! It takes 6 hours, untill it is displayed on the frontpage!
c) I tought this could be the CMS Cache, Browser Cachet, and similars. All where cleaned, and, if possible, disabled (specially the CMS cache system). Also, tested in diferent locations, diferent browsers. Unfortunately this didnt solved the situation.
d) I've contacted live support about this issue, after getting feedback, just to make sure, I tryed downloading this page from HG server, set it up on my LAN server and also, to my old server (http://69.16.239.71/~radiofaz/); I've permitted both IP addresses, to have privileges to my remote database, on HG; In both, the "Latest news module" fetches all 4 entrys, posted on "Blogui" Section (in the menu navigation bar) imediately; So, its working great! That means, there's no problem with scripts etc
e) I've forwarded all this information and also, the tests that were done to ticket system support. I've asked if there was a setting or other, in the "http.conf" or even in my own .htacess, wish, for double checking I added:
# Force no caching for dynamic files
<FilesMatch "\.(php¦cgi¦pl¦htm¦html)$">
ExpiresDefault A0
Header set Cache-Control "no-store, no-cache, must-revalidate, max-age=0"
Header set Pragma "no-cache"
</FilesMatch>
Ticket system reported back to me, saying that there was no HTTP cache settings on the server. I really tought there was something on apache going on! But, well, it seems not. I respect other people opinion and experience a lot!
f) Now, after confirming this, I've downloaded the files again from HG to my LAN and, once again, connected the website on LAN to my remote mySQL database on HG! The same was done, on the old server, with this same files, and guess what. Worked great again!
g) The fact is, this is only happening in the frontpage, where the "Latest news module" is located. It only fetche new information to the module, after 6 hours! That's 21600 seconds. Happened twice!
h) Well, since I couldnt get anyone to fix this for me, I tryed one thing else, I changed the query settings in the "Latest news module" to:
«...$query = 'SELECT SQL_NO_CACHE a.*, ' ...»
This didnt fixed nothing at all!
Thats it, I'm trying to find help from anyone experienced,
I really thank you for your time and effort,
Any sugestion is appreciated!
