View Single Post
Old September 9th, 2005, 05:16 PM   #2 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,666
Member's List:

Only shows one member, the admin. Other registered users are not shown.

not a bug it only shows people that have uploaded products

$query = "SELECT id, date, user, userid, bigimage, cat, SUM(views) AS tviews,COUNT(*) AS pcount,MAX(date) AS maxdate FROM {$Globals['rp_db_prefix']}products $phrase GROUP BY user $sortcode";

Menubar:

After logging in, clicking on the profile link returns:

Script not called correctly. Navigate to a specific product, then click on the edit link.

make sure your using the correct updated files from the distribution. I see my profile when I click on it on 4 different installs I have

Admin interface:

If I create a new usergroup and then try to delete it, I get:

You can't delete this usergroup.

try deleting the code in bold

Code:
Content visible to verified customers only.
DELETE THIS LINE

Code:
Content visible to verified customers only.
add in bold the two thing on the typecast line

Code:
Content visible to verified customers only.
then alter in bold on this line

Code:
Content visible to verified customers only.
The reviews column doesn't appear to be accurately tracking the number of reviews after some have been deleted. For example, we have 2 reviews left for one product. Numerous reviews have been added and deleted but the showcat page shows 3 reviews for said product.

There aren't any unapproved reviews not showing and I tried a recalcualtion in scan db in the admin interface but that didn't have any effect.

Well the code above below for delete looks correct to me and it works on my install I just tested deleting things etc. I added a review and it properly updated as well. Did you run all upgrade scripts before this one right? Cause I beleive the 2.8-2.91 added a numreviews column to the products table and calculated the number of reviews and that is needed to work right. I show in 3.01 adding and deleting comments works right

Upgradecategories function will not correct this count since its not in the cats table. Numreviews is not autocalculated on scan database


Code:
Content visible to verified customers only.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.

Last edited by Chuck S; September 9th, 2005 at 05:50 PM.
Chuck S is online now   Reply With Quote