Forum Moderators: open
The only thing that was displaying on the page is an included header that is on each page. The main body of the page which is pulled from the mySQL database is missing. There were no error messages at all in our server log. After attempting to troubleshoot the problem, I decided to do a reinstall of the script. While running the installation program, it told me that the user and password it was using was not connecting to the database. It was the same user name and password that's been working since the program went up about three months ago.
I went into phpMyAdmin and checked it out. The user name had global rights and the password was correct but still it wouldn't connect. I went to phpMyAdmin, clicked on Databases.../Privileges and clicked on the edit option for the username. There I added the database-specific privilege of using the `RP` database. When I did that, it worked. The program displayed properly when I shut my computer off that night. When I got up at 8:00 am the next morning, it was back doing what it was before.
And now for the really weird part. If I put my master login to the phpMyAdmin program as the user name and password on the script, it displays everything perfectly fine. The really weird part to me is that the master log in for phpMyAdmin is not one of the global users listed in the mysql/user tables.
I tried flushing privileges after each change. I tried creating a brand new user name and password and that didn't work. I have a database with a single table that still works using the same log in that won't work on this script.
I can't understand how a user name and password that worked fine suddenly stopped working and now that one or a new one can't be made to connect with mySQL.
Anyone got any ideas? There were no server upgrades at the time. I've got a Help Ticket in with my ISP but it's been almost 2 days and I haven't heard more than a "we'll look into it" response.
I've seen that one happen a lot.
But definitely call them.
JK
