Zen Cart Logo
Forums / Templates, Stylesheets, Page Layout / Reviews Pending Approval Stuck

Reviews Pending Approval Stuck

Locked

Views: 1,291

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
23 May 2008, 6:51 PM
#1
benn600 avatar

benn600

Zen Follower

Join Date:
Nov 2007
Posts:
124
Plugin Contributions:
0

Reviews Pending Approval Stuck

Reviews Pending Approval is stuck at 2 when there are none waiting. Where can I reset this to be accurate?
Thanks!

23 May 2008, 7:09 PM
#2
benn600 avatar

benn600

Zen Follower

Join Date:
Nov 2007
Posts:
124
Plugin Contributions:
0

Re: Reviews Pending Approval Stuck

Reviews is also stuck at 4 and there are none. I removed them because they were test reviews added by me to make sure they worked.

Isn't calculated data not supposed to be stored in the database? It appears this calculated data is stored in the database...

24 May 2008, 7:48 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Reviews Pending Approval Stuck

The "Reviews" number comes from the number of records in your "reviews" table.
The "Reviews Pending Approval" comes from the number of records in your "reviews" table whose status=0.

What are the status values in your table?