"Reviews Pending Approval" Link is active, but no reviews pending... problem...

"Reviews Pending Approval" Link is active, but no reviews pending... problem...

I made a test review on one of the sample database items, and I deleted the item without approving the review.

I noticed that when I added the review, the "Reviews Pending Approval" Link became active.

Now, the link is staying active no matter what, and I can't fix it since the pending review was deleted, along with the deleted item. When I go to the reviews pending page, it's empty--there's nothing there.

It seems there some database flag that got switched on which wont switch off...

Where/ how can I find the database entry to delete that will set things back to normal? (so that the pending review link is only active when there's actually a pending review).

Go to phpMyAdmin in your site's control panel and browse your database table for:
reviews
reviews_description

If you have valid reviews ... then browse the 2 tables for that products_id

If you have no valid reviews ... then you can just Truncate (Empty) them ...

Both tables were already empty, but just to be safe I went ahead & deleted the data on both.

Unfortunately the same problem described above persists--

The link only becomes active if there are records present in the reviews table and are marked as needing approval.

:(

Looks like there's nothing I can do to fix it then-the tables are empty and somehow it still lights up...

it's quite strange really

Browser cache?

the mysql & file based cache are both empty--

and i cleared my browser cache as well

maybe i altered the original file somehow, but it seems unlikely.

this little link is lit up still--

it's like a fly that i want to swat but can't!

I wish I was smart enough to figure out how to fix this lol