showmembers.php error

F4CC · November 25th, 2006, 11:55 PM

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/f/4/c/f4cccom/html/gallery/showmembers.php on line 352

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/f/4/c/f4cccom/html/gallery/showmembers.php on line 371

http://www.f4cc.com/gallery/showmembers.php

Please help.

Robert

HHeinzer · November 26th, 2006, 12:16 AM

This is the same error I was getting and posted about tonight as well. I do apologize, we must have been posting at the same time. Hopefully we can get this figured out.

ratm · November 26th, 2006, 12:37 AM

Amazing - I'm getting the same error right now.

I just re-installed Photopost v5.6 on my vBulletin 3.6.4 site twice and the error is still there.

BTW, the error appears every time you click on "Member Galleries".

Need help!

Thanks

HHeinzer · November 26th, 2006, 12:37 AM

Starting to sound like a bug to me! Hopefully we can all get this fixed soon! LOL

ratm · November 26th, 2006, 12:40 AM

Yeah, for us 3 to have the problem at the same time makes me think it's a bug, too.

F4CC · November 26th, 2006, 12:11 PM

I think i speak for us all when I say "WTF!". Is this a brand new release? Has this not been tested?

This has delayed my new site launch, lets hope that support has a solution.

HHeinzer · November 26th, 2006, 12:18 PM

I have opened ours because we have some things going on where people NEED to upload to other galleries. At the same time, there are already 60 images that people can not conveniently view. I really hope this is resolved soon as we expect our traffic to start picking up very soon and it's NOT a good thing to see!

F4CC · November 26th, 2006, 12:44 PM

This is the first time i've ever used or been exposed to this product. Im going to wait and give it a fair chance otherwise I'll have to buy something else tomorrow night.

Chuck S · November 26th, 2006, 02:33 PM

http://www.f4cc.com/gallery/showmembers.php?cat=1

I am not seeing any issues here?

F4CC · November 26th, 2006, 02:43 PM

Quote:

Originally Posted by Chuck S

http://www.f4cc.com/gallery/showmembers.php?cat=1

I am not seeing any issues here?

Hi Chuck,

Nor do I, however the link which I posted above does have a problem. Any ideas on that?

Robert

Chuck S · November 26th, 2006, 02:53 PM

I am not seeing any errors when I view it so what do you see?

HHeinzer · November 26th, 2006, 03:08 PM

Chuck, if you go to www.scrap2basics.net/PhotoPost and click on member galleries, you will see the error that we all seem to be seeing.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.kisha/summer05/scrap2basics.net/PhotoPost/showmembers.php on line 352

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.kisha/summer05/scrap2basics.net/PhotoPost/showmembers.php on line 371

And if you turn on debug:
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT p.id, p.date, p.user, p.userid, SUM(p.views) AS tviews, COUNT(*) AS pcount, SUM(p.numcom) as numcom, MAX(p.lastpost) AS maxlast, MAX(p.date) AS maxdate, SUM(p.filesize) AS tfilesize, u.lastphoto, u.lastdate, p2.bigimage, p2.cat, p2.storecat, p2.height, p2.width FROM pp_photos p LEFT JOIN pp_users u ON (u.userid=p.userid) LEFT JOIN pp_photos p2 ON (p2.id=u.lastphoto) WHERE p.approved=1 GROUP BY p.userid ORDER BY maxlast DESC

Result: Unknown column 'u.lastphoto' in 'field list'

Database handle: Resource id #6

Chuck S · November 26th, 2006, 05:28 PM

what happens if you run your upgrade script? 5.5 to 5.6

HHeinzer · November 26th, 2006, 06:08 PM

I don't know. I guess I'll have to try that. As I said, I was under the impression that I *HAD* the most recent version since there were files in the download that had recently been modified. I guess I'll go looking and make sure that I upgrade the software.

F4CC · November 26th, 2006, 06:13 PM

My error is with a brand new install and brand new Vb install. It even occurs before any editing or modifying. Everything works except this error. When you click on the default "Member Galleries" from anywhere you may be it happens. I reinstalled, recreated databases, reinstalled forums...

Here is a screen grab of the error that I posted to my gallery.
http://www.f4cc.com/gallery/showphoto.php?photo=3&cat=1

ratm · November 26th, 2006, 06:36 PM

Like I said in my first post, I have the same problem with a fresh install. I actually did TWO fresh installs because I thought it was something else, but it looks like a bug.

I get the same errors as F4CC:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/photopost/showmembers.php on line 352

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxxxxx/public_html/photopost/showmembers.php on line 371

Still looking for a fix...

ratm · November 26th, 2006, 06:39 PM

Quote:

Originally Posted by Chuck S

http://www.f4cc.com/gallery/showmembers.php?cat=1

I am not seeing any issues here?

Chuck, I mentioned in my first post where the error appears:

The error appears every time you click on "Member Galleries"

ionut · November 26th, 2006, 08:25 PM

I too get this error on a fresh install integrated with vb3.6.4.
php 5.0.4 & mysql 4.1.21

ratm · November 26th, 2006, 08:37 PM

Is Chuck the only one working on this? Photopost staff needs to hire some more help; you can't put all this on one guy.

1996 328ti · November 26th, 2006, 08:48 PM

I have two installs with showmembers.php that is working.
I noticed most of the files in 5.6 are dated 11/25 but some are 11/26.
showmembers being one of them that might have been changed 11/26.
I'd suggest downloading the files again. Maybe the build was changed from when you downloaded it.