I have an existing php/mysql installation that has been working fine, but recently has gone awry. I keep getting php error messages saying that so and so is not a valid mysql link. The mysql_connect() function works fine, i can log on to mysql from the command line, and connect sometimes works for other scripts when i try to connect.
I'm not sure what version of mysql i'm running is, but it is 3.22.xx i believe, and i recently upgraded from 4.0.0 to 4.0.4pl1. I'm not sure if the new mysql libraries have introduced any compatability issues, but we have the same setup here at work and it seems to function ok.
My thought was that maybe some of the tables need to be repaired. I've been running this database for over 1 year, and never run isamchk on it. Could this be the problem?
Anyway, I'm just out to solicit ideas. I'm planning on double-checking the permssions (did it 2x already), creating test scripts to test the connection, and possibly running isamchk to verify the integrity of the tables.
If there is anything else I may have forgot, please let me know.
p.
I'm not sure what version of mysql i'm running is, but it is 3.22.xx i believe, and i recently upgraded from 4.0.0 to 4.0.4pl1. I'm not sure if the new mysql libraries have introduced any compatability issues, but we have the same setup here at work and it seems to function ok.
My thought was that maybe some of the tables need to be repaired. I've been running this database for over 1 year, and never run isamchk on it. Could this be the problem?
Anyway, I'm just out to solicit ideas. I'm planning on double-checking the permssions (did it 2x already), creating test scripts to test the connection, and possibly running isamchk to verify the integrity of the tables.
If there is anything else I may have forgot, please let me know.
p.