Hi there,
after upgrading to latest Fabrik version, I am facing an SQL Error:
Here is an example of the problematic query:
SELECT SQL_CALC_FOUND_ROWS DISTINCT `betabelle`.`ID` AS `betabelle___ID`
FROM `betabelle`
WHERE ( betabelle.approved = 1 ) AND ( `betabelle`.`hersteller` = 'Birkel' a `betabelle`.`bezeichnung` LIKE '%nudel%' ) LIMIT 0, 10
The Error is very evident.
It is the "a" between 'Birkel' and `betabelle`, which should be an AND instead.
The two parameters `betabelle`.`hersteller` and `betabelle`.`bezeichnung` are input data from a filter on the website frontend.
With Version 3.3.2 this problem did not occur.
Could you please give me a hint, how to solve this issue.
Thanks in advance and have a nice day
Michael
after upgrading to latest Fabrik version, I am facing an SQL Error:
Here is an example of the problematic query:
SELECT SQL_CALC_FOUND_ROWS DISTINCT `betabelle`.`ID` AS `betabelle___ID`
FROM `betabelle`
WHERE ( betabelle.approved = 1 ) AND ( `betabelle`.`hersteller` = 'Birkel' a `betabelle`.`bezeichnung` LIKE '%nudel%' ) LIMIT 0, 10
The Error is very evident.
It is the "a" between 'Birkel' and `betabelle`, which should be an AND instead.
The two parameters `betabelle`.`hersteller` and `betabelle`.`bezeichnung` are input data from a filter on the website frontend.
With Version 3.3.2 this problem did not occur.
Could you please give me a hint, how to solve this issue.
Thanks in advance and have a nice day
Michael