price paid not being put into database?

[ncg]

a user of mine sent me this message this morning:

I've come across a small bug in the reviews section. When submitting a review the "Price Paid" doesn't get written to the database. (It did this 3 times in a row on 3 different reviews.)As the page automatically redirects after submitting a review, you can see the "Price Paid" says 'Not Indicated'. So the value got dropped somwhere.

However, the information is written and committed when doing an edit on the "Price Paid" field.

does anybody know anything about this? thanks!

[Chuck S]

I will have to do some testing with 2.91

3.0 is about ready to be released but looking at 2.91 I dont see anything out of place

try commenting out this line in reviews.php and see if it gets written

if ( !is_numeric($price) ) $price = 0;

[ncg]

if 3.0 is about ready, ill just wait for that. its no big deal.

[Chuck S]

Your welcome to grab a copy and try it out by emailing me. It has not been released yet but I think you'll be surprised

RP3 (RP5.1) - Status

You would just upload all the files except config-inc.php and run the upgrade script

[Arnie]

Perhpas your user was entering a price in the format "$46.23"? If the data isn't numeric it'll get ignored by reviewpost and treated and junk and you'll experience the issue you found.

[Chuck S]

yeah well for 2.91 it looks okay but that was my suggestion

46.23 is a numeric variable so it would pass that query

try this

<?

$var="46.23";

if ( is_numeric($var) ) $var = "yes";

echo "$var";

?>


if you run that test script you will see 46.23 is a numeric value. $ is stripped from price a few lines above.

[ncg]

Originally Posted by Arnie

Perhpas your user was entering a price in the format "$46.23"? If the data isn't numeric it'll get ignored by reviewpost and treated and junk and you'll experience the issue you found.

interesting. that might be a possibility. ill ask.