vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   supplied argument is not a valid MySQL result (https://vborg.vbsupport.ru/showthread.php?t=74029)

DiscussAnything 01-08-2005 11:11 PM
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:
Warning: mysql_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!

filburt1 01-08-2005 11:23 PM
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>"; 

rake 01-09-2005 08:22 AM
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.


All times are GMT. The time now is 01:44 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.00939 seconds
  • Memory Usage 1,727KB
  • 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
  • (6)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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