If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Why are only *some* of my reviews showing?

Why are only *some* of my reviews showing?

Started by plymgary1 on 7 Dec 2012, 3:07 PM · Views: 915

Results 1 to 5 of 5
7 Dec 2012, 3:07 PM
#1
plymgary1 avatar

plymgary1

Zen Follower

Join Date:
Feb 2009
Posts:
121
Plugin Contributions:
0

Why are only *some* of my reviews showing?

Hi there,

I've been adding some reviews using PHPmyadmin today but they're not showing. Only the old ones are. I'm not sure what I've done so maybe someone else has an idea.

For example, take 'Lu Hyatt' at the bottom of this table. She purchased this product (number 351). This is a closer inspection on her data in the table.

I think i've put in the information correctly in reviews_description, here? So, any idea what's gone wrong?

I'm stumped.

Many thanks,

Gary :)

7 Dec 2012, 3:16 PM
#2
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,336
Plugin Contributions:
41

Re: Why are only *some* of my reviews showing?

Adding them directly likely misses a dependent database item that is associated when the login and write a review.

~Melanie

7 Dec 2012, 3:20 PM
#3
plymgary1 avatar

plymgary1

Zen Follower

Join Date:
Feb 2009
Posts:
121
Plugin Contributions:
0

Re: Why are only *some* of my reviews showing?

plymgary1:

Hi there,

I've been adding some reviews using PHPmyadmin today but they're not showing. Only the old ones are. I'm not sure what I've done so maybe someone else has an idea.

For example, take 'Lu Hyatt' at the bottom of this table. She purchased this product (number 351). This is a closer inspection on her data in the table.

I think i've put in the information correctly in reviews_description, here? So, any idea what's gone wrong?

I'm stumped.

Many thanks,

Gary :)

Thanks. I've inserted all the other reviews this way so I know I can get it to work. It's just a question of how. No doubt I've overlooked something really obvious! :)

7 Dec 2012, 5:53 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Why are only *some* of my reviews showing?

In phpMyAdmin, do a search on the table:
reviews

for products_id 351 ...

How many come up?

Now search the table:
reviews_description

for each of their reviews_id ...

Do you find a match for each one?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

7 Dec 2012, 6:24 PM
#5
plymgary1 avatar

plymgary1

Zen Follower

Join Date:
Feb 2009
Posts:
121
Plugin Contributions:
0

Re: Why are only *some* of my reviews showing?

Hi,

Thanks for the replies. You know, I took the easy way out with this. Made life much easier. :)