1 Just installed Technopolis fresh Theme OC version 2.0.1.1
2 Installed BE
3 Then Installed the Live search ( Installed Sucessfully )

Tried to do a random search , there were no results shown.
Checked Error Logs and this is the error.
4 i have tried this on a live server also, got same error.

Help is requested.

2016-10-25 10:18:10 – PHP Notice: Error: 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 ‘AND pd2.quantity = 1 AND ((pd2.date_start = “0000-00-00″ OR pd2.date_start < NOW' at line 6Error No: 1064SELECT p.product_id, p.model, p.price, p.image, pd.name, p.quantity, p.stock_status_id, p.tax_class_id, m.name AS manufacturer,
(SELECT price
FROM oc_product_discount AS pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id =
AND pd2.quantity = 1 AND ((pd2.date_start = “0000-00-00″ OR pd2.date_start NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC
LIMIT 1
) AS discount,
(SELECT price
FROM oc_product_special AS ps
WHERE ps.product_id = p.product_id
AND ps.customer_group_id =
AND ((ps.date_start = “0000-00-00″ OR ps.date_start NOW()))
ORDER BY ps.priority ASC, ps.price ASC
LIMIT 1
) AS special
FROM oc_product AS p
INNER JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
INNER JOIN oc_product_description AS pd ON p.product_id = pd.product_id
LEFT JOIN oc_manufacturer AS m ON p.manufacturer_id = m.manufacturer_id
WHERE p.status = 1
AND p.date_available <= NOW()
AND pd.language_id = 1 AND p.date_available <= NOW()
AND p2s.store_id = 0
ORDER BY pd.name ASC in J:\wamp64\www\dreamtrendsnew\system\library\db\mysqli.php on line 40
2016-10-25 10:18:10 – PHP Notice: Trying to get property of non-object in J:\wamp64\www\dreamtrendsnew\system\vendor\BurnEngine\extension\live_search\catalog\model\defaultModel.php on line 74
2016-10-25 10:18:10 – PHP Warning: Invalid argument supplied for foreach() in J:\wamp64\www\dreamtrendsnew\system\vendor\BurnEngine\extension\live_search\catalog\model\defaultModel.php on line 74
2016-10-25 10:18:16 – PHP Notice: Error: 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 'AND pd2.quantity = 1 AND ((pd2.date_start = "0000-00-00" OR pd2.date_start < NOW' at line 6Error No: 1064SELECT p.product_id, p.model, p.price, p.image, pd.name, p.quantity, p.stock_status_id, p.tax_class_id, m.name AS manufacturer,
(SELECT price
FROM oc_product_discount AS pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id =
AND pd2.quantity = 1 AND ((pd2.date_start = “0000-00-00″ OR pd2.date_start NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC
LIMIT 1
) AS discount,
(SELECT price
FROM oc_product_special AS ps
WHERE ps.product_id = p.product_id
AND ps.customer_group_id =
AND ((ps.date_start = “0000-00-00″ OR ps.date_start NOW()))
ORDER BY ps.priority ASC, ps.price ASC
LIMIT 1
) AS special
FROM oc_product AS p
INNER JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
INNER JOIN oc_product_description AS pd ON p.product_id = pd.product_id
LEFT JOIN oc_manufacturer AS m ON p.manufacturer_id = m.manufacturer_id
WHERE p.status = 1
AND p.date_available <= NOW()
AND pd.language_id = 1 AND p.product_id IN (44,105,46,49,35)
AND p2s.store_id = 0
ORDER BY pd.name ASC in J:\wamp64\www\dreamtrendsnew\system\library\db\mysqli.php on line 40
2016-10-25 10:18:16 – PHP Notice: Trying to get property of non-object in J:\wamp64\www\dreamtrendsnew\system\vendor\BurnEngine\extension\live_search\catalog\model\defaultModel.php on line 74
2016-10-25 10:18:16 – PHP Warning: Invalid argument supplied for foreach() in J:\wamp64\www\dreamtrendsnew\system\vendor\BurnEngine\extension\live_search\catalog\model\defaultModel.php on line 74

• This reply was modified 2737 days ago by  yogesh.