os commerce vraag

[dvcgraphics]

Ik heb volgende fout, maar de index.php werkt ook niet.
Ik zie niets op http://print.dvcgraphics.com

Volgende error werd op 1 van de computers hier getoont.

1064 - 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 'JOIN `manufacturers` ON `manufacturers`.`manufacturers_id` = `products`.`' at line 21

SELECT `products`.*, `products_description`.*, `products_builder_colors`.`color`, `products_builder_colors`.`saturation`, IF(`specials`.`status`, `specials`.`specials_new_products_price`, NULL) AS `specials_new_products_price`, IF(`specials`.`status`, `specials`.`specials_new_products_price`, `products`.`products_price`) AS `final_price`, `products_to_categories`.`categories_id`, `shops_has_products`.`shop_id` as `shop_id`, `shops_has_products`.`id` as `shop_product_id`, `shops_has_products`.`design_id` as `shop_design_id`, `shops_has_products`.`commission` as `shop_commission`, IF(`shops_has_products`.`id`,`shops_has_products_details`.`name`,`products_description`.`products_name`) as products_name, IF(`shops_has_products`.`id`,`shops_has_products_details`.`description`,`products_description`.`products_description`) as products_description, `manufacturers`.`manufacturers_name`, `shops_products_categories_has_products`.`categories_id` as `shop_category_id` FROM `products` LEFT JOIN `products_description` ON `products_description`.`products_id`=`products`.`products_id` AND `products_description`.`language_id` = LEFT JOIN `manufacturers` ON `manufacturers`.`manufacturers_id` = `products`.`manufacturers_id` LEFT JOIN `specials` ON `products`.`products_id` = `specials`.`products_id` LEFT JOIN `products_builder_colors` ON `products_builder_colors`.`prodId` = `products`.`products_id` AND `products_builder_colors`.`default` = 1 LEFT JOIN `products_to_categories` ON `products_to_categories`.`products_id` = `products`.`products_id` LEFT JOIN `categories` USING(`categories_id`) LEFT JOIN `shops_has_products` ON `shops_has_products`.`product_id` = `products`.`products_id` AND `shops_has_products`.`shop_id` = 0 LEFT JOIN `shops_products_categories_has_products` ON `shops_products_categories_has_products`.`product_id` = `shops_has_products`.`id` LEFT JOIN `shops_has_products_details` ON `shops_has_products_details`.`shops_has_products_id` = `shops_has_products`.`id` WHERE `products`.`products_status` = '1' AND `categories`.`parent_id` IN ('3','123','95','96','97','98','99','100','101','102','117','59','60','61','62','63','64','67','103','104','105','106','108','119','82','83','84','85','86','89','90','91','92','109','110','147','121','120','115','122','124','125','126','127','146','129','130','131','132','133','134','135','136','137','138','139','140','141','142','148','149','150','151','152','153','154','155','156','157','158','159','160','161') AND `categories`.`status` = '1' ORDER BY `products`.`products_id` DESC LIMIT 1

[TEP STOP]


Backtrace data: database.php tep_db_error L:55 contentProducts.php tep_db_query L:145 tplgeneral.php contentProducts->getProductsInfo L:398 tplgeneral.php TplGeneral::header_menu L:221 index.php TplGeneral::header L:48

Wie kan mij helpen a.u.b.

 

[dvcgraphics]

Niemand?