problem in product_reviews_info.php

[Guest]

Hi,

 

I dont know what happening, 'cause I didnt mess with osCommerce code from one month ago.

And the last time I saw any of my "product_reviews_info.php" pages, they used to work fine.

 

But now, they have been screwed up.

And I did try to restore a back-up file (the original from osCommerce) and it doesnt work, showing exactly the same problem.

 

Check:

Reviews screwed up in product_reviews_info.php

 

They show something like this:

reviewed by T, date: 30/11/2036

T

 

Rating: T of 5 ?tomos! [T de 5 ?tomos!]

 

The date is wrong, the rating (?tomos = stars) is wrong, the customer name is wrong, and of course, the review text is wrong

 

BTW, my reviews seem to be intact in the database.

And I have installed a contribution that shows reviews in the product_info.php pages, and reviews are showed without problems in those products pages.

 

I can figure out what is happening.

 

This doesnt seems to be a problem with the php code of the page (because I have restored a previous file that used to work, and it doesnt work too).

 

Could it be a database problem?

 

Please, any help will be appreciated.

Thanks in advance an excuse my english

[Guest]

Well, after digging in the forums, I have found the solution

 

http://www.oscommerce.com/community/bugs,1315

 

 

Reviews Box in Left Column doesn't work (+solution)

Status:  Closed

Assigned To:  Mark Keith Evans

Last Updated:  10th January 2004 16:19:00

Reporter:  [email protected]

Version:  2.2-MS2

Type:  Functions & Classes

PHP Version:  4

[Comment on this report]

 

If you put ReviewsBox in the left column, strange things will happen.

Why?

at the top of product_reviews_info.php

there is a query which initializes $review variable. Then there is include of column_left.php which inbt turn includes boxes/reviews.php. In boxes/reviews.php we also have a query with another $review variable. The $review var. is then used in product_reviews_info.php. So instead of the original one, the script uses the one from boxes/reviews.php with another fields.

 

 

Solution: change 4 (lines 34-38) occurances of $review to something like $review_txt in boxes/reviews.php.

 

Piotr Kami?ski

[urte]

Thanks for this great advice, it worked perfect for me, spent ages trying to fix this, wish i had found this straight away.