Kennt sich hier jemand mit dem Froogle Feed Creator aus?
Habe den mal installiert und bekomme immer folgende Fehlermeldung, wenn ich froogle.php ausführe:
-----------------------------------
: SQL error Table 'zencart-hotel-tv.categories' doesn't exist| sql = SELECT concat( 'http://www.hotel-tv.org/index.php?main_page=product_info&products_id=' ,products.products_id) AS product_url, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, FORMAT(products.products_price,2)*1 AS price, CONCAT( 'http://www.hotel-tv.org/images/' ,products.products_image) AS image_url, CONCAT_WS( ' > ' , catdescparent.categories_name , catdesccurrent.categories_name ) AS category FROM categories , products, products_description, categories_description as catdesccurrent, products_to_categories LEFT JOIN categories_description AS catdescparent ON (catdescparent.categories_id = categories.parent_id and catdesccurrent.language_id = 1) WHERE products.products_id=products_description.products _id AND products_description.language_id = 1 AND catdescparent.language_id = 1 AND products.products_id=products_to_categories.produc ts_id AND products_to_categories.categories_id=categories.ca tegories_id AND catdesccurrent.categories_id = categories.categories_id AND products.products_status != 0 ORDER BY products.products_id ASC
-----------------------------------
Ist das vielleicht nicht mit der Version kompatible?
Habe den mal installiert und bekomme immer folgende Fehlermeldung, wenn ich froogle.php ausführe:
-----------------------------------
: SQL error Table 'zencart-hotel-tv.categories' doesn't exist| sql = SELECT concat( 'http://www.hotel-tv.org/index.php?main_page=product_info&products_id=' ,products.products_id) AS product_url, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, FORMAT(products.products_price,2)*1 AS price, CONCAT( 'http://www.hotel-tv.org/images/' ,products.products_image) AS image_url, CONCAT_WS( ' > ' , catdescparent.categories_name , catdesccurrent.categories_name ) AS category FROM categories , products, products_description, categories_description as catdesccurrent, products_to_categories LEFT JOIN categories_description AS catdescparent ON (catdescparent.categories_id = categories.parent_id and catdesccurrent.language_id = 1) WHERE products.products_id=products_description.products _id AND products_description.language_id = 1 AND catdescparent.language_id = 1 AND products.products_id=products_to_categories.produc ts_id AND products_to_categories.categories_id=categories.ca tegories_id AND catdesccurrent.categories_id = categories.categories_id AND products.products_status != 0 ORDER BY products.products_id ASC
-----------------------------------
Ist das vielleicht nicht mit der Version kompatible?
Kommentar