VM 2.0.6 - backend SQL error in custom fields filtering

Started by SamF, April 19, 2012, 09:26:42 AM

Previous topic - Next topic

SamF

Hello,

J2.5.4 + VM 2.0.6

Back end->Products->Custom Fields

path:  /administrator/index.php?option=com_virtuemart&view=custom

Trying to filter the fields by field name for certain parent (while the field name does not belong in this parent).

Got the following error:


vmError: exeSortSearchListQuery You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '`custom_title` LIKE "%ProductWidth%" LIMIT 0, 10' at line 1
SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `xyxyxyx_virtuemart_customs` WHERE field_type <> "R"
AND field_type <> "Z" AND field_type <> "G" AND `custom_parent_id` =17AND `custom_title` LIKE "%ProductWidth%" LIMIT 0, 10

Warning:  Invalid argument supplied for foreach() in
/qsqsqsqsq/administrator/components/com_virtuemart/models/custom.php on line 104