Number of Reviews in Member List

tj2653 · August 21st, 2006, 01:50 PM

In the latest build of 3.31, the number of reviews in the Reviews column of showmembers.php doesn't appear to match up with each user's actual number of reviews.

For instance, on http://s89196893.onlinehome.us/test/showmembers.php, it shows the user "test" has 2 Reviews, but if you click on their name, it shows 3 reviews. 3 reviews is the correct number, as I did 3 test reviews.

This also happens on my live build: it shows that I have 10 reviews on the list view when I really only have 1, and it shows another user as having 0 on the list view, when they actually have 9.

Chuck S · August 21st, 2006, 02:15 PM

in showmembers.php try changing this query

Code:

Content visible to verified customers only.

to say this

Code:

Content visible to verified customers only.

tj2653 · August 21st, 2006, 04:13 PM

Quote:

Originally Posted by Chuck S

in showmembers.php try changing this query

Code:

Content visible to verified customers only.

to say this

Code:

Content visible to verified customers only.

Hi,

That resulted in:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mypath/showmembers.php on line 382

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mypath/showmembers.php on line 382

Chuck S · August 21st, 2006, 04:20 PM

oops reapply the query

tj2653 · August 21st, 2006, 04:26 PM

Quote:

Originally Posted by Chuck S

oops reapply the query

Thanks for the quick reply...that version works fine