Does Anyone know what this means?

[Boom]

2: Supplied argument is not a valid MySQL result resource
(/home/boom/nonameclan-www/yabbse/Sources/Post.php ln 744)

Does anyone have an answer for this? None of the solutions in this forum work. I could really use some help with this, please please please!

[andrea]

Did you not post the same problem in another board?

You should provide more informations:
- link to your board
- phpinfo

[Boom]

Andrea, my previous post on another board was related to the conversion process. I was able to accomplish that successfully.

My current problem is related to any new posts. I am running PHP 4.01 and MySql ver 10.8 Dist 3.23.21-beta

My url is www.nonameclan.com/yabbse/index.php

any information you can pass along to me would be sincerely appreciated.

[Mach8]

On the download page it states the minimum version of PHP that is supported by YaBB SE is 4.04, you are using 4.01 - if you have the ability to upgrade it, I recommend doing that, it may make your problems go away. If not, ask your host to upgrade. I think this is your problem.

[andrea]

Mach8 is probably right. Just logged in and made some test posts. Your board seems to have a problem redirecting to the boardindex after adding new posts. Reminds me strongly of leycos/tripod problems. Are you hosted on a paid host or own server?

IM's seem to work fine. No error after posting a new IM.

But you seem to have other problems, too. At least you cannot enter the amin menu (browser hangs if you try).

[andrea]

Just discovered a similar thread that might be interesting for you, please read this, too:
http://www.yabb.info/community/index.php?board=140;action=display;threadid=7658

[Boom]

Thank you Andrea and Mach8 for taking time to review my problem. I spoke with my Web Host and they will upgrade the current version of PHP to 4.1.2 for me and it should be completed within 1 week.

Andrea, I also tried to change the code as per your suggestion in the thread you pointed out to me, but it did not work.

I will keep you posted if the PHP upgrade does not work, please keep your fingers crossed for me.

[andrea]

In the meanwhile I would recommend you to change your Admin password. You can give it again in a week if necessary.

[Boom]

My Web Host has upgraded the PHP to ver 4.1.2 so I reinstalled YABBSE. I also converted my old board Yabb Gold over. Unfortunately I am still getting the same errors,  no change at all.

http://www.nonameclan.com/index.php

Can someone take a close look at this and perhaps point me int the correct direction to get this resolved? Many thanks in advance,....

[Jeff Lewis]

The issue is this query on 742.

Code Select Expand

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

Yours may look different though, do you think you could post it for us?

[Boom]

Here is one of the errors.

An Error Has Occurred!

2: Supplied argument is not a valid MySQL result resource
(/home/boom/nonameclan-www/yabbse/Sources/Post.php ln 744)
 
I also get another error when I click on the admin button, go to misc and select Detailed Version Check, it displays an error message:
 
 The page cannot be displayed

I also get a slew of messages when I click on the HTML Validator on the bottom of the page, I cannot display them here because it is too long, but if you run the validator it will show you  few outstandning issues with the template.

[Boom]

*Bump* Did I forget to include something you where looking for? Please advise soonest,...

[Jeff Lewis]

Yes, I posted a line of code, then asked yo to post it but you gave me the error.

Send me your Post.php if you must...

[Boom]

OK I understand what you wanted now, here is line 742, from what I can see it's the same as the line you posted

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

[Jeff Lewis]

Right after that line enter this:

echo "Error: ".mysql_error();

That will tell you what the exact error is so we can fix it...