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.hu_name AS name
FROM
macma.ZMS_Shop_Products AS p,
LEFT JOIN macma.ZMS_Shop_Products_Texts AS pt ON pt.no=p.no
WHERE
p.in_action=1
AND p.item_brand IN ('Result', 'M-Collection', 'CrisMa', '7 Ceramics', 'Ferraghini', 'B&C', 'Fruit of the Loom', 'Stedman', 'Valento', 'Mark Twain', 'USB', 'SX', 'Keya', 'Superior SPA', 'RUSSELL', 'Gildan', 'Sols', 'Regatta', 'Kariban', 'Pierre Cardin', 'Vanilla Season', 'Schwarzwolf', '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 macma.ZMS_Shop_Products_Texts AS pt ON pt.no=p.no
WHERE
p.' at line 10]
Fatal error: Call to undefined method MDB2_Error::fetchAll() in /var/www/www.mcollection.hu/modules/shop/shop_search.php on line 56