Ich hab mir das Froogle Data Feeder Modul vom Bereich Downloads gezogen und richtig konfiguriert. Dennoch werden MySQL Fehlermeldungen ausgegeben:
: SQL error Table '*******.categories' doesn't exist| sql = SELECT concat( 'http://www.muuskist.de/*********************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.muuskist.de/************' ,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
*=verscheiert, damit man das net lesen kann
Kann mir bitte jemand helfen? Danke!
: SQL error Table '*******.categories' doesn't exist| sql = SELECT concat( 'http://www.muuskist.de/*********************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.muuskist.de/************' ,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
*=verscheiert, damit man das net lesen kann
Kann mir bitte jemand helfen? Danke!
Kommentar