Welcome, Guest. Please Login or Register.
November 26, 2024, 09:25:54 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  English Help  |  mysql_fetch_assoc(): error « previous next »
Pages: [1] Reply Ignore Print
Author Topic: mysql_fetch_assoc(): error  (Read 377 times)
Termite
Jr. Member
**
Posts: 54
mysql_fetch_assoc(): error
« on: May 26, 2003, 08:33:05 PM »		 Reply with quote
What does it mean when I get the following error:

2: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
(htdocs/web/yabbse/Sources/ModifyMessage.php ln 242)

The block of code around line 242 in ModifyMessage.php is (with line 242 in bold)

$yySetLocation = "$cgi&action=display&threadid=$threadid&start=$start";

$request = mysql_query("SELECT m.*,t.locked,t.ID_FIRST_MSG,t.ID_LAST_MSG,t.ID_TOPIC,t.ID_BOARD,t.ID_POLL,t.numReplies FROM {$db_prefix}messages as m, {$db_prefix}topics as t WHERE (m.ID_MSG=$postid AND m.ID_TOPIC=t.ID_TOPIC) LIMIT 1");

$row = mysql_fetch_assoc($request);

if(($settings[7] != 'Administrator') && ($settings[7] != 'Global Moderator') && !in_array($username,$moderators) && $row['ID_MEMBER'] != $ID_MEMBER) {
fatal_error($txt[67]);
}


Could anyone help me on that; Give me an idea what to fix?
« Last Edit: May 26, 2003, 08:40:54 PM by Termite » Logged
Specs: FreeBSD 5.0-RELEASE #3, PHP Version 4.2.3, Apache/1.3.27, Mysql 3.23.54, YaBBSE 1.5.4
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:mysql_fetch_assoc(): error
« Reply #1 on: May 26, 2003, 08:37:35 PM »		 Reply with quote
Please try upgrading to 1.5.x.

-[Unknown]
Logged
Termite
Jr. Member
**
Posts: 54
Re:mysql_fetch_assoc(): error
« Reply #2 on: May 26, 2003, 08:41:53 PM »		 Reply with quote
I would upgrade, definitely, but it's not an option for me. I've made so many aesthetic modifications to the board, I don't have time to redo all that.
Logged
Specs: FreeBSD 5.0-RELEASE #3, PHP Version 4.2.3, Apache/1.3.27, Mysql 3.23.54, YaBBSE 1.5.4
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:mysql_fetch_assoc(): error
« Reply #3 on: May 26, 2003, 08:58:22 PM »		 Reply with quote
Check in phpMyAdmin and try repairing your tables.

-[Unknown]
Logged
Termite
Jr. Member
**
Posts: 54
Re:mysql_fetch_assoc(): error
« Reply #4 on: May 26, 2003, 09:46:45 PM »		 Reply with quote
ok. i have the lastest version of phpMyAdmin. how would i go about repairing my tables?

sorry about being clueless. i'm sure its annoying :-\
Logged
Specs: FreeBSD 5.0-RELEASE #3, PHP Version 4.2.3, Apache/1.3.27, Mysql 3.23.54, YaBBSE 1.5.4
Douglas
aka The Bear
Support Team
YaBB God
*****
Posts: 1050


Bears rule! Llamas rule too!

WWW
Re:mysql_fetch_assoc(): error
« Reply #5 on: May 26, 2003, 09:50:59 PM »		 Reply with quote
Select your table from the left side.

On the right side, it'll give you the option to "Check All".  Click on it.  In the drop down box next to Check All, should be an option called "Repair Tables".  Do that.  Close that window and then check your boards again.
Logged
Need help? Please SEARCH first.  No need for a bad attitude, we like helping positive minded people.
ComeHit.us Short URL  redirection svcs with YSE powered forums, COMING SOON!
Want to say thanks?  Check out http://comehit.us/?u=3
Termite
Jr. Member
**
Posts: 54
Re:mysql_fetch_assoc(): error
« Reply #6 on: May 26, 2003, 10:17:47 PM »		 Reply with quote
Thanks.

I used the repair option in phpmyadmin but it didnt solve the problem. hmm.

i guess i'll just upgrade to 1.5.3
Logged
Specs: FreeBSD 5.0-RELEASE #3, PHP Version 4.2.3, Apache/1.3.27, Mysql 3.23.54, YaBBSE 1.5.4
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  mysql_fetch_assoc(): error « 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.061 seconds with 21 queries.