vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Intermittent fetch_array() error with Photopost Integration (https://vborg.vbsupport.ru/showthread.php?t=72253)

kall 11-27-2004 08:40 PM
Intermittent fetch_array() error with Photopost Integration
 
Quote:
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 11-28-2004 04:17 PM
Quote:
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 11-28-2004 05:42 PM
You're best off asking for support either at the photopost support forums or in the modification thread here :)

kall 11-28-2004 08:32 PM
Quote:
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).


All times are GMT. The time now is 01:12 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01025 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete