PEAR-Error
MDB2 Error: syntax error: _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT
p.product_id,
p.no,
p.textile_no,
p.list_price,
p.eur_list_price,
pt.ro_name AS name
FROM
easygifts.ZMS_Shop_Products AS p,
LEFT JOIN easygifts.ZMS_Shop_Products_Texts AS pt ON pt.no=p.no
WHERE
p.in_action=1
AND p.item_brand IN ('Nr. 1', 'SOLS', 'FRUIT OF THE LOOM', 'B&C', 'Stedman', 'Russell Collection', 'Result', 'SX', 'GILDAN', 'Keya', 'Superior SPA', 'CoFee', 'SILICON POWER', 'WENGER', 'Sets', 'Victorinox', 'Regatta', 'Kariban', 'USB', 'Russell', 'Aladdin', 'Stanley', 'Huawei', 'JBL', 'Valento', 'NO1', 'SPA')
ORDER BY RAND() LIMIT 9]
[Native code: 1064]
[Native message: 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 'LEFT JOIN easygifts.ZMS_Shop_Products_Texts AS pt ON pt.no=p.no
WHERE
' at line 10]
Fatal error: Call to undefined method MDB2_Error::fetchAll() in /var/www/www.its-easy-now.hu/modules/shop/shop_search.php on line 57