I backed up one of my sites that is working perfectly and added it to a friends site, there I am getting an error... http://soloopscom.powweb.com/index.php

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soloops/htdocs/includes/sql_layer.php on line 357

Any solutions???

I suggest you run the site in the debug mode (html/includes/sql_layer.php and search for

Code:

$sql_debug = 0;

and change 0 to 1 and reupload it to the site),this mode will show you which sql entries are made and where the errors are.

Hopes this helps you out.

Make sure you check all the path settings in any pertinent files, Admin preferences etc.

To set Debug mode to get an even better Idea of what is going on, do this:

sql_layer.php Debug

Open sql_layer.php go to line 300 and change:

Code:

case "MySQL": $row = mysql_fetch_row($res); return $row; break;;

To the following:

Code:

case "MySQL": if ($row = mysql_fetch_row($res)) { return $row; } else { print (mysql_error()); } break;;

This will just give a description of the error instead of showing ALL the sql queries and error.

mikem

I fixed it, Duh, I still had the Who is Where from my site in the myheader.php and had not loaded the sql for that on this site. Thanks for your help!

That's what I meant when I said (in yesterdays PM) I suspected something was missing from the DB, it's what that error usually means (in my experiences). But there was no way for me to know exactly what was missing.

Originally Posted by Martin

That's what I meant when I said (in yesterdays PM) I suspected something was missing from the DB, it's what that error usually means (in my experiences). But there was no way for me to know exactly what was missing.

Agreed, the very first thing to actually check when moving a site is did I have any MODS installed that may not work after the move or whatever...glad you got it fixed...

mikem

Originally Posted by Martin

That's what I meant when I said (in yesterdays PM) I suspected something was missing from the DB, it's what that error usually means (in my experiences). But there was no way for me to know exactly what was missing.

Yes I started thinking after you said that what it could be. I was guessing since it's at the top of the page that it must have something to do with the header. Then it hit me, But I have learned a lot from all of you with this LOL so something good has came of it! Thanks for all the tips. 8)