Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2005, 11:11 PM
DiscussAnything DiscussAnything is offline
 
Join Date: Jan 2002
Posts: 131
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default supplied argument is not a valid MySQL result

I am using the karma hack and just moved to a different server, and am now getting these errors. They're caused by the fact that for guests it can't return a result, so it spits out the error:

PHP Code:
Warningmysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/site/httpdocs/forum/admin/functions.php on line 114 
The code is

PHP Code:
if ($numrows_gettotal '0' || $numrows_gettotal != '0' || $numrows_gettotal != '')
{
list (
$newthread$reply$view$admin_mod$morereply$totalpenalty$date$redeem_points) = mysql_fetch_row($gettotalpoint);

I've tried different things to have this not be executed for guests (userid = 0, usergroupid = 1) but so far no luck.

Could anyone let me know how to avoid having that piece of code run for guests? On all the other instances I've used this construction, which seems to work

PHP Code:
    if ($bbuserinfo[usergroupid] = '1')
    {
      
$numrows_gettotal '1';
    }
    else
    {
      
$numrows_gettotal mysql_num_rows($gettotalpoint);
    } 
TIA!
Reply With Quote
  #2  
Old 01-08-2005, 11:23 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

1. You should absolutely always use the wrapper methods in $DB_site in case vB ever supports a new database type and to ensure consistency.
2. Don't use quotes for numeric types in both queries and PHP.

Neither of those is causing the problem, but make sure $gettotalpoint is the return value of calling either mysql_query() or the more proper $DB_site->query(). It should not be $DB_site->query_first(), which returns an array.

If you don't know what it is, use:
PHP Code:
echo "<pre>";
var_dump($gettotalpoint);
echo 
"</pre>"
Reply With Quote
  #3  
Old 01-09-2005, 08:22 AM
rake's Avatar
rake rake is offline
 
Join Date: Nov 2002
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You should give us the part where $gettotalpoint is given a value.

Also, to have that code not run for guests use:
PHP Code:
if ($numrows_gettotal '0' || $numrows_gettotal != '0' || $numrows_gettotal != ''

  if(
$bbuserinfo['userid'] > 0)
  {
     list (
$newthread$reply$view$admin_mod$morereply$totalpenalty,$date$redeem_points) = mysql_fetch_row($gettotalpoint); 
  }

also, if this is within a function, you will need to add:
PHP Code:
global $bbuserinfo
just under the starting { of the function.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:13 PM.


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.03282 seconds
  • Memory Usage 2,193KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (6)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete