When site reviews are posted on the site, anything with an apostrophe gets three slashes. For example, "there's" becomes "there\\\'s" or "it's" becomes "it\\\'s."

How can I fix this?

I have version v.2.0.1.0b SEF.

Thanks in advance.

Where to fix this really depends on how the reviews were added, whether they were edited via the admin panel etc.. but in looking for potential causes I did spot that the review edit form doesn't strip the slashes the way it should ..

In file admin/reviews.php near line # 389 locate

Code:

<td class="text">Review: </td> <td><textarea class="small" name="Review" rows="7" cols="40"><?=$rows[Review]?></textarea></td>

Replace that last line with ...

Code:

cols="40"><?php echo stripslashes($rows[Review]);?></textarea></td>

If you are interested,, apostrophes are normally used as data delimiters in MySQL, to seperate one portion of a record from the nest. To store them in a MySQL database, they need to be preceded by a slash, so they are not mistaken for a delimiter. The trick is adding backslashes before entry, (which the script apparently does a fine job of) and stripping them before display, which in the case of the review editor was overlooked.

Thanks! The fix worked , but there is still another problem remaining related to this one.

In the "Featured Site" section (the area where random featured sites appear), reviews or site descriptions with an apostrophe have one slash instead of the three. So in that particular section "I've" becomes I\'ve. How can I fix this?

You'll need to determine the site ID# for those entries and jot them down. The site ID# will be the ending number of the URL you see in your browser's staus bar when you hover over the site's link .../out.php=ID=X

Then access the admin panel and click the "You have X new site reviews to validate." link.

You should get a form where you can enter the ID # and remove the slashes.

Alternatively you could browse the review table directly using PHPMyAdmin, and edit the records that need it.

When I do that, there is nothing to edit. The apostrophes appear normally in the admin/ edit reviews panel (no slashes).

Incidentally, it's not just the reviews that have the extra slash in "the Site Reviews" but the site descriptions as well. Yet they appear perfectly fine on the page listings.