mysql fetch errors...

[South Fork]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wff/public_html/gallery/pp-inc.php on line 192

Warning: Invalid argument supplied for foreach() in /home/wff/public_html/gallery/pp-inc.php on line 2861

it started before a server transition, but not far enough to think it wasn't related. all pages returning the above, including admin. ideas?

http://www.washingtonflyfishing.com/gallery/

Thanks,

South Fork

[Chuck S]

well your not using the latest files it would appear cause line 192 is a closing bracket and nowhere near a query so I can't say the exact cause here cause I do not know what query there is thats failing.

I would suggest if this was an upgrade you run all applicable upgrades from 5.0-5.3 and do a repair on your database tables for photopost.

[South Fork]

server upgrade, not pp. Running 5.2. Will upgrade to 5.3 and see if that cures anything. already ran a db repair, to no avail.

thanks Chuck.

[Chuck S]

You want to tell me what line 192 is in your pp-inc.php so we know what query is failing?

[South Fork]

// Depending on the page, we don't need all the cached data (just saves space this way)
if ( THIS_SCRIPT != "upgrade" ) {
if ( THIS_SCRIPT == "ppindex" && $Globals['cachetimeout'] > 0 ) {
$totalv = ppmysql_query("SELECT * FROM {$Globals['pp_db_prefix']}cache WHERE id=1", $link);
}
elseif ( (THIS_SCRIPT == "showgallery" || THIS_SCRIPT == "showmembers" || THIS_SCRIPT == "showphoto") && $Globals['sidebar_global'] == "yes" ) {
$totalv = ppmysql_query("SELECT timestamp,statscache,calcache,catcache,catprops FROM {$Globals['pp_db_prefix']}cache WHERE id=1", $link);
}
else {
$totalv = ppmysql_query("SELECT timestamp,statscache,catcache,catprops FROM {$Globals['pp_db_prefix']}cache WHERE id=1", $link);
}
$cacheq = mysql_fetch_array($totalv);

// timestamp is the time of the next scheduled update; do we need to update cache?
$updatecache = false;

if ( $cacheq['timestamp'] < $lasttimeon || $Globals['cachetimeout'] == 0 ) {
$updatecache = true;
}
}

[Chuck S]

Okay so its the cache query and you did not run the upgrade script. The cache was added in 5.2 and it looks to me like your cache table does not exist. Try running the upgrade script.

[South Fork]

The error with the cache table is resolved. Ran the repair again on it before upgrading the script and it fixed the table. Cool. The second issue remains.

Warning: Invalid argument supplied for foreach() in /home/wff/public_html/gallery/pp-inc.php on line 2861

===================================

function set_group_perms( $usergroup, $xloop = 0 ) {
global $Globals, $link, $CatPerms, $User, $cacheq;

$listofcats = null;

foreach( $Globals['cats'] as $key => $value ) {
list( $catugid, $ugnoup, $ugnoanno, $ugnoview, $ugnopost, $ugnovote, $cpass, $cwatermark, $cattype, $ismember, $catname, $catparent, $children, $catthumb, $canzip, $mods, $header, $footer, $headtags ) = $value;
$noupload=0; $noann=0; $noview=0; $nopost=0; $novote=0;

if ( $xloop == 0 ) {
$CatPerms['ugcat'][$catugid] = 1;
$CatPerms['uganno'][$catugid] = 1;
$CatPerms['ugview'][$catugid] = 1;
$CatPerms['ugpost'][$catugid] = 1;
$CatPerms['ugvote'][$catugid] = 1;
$CatPerms['parent'][$catugid] = $catparent;
$CatPerms['children'][$catugid] = $children;
$CatPerms['thumbs'][$catugid] = $catthumb;
$CatPerms['mods'][$catugid] = $mods;
$CatPerms['catpass'][$catugid] = $cpass;
$CatPerms['cattype'][$catugid] = $cattype;
$CatPerms['ismember'][$catugid] = $ismember;
$CatPerms['catwater'][$catugid] = $cwatermark;
$CatPerms['canzip'][$catugid] = $canzip;
$CatPerms['catname'][$catugid] = $catname;
$CatPerms['header'][$catugid] = $header;
$CatPerms['footer'][$catugid] = $footer;
$CatPerms['headtags'][$catugid] = $headtags;

if ( $listofcats == "" ) $listofcats = "$catugid";
else $listofcats .= ",$catugid";
}

$allnoup = explode( ",", $ugnoup );
foreach ($allnoup as $key) {
if ($usergroup == $key) {
$noupload=1;
}
}

$allnoanno = explode( ",", $ugnoanno );
foreach ($allnoanno as $key) {
if ($usergroup == $key) {
$noann=1;
}
}

$allnoview = explode( ",", $ugnoview );
foreach ($allnoview as $key) {
if ($usergroup == $key) {
$noview=1;
}
}

$allnopost = explode( ",", $ugnopost );
foreach ($allnopost as $key) {
if ($usergroup == $key) {
$nopost=1;
}
}

$allnovote = explode( ",", $ugnovote );
foreach ($allnovote as $key) {
if ($usergroup == $key) {
$novote=1;
}
}

if ( $noupload == 0 ) $CatPerms['ugcat'][$catugid]=0;
if ( $noann == 0 ) $CatPerms['uganno'][$catugid]=0;
if ( $noview == 0 ) $CatPerms['ugview'][$catugid]=0;
if ( $nopost == 0 ) $CatPerms['ugpost'][$catugid]=0;
if ( $novote == 0 ) $CatPerms['ugvote'][$catugid]=0;
}
ppmysql_free_result( $resultb );

$User['catlist'] = $listofcats;

return( $listofcats );
}

[Chuck S]

Refresh your cache and you will be fine

Turn it off in admin and view the index then turn it back on

[South Fork]

In a round-about way that did it Chuck. Found that after repairing the cache table it was empty. Tried turning off the cache but at first it didn't seam to work. Imported data into cache from a backup, tweaked a category setting and then the cache updated. Working again in all respects.

Thanks for the help Chuck.