Filter Apostrophes

Submitted by kend on Wed, 2011-07-20 18:01 in Price Tapestry

Hi,

I am importing "Keen Owyhee (Men's) - Black/Keen Yellow". When I paste the string "Keen Owyhee (Men's) - Black/Keen Yellow", the Search box in the Search/Replace entry form adds a backslash, and displays "Keen Owyhee (Men\'s) - Black/Keen Yellow". When this happens, the filter does not replace during import. On the other hand "Keen Owyhee Outdoor Men Black/Yellow" , a different name, no back slash, search-replaces correctly.

So there's something going on with the apostrophe that I don't understand, and seemingly will not allow a search/replace filter to process. I do know we use back slashes to make literals out of special characters. The filter table uses the backslash, but the product table does not.

I checked the raw feed to verify that the search string and the raw string are the same.
Raw feed string: "Keen Owyhee (Men's) - Black/Keen Yellow"
Displayed string in search box: "Keen Owyhee (Men\'s) - Black/Keen Yellow"

Thanks!
Ken.

Hi Ken! I know you've been a

Submitted by support on Wed, 2011-07-20 18:15

Hi Ken!

I know you've been a user for several years now and in an earlier distribution of Price Tapestry there was a bug in which the detection of PHP's "magic quotes" setting (which is what causes the backslash to be inserted) was in the wrong sense.

To fix this, look for the following code at line 73 of includes/widget.php:

if (get_magic_quotes_runtime())

...and REPLACE with:

if (!get_magic_quotes_runtime())

Cheers,
David.
--
PriceTapestry.com

Hi David, That fixed it

Submitted by kend on Wed, 2011-07-20 20:22

Hi David,

That fixed it thank you! I found above code on line 113.

Follow up question about filters. Remember the code you gave me so that I could display the filter values? Well, I use it every time I use filters. It's very handy. Anyway, for some reason when I copy the older feeds_filter.php file into the new version feeds-filter file, the FIELD column on the filter admin display no values.

I was wondering if there's something I'm forgetting to do, or if the old mod you gave me doesn't work with the newer versions?

Thanks!
Ken.

Hi Ken, There shouldn't have

Submitted by support on Thu, 2011-07-21 07:53

Hi Ken,

There shouldn't have been any changes that would affect that but it might be worth just applying the patch again. Restore the original admin/feeds_filters.php from your download .zip, and then look for the following code at line 85:

print "<th>Field</th>";

...and REPLACE with:

print "<th>Data</th>";

Then look for the following code at line 103:

print "<td>".$fields[$filter["field"]]."</td>";

...and REPLACE with;

      print "<td>".$fields[$filter["field"]]."</td>";

      print "<td>".print_r(unserialize($filter["data"]),TRUE)."</td>";

Cheers,
David.
--
PriceTapestry.com