Big problem! Moved site to new server and now it's no longer working...

[steveryan]

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/ste/public_html/index.php on line 88

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

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

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

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

Here is my website address -


Any insight greatly appreciated!

Thanks.
Steve

[Tracer]

Looks like you have more errors than that...

Warning: main(page.php): failed to open stream: No such file or directory in /home/pronpost/public_html/inwork/index.php on line 3

Just what it says...Update your link to this file...make sure that the server has privs to open it....

Warning: main(): Failed opening 'page.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/pronpost/public_html/inwork/index.php on line 3
Same as above

Warning: mysql_query(): Unable to save result set in /home/pronpost/public_html/inwork/index.php on line 88
Looks like it could be privs....

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

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

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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pronpost/public_html/inwork/index.php on line 97
means that the SQL query was unsucessfull (probably because of the previous errors)

[steveryan]

thank you.

i am only getting these errors now:

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

when you say "check my privs" do you mean chmod certain files to something? Thanks

[tekky]

that is exactly what check your privs mean 😉

make sure the file permissions are set in such a fashion that the web server/php parser can modify them

[steveryan]

the database was corrupt (error 127 i think)

did a repair and now it's hunky dorey!

thanks for the help 😉