Hi all,
Today I switched servers. I got a Hostgator Basic Dedicated server, and their migration team moved everything over for my website - including the MySQL database - from their congested shared servers to my new one.
I went to my registrar and changed the DNS entries to point to the new private nameservers. Accessed the CPanel, saw the files, was able to modify them and see the changes at the url level. All looked good.
Now, here's what's weird: SOME of the pages of my site run the MySQL queries just fine. Some do not. For example, I have a page called "kids rugs" that shows a few hundred rugs pulled straight from my database. Each shows the photo, the name, and the price. But when you click on an individual rug, and it takes you to the detail page? NO data of any kind is showed (no photo, no description, no price, etc...)
The second page is running the same type of query as the first. It's a SELECT * FROM tbl_name WHERE category = 'rugs'. The table is the same, the database is the same, and the connection script is the same. But one page shows results from the inquiry where the other does not.
There are lots of other pages on my site that refuse to run MySQL inquires as well. These were all inquiries that worked flawlessly on the old shared server, but don't work on the new dedicated one (both servers are Linux).
My question is this: Do you think this has anything to do with DNS, non-propagation, etc? I'm tempted to say "oh, this will resolve itself in 24-48 hours", but then again, it doesn't make much sense that a MySQL query would connect and work correctly on one page, and not show any results on others.
Any ideas? Thanks in advance for the help!