I am new to PHP/MySQL/Apache so please pardon me if I sound like I am lost, because I am.
I took over a job and there are a number of home grown PHP/MySQL aplications. The apps are with PHP5, MySQL 5.0.51a, they are run on Apache 2.2 that sits on a windows SBS2003 box.
A couple of the apps intermittently will not display data or will display the data improperly, from the databases, even though that the data is in the tables as they should be. After a refresh or a clearing of the cache, the data displays. That is easy enough to do, but although inconsistent, this issue is happening regularly enough so it is a pain for the end user.
I have not changed the apps in any ways. I have done analyze, repair, and optimize on the databases used, but still the issues persist.
Any thoughts on what to check?
Thanks,
Rich
