"Supplied argument is not a valid MySQL result resource"

[szybszy]

I can add messages but when I later click on them I get the followig message:

"2: Supplied argument is not a valid MySQL result resource
(/myserver/yabbse/Sources/Display.php ln 57)"

What should I do?

Thanks!!!

[Jeff Lewis]

Right before line 57, look for the line that has mysql_query and add this below it:

echo "Error: ".mysql_error();

What error does it spit to the screen?

[szybszy]

Jeff, how do I find line 57? The text "mysql_query" shows up every second line and I don't want to mess up the whole file. I use Dreamweaver 4 and it doesn't seem to have an easy way to find the exact line. Is it a 57th line out of all lines or only code lines or only code lines without empty lines?

Thanks!

[alexrolko]

to edit/look through PHP files i suggest you download editplus... http://www.editplus.com it shows you the line numbers. and is what the Dev's here use to code YaBB SE.

[szybszy]

Thanks Jeff and Alex,

I used whatever's left of my brain and found line 57 in Display.php and realized that it's related to "previous/next" module:

"$prevTopic = mysql_num_rows($result)-1;

so I simply turned it off in the Admin section and it works fine. I suppose it's the way to navigate to the nex message while reading one without going back to the board's main screen but I guess people can live without it....

[Joseph Fung]

honestly, we'd much rather you post the errors for us so we can fix the problem - saving other users from having the same error.

[[Cable]]

i've the same problem and get :
(after putting in the code from above)

Error: Can't create/write to file '\#sql124_5c_0.MYI' (Errcode: 13)

2: Supplied argument is not a valid MySQL result resource
(d:\http\forum\Sources\MessageIndex.php ln 221)

I have the same problem with Boardindex.php

Error: Can't create/write to file '\#sql124_62_0.MYI' (Errcode: 13)

2: Supplied argument is not a valid MySQL result resource
(d:\http\forum\Sources\BoardIndex.php ln 171)


it seems that yabb tries to write somewhere, it could not..

But where ?
if i knew i could change the rights

i use yabb 1.31 php mysql and apache
under NT4.0 sp6a

[Jeff Lewis]

That is a mySQL error, seems it's having trouble creating temp tables...  Make sure it's configured properly.

[[Cable]]

sorry, for the other thread, but this one is from somebody else who "has solved"
his problem.. i thought..

But what rights should mysql/apache have in the database other then everything ?

yabb/php logs in with account mysql in mysql
that account can do everything..
?

[[Cable]]

i solved,

thanks jeff !

mysql's temp map stood as '\'

i had to change it to d:\http\data\temp

now it works


thank you for the hint  

[Jeff Lewis]

Your welcome!  Now this thread has two solved problems

[Wistman]

just a slightly marginal off topic question that arises for me from this discussion When you talk line numbers, does it include the 26 lines of information on the top of each file.

I ask because whenever I check an error line, it's either a blank line or hav no revelence to the error it's suppose to be.


BTW being on a Mac I can't use editplus and so use BBEdit

[Hypocrite]

Yes, they count.

[Jeff Lewis]

Yes they count.  I'm not Mac fan/user but...I am pretty sure BBEdit is FOR the Mac

http://www.bbedit.com/products.html

[Stanley]

Hello All,

I'm a regular poster on several forums but this is my first attempt at running my own!  (I was so happy that the install seemed to work perfectly)

Now when I post I get the following error message:
2: Supplied argument is not a valid MySQL result resource
(/home/stanleyh/collectiblecrazy-www/yabbse/Sources/Post.php ln 744)

When I go back to the home page the posts are there but I receive this error every time I post and I recently visited another site with the same install of YaBBSE and it has the identical issue.  What am I doing wrong?

Stanley