Welcome, Guest. Please Login or Register.
August 29, 2025, 03:35:36 PM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  English User Help  |  English Help  |  Supplied argument is not a valid MySQL result resource « previous next »
Pages: [1] Reply Ignore Print
Author Topic: Supplied argument is not a valid MySQL result resource  (Read 382 times)
D8TA
Jr. Member
**
Posts: 55


I'm a Christian

WWW
Supplied argument is not a valid MySQL result resource
« on: April 21, 2002, 08:00:13 PM »
Reply with quote

Help, I try to post a message and get this error, yet I click on the home button and my message is there?? What is causing this error.
2: Supplied argument is not a valid MySQL result resource (/home/jason/highlandchristianchurch-www/yabbse/Sources/Post.php ln 744) ???

Thanks and God Bless
Logged

Jack of all trades.....Master of none.
D8TA
Jr. Member
**
Posts: 55


I'm a Christian

WWW
Re:Supplied argument is not a valid MySQL result resource
« Reply #1 on: April 21, 2002, 09:05:52 PM »
Reply with quote

Quote from: D8TA on April 21, 2002, 08:00:13 PMHelp, I try to post a message and get this error, yet I click on the home button and my message is there?? What is causing this error.
2: Supplied argument is not a valid MySQL result resource (/home/jason/highlandchristianchurch-www/yabbse/Sources/Post.php ln 744) ???

Thanks and God Bless

www.highlandchristianchurch.com/yabbse/index.php
Logged

Jack of all trades.....Master of none.
D8TA
Jr. Member
**
Posts: 55


I'm a Christian

WWW
Re:Supplied argument is not a valid MySQL result resource
« Reply #2 on: April 22, 2002, 02:03:22 PM »
Reply with quote

OK I completely started from scratch and even overwrote my old files with the bug fix ones. I still get the same error in my post.php in 744, exact error. Will someone please help me. I have been through this help board, spent close to two hours looking at all the post that had error messages or something in them. I tried to do a search and no results showed up. Please someone tell me how to fix this and what caused it to happen. Thanks and God Bless.  ???  ???
Logged

Jack of all trades.....Master of none.
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Supplied argument is not a valid MySQL result resource
« Reply #3 on: April 22, 2002, 02:56:41 PM »
Reply with quote

From post.php, post the few lines before 744.
Logged

D8TA
Jr. Member
**
Posts: 55


I'm a Christian

WWW
Re:Supplied argument is not a valid MySQL result resource
« Reply #4 on: April 22, 2002, 03:09:42 PM »
Reply with quote

Quote from: Jeff Lewis on April 22, 2002, 02:56:41 PMFrom post.php, post the few lines before 744.
$subject,$threadid,$txt,$cgi,$db_prefix,$realemail,$doLimitOne,$username;
   $request = mysql_query("SELECT notifies FROM {$db_prefix}topics WHERE (ID_TOPIC=$threadid && notifies!='') LIMIT 1");
   if (mysql_num_rows($request) != 0)
   {
      $row = mysql_fetch_row($request);

      $members = mysql_query("SELECT emailAddress, notifyOnce, memberName FROM {$db_prefix}members WHERE ID_MEMBER IN ($row[0]) && emailAddress!='' && memberName!='$username'");
      while ($rowmember = mysql_fetch_array($members)) {
         $send_subject=$txt[127].": ".$subject;

         if ($rowmember['notifyOnce'] == 1) {
            $request = mysql_query("SELECT notificationSent FROM {$db_prefix}log_topics WHERE memberName='$rowmember[memberName]' && ID_TOPIC=$threadid $doLimitOne");
            if (mysql_num_rows($request) == 0)
               $notificationSent = 0;
            else
               list($notificationSent) =
« Last Edit: April 22, 2002, 03:31:51 PM by D8TA » Logged

Jack of all trades.....Master of none.
D8TA
Jr. Member
**
Posts: 55


I'm a Christian

WWW
Re:Supplied argument is not a valid MySQL result resource
« Reply #5 on: April 22, 2002, 03:28:14 PM »
Reply with quote

Thanks I got it to work. For reference for anyone else this is what I did:
change this on Post.php line 744:

Code:
$members = mysql_query("SELECT emailAddress, notifyOnce, memberName FROM {$db_prefix}members WHERE ID_MEMBER IN ($row[0]) && emailAddress!='' && memberName!='$username'");

to

Code:
$members = mysql_query("SELECT emailAddress, notifyOnce, memberName FROM {$db_prefix}members WHERE ID_MEMBER IN ('$row[0]') && emailAddress!='' && memberName!='$username'");
 

 
Logged

Jack of all trades.....Master of none.
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  Supplied argument is not a valid MySQL result resource « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.012 seconds with 18 queries.