Intermittent fetch_array() error with Photopost Integration

[kall]

Originally Posted by ForumHome

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

I am including the Photopost 'featured photos' mod on my Forum Home.

Most of the time it works fine, but occasionally (and without pattern), it throws up the above error.

This is the bit of index.php that relates to the calling:

PHP Code:

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_forumlist.php');
require_once('/home3/nzboards/public_html/gallery/photopostpal.php'); 


I have tried moving the require_once ... photopostpal.php around in the index.php, but that caused errors each and every time.

Can someone who knows what they are doing help me out?

[Brad]

Originally Posted by kall

I am including the Photopost 'featured photos' mod on my Forum Home.

Most of the time it works fine, but occasionally (and without pattern), it throws up the above error.

This is the bit of index.php that relates to the calling:

PHP Code:

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_forumlist.php');
require_once('/home3/nzboards/public_html/gallery/photopostpal.php'); 


I have tried moving the require_once ... photopostpal.php around in the index.php, but that caused errors each and every time.

Can someone who knows what they are doing help me out?

Can you post the code thats in the photopostpal.php file?

[Dean C]

You're best off asking for support either at the photopost support forums or in the modification thread here

[kall]

Originally Posted by Dean C

You're best off asking for support either at the photopost support forums or in the modification thread here

@Dean They don't love me as much over there...no response as yet to my queries.

@Brad: this is the bit that it is choking on:

PHP Code:

// which type of images do you want to show
$q_switch = "random";

switch ($q_switch) {
    case "most_view":
        $query = "SELECT id,user,userid,cat,title,bigimage,views FROM pp_photos ORDER BY views DESC";
        break;
    case "lastest":
        $query = "SELECT id,user,userid,cat,title,bigimage,views FROM pp_photos ORDER BY date DESC";
        break;
    case "random":
        $query = "SELECT id,user,userid,cat,title,bigimage,views FROM pp_photos WHERE storecat=0 ORDER BY RAND()";
        break;
}
$result = mysql_query($query);

$counted = 0; $featured = "";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $photo = $line["bigimage"];
    
    if ( pp_is_image($photo) ) {
        $photolen = strlen($photo);
        $theext = pp_get_ext($photo);
        $photo_name = str_replace( $theext, "", $photo );

        $temp_user = $line["userid"];

        $thumbtag = "{$line['user']} - {$line['title']}";
        $mthumb = "<img border=\"0\" src=\"{$data_dir}{$line['cat']}/{$line['userid']}{$photo_name}-thumb{$theext}\" alt=\"$thumbtag\" />"; 


Line 70 is

PHP Code:

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { 


(Hmm. Putting the include/ into my php_include_start seems to be doing the job nicely..but I don't know if that will break anything else, or even if it IS working nicely, as this doesn't occur all the time...)

*edit* And, it's sposed to be include( , not require_once on the index.php addition, I was trying require_once to see if it made a difference).