Web Hosting Talk







View Full Version : Moved site to new server and now my PHP/MySQL scripts are having a heart attack!


monkey junkie
11-10-2003, 04:51 PM
Hey all,

My website was working perfectly on my old server, and now that i've moved it to a new server I'm getting the following messages -

Warning: mysql_query(): Unable to save result set in /home/pronpost/public_html/index.php on line 88

Warning: mysql_query(): Unable to save result set in /home/pronpost/public_html/index.php on line 93

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pronpost/public_html/index.php on line 94

Warning: mysql_query(): Unable to save result set in /home/pronpost/public_html/index.php on line 96

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pronpost/public_html/index.php on line 97


Here is my website address -
Warning: this link contains one adult image and links to other adult sites (http://www.pronpost.com/)

Any insight greatly appreciated!

Thanks.
N

barrywien
11-10-2003, 07:10 PM
If you havnt touched the files then its probably a connection problem. Make sure all your SQL details are correct, and if using cpanel make sure your sql username is set to work with your sql database.

monkey junkie
11-11-2003, 10:39 AM
got it!

the database was corrupt (MySQL error 127 i think)

did a repair and now it's hunky dorey!

thanks for the help :D