Dynamic Filter [Support Thread]

[Design75]

Has anyone encountered similar errors with Dynamic Filter v1.0, when using ' for feet and " for inches and filtering for attribute size?
Example Attribute Size: with value 1'-4" x 2'-6"

I entered a the value in a testshop and getting the same error. Like explained to you in other threads it has to do with the ' and " in the value name. I think the only solution right now is to use inch and ft instead

[Kevin205]

I entered a the value in a testshop and getting the same error. Like explained to you in other threads it has to do with the ' and " in the value name. I think the only solution right now is to use inch and ft instead

I cannot use inch and ft, as the owner is insisting in getting size attribute in that particular format. I am trying to use escape or special character codes to resolve the issue; as suggested in the other threads.

Thank you for the reply and your solution.

[Design75]

I cannot use inch and ft, as the owner is insisting in getting size attribute in that particular format. I am trying to use escape or special character codes to resolve the issue; as suggested in the other threads.

Thank you for the reply and your solution.

I also tried using the escapes, and special character codes, but they are rewritten to the original character when saving the attribute name

[Kevin205]

I also tried using the escapes, and special character codes, but they are rewritten to the original character when saving the attribute name

Thank you for confirming that.

I think the error is getting from the following file at around line 54, I am trying to make sense out of it.

includes/modules/MyTemplate/dynamic_filter.php

[Design75]

Thank you for confirming that.

I think the error is getting from the following file at around line 54, I am trying to make sense out of it.

Basically what happens is that the single and double are entered in to the query, and thus causing errors. We need to figure a way to tell the script to add an escape to certain characters before adding them to the query.
It shouldn't be that difficult, but my skills are still limited, and am learning on the way :)

[Kevin205]

but my skills are still limited, and am learning on the way :)

Same here.

I tried escaping the " and or '. No luck.

The only thing that does not produce an error, is the following format:

1& #39;-2& #34; x 1& #39;-2& #34;

But try to tell a shop owner to look at the following and do your additions, deletions, edits and audits and etc.

5&# 39;-7& #34; x 3& #39;-11& #34;
1& #39;-2& #34; x 1& #39;-2& #34;
12& #39;-4& #34; x 6& #39;-6& #34;
1&# 39;-2& #34; x 1& #39;-2& #34;
2&# 39;-9& #34; x 5& #39;-3& #34;
.
.
.

How is that for head spin?

I am trying to figure out a way also.

Thanks.




ps. Spaces between & and # are left out, so it displays here.

[Design75]

Same here.

I tried escaping the " and or '. No luck.

The only thing that does not produce an error, is the following format:


But try to tell a shop owner to look at the following and do your additions, deletions, edits and audits and etc.


How is that for head spin?

I am trying to figure out a way also.

Thanks.




ps. Spaces between & and # are left out, so it displays here.

Here's a quick solution,

find in includes/modules/YUOR_TEMPLATE/dynamic_filter.php

          $having .= ' FIND_IN_SET("' . $key . $value . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))'; 

replace with:

          $value = preg_replace('/"/','\\"',$value);
          $value = preg_replace('/&acute/','\\&acute',$value);
          $having .= ' FIND_IN_SET("' . $key . $value . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))'; 

more values can be added if needed