[FONT=Times New Roman]Hi[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]This is the error I am getting[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]It is a fresh install of the 1.41 on zen 1.37 , I set the feed and his folders to 777[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Froogle Data Feeder v.1.4.1 09.07.2007 12:00 started 2007/07/09 16:22:35
Feed file - /home/tiledepo/public_html/store/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - No[/FONT]
[FONT=Times New Roman]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 'ORDER BY p.products_id ASC' at line 13
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, pc.categories_id, cd.categories_name, c.parent_id FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN products_to_categories pc ON (p.products_id = pc.products_id) LEFT JOIN categories_description cd ON (pc.categories_id = cd.categories_id) LEFT JOIN categories c ON (c.parent_id = pc.categories_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC][/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]please advice[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]p.s i tought i already post it here, for some reason i dont see my earlier post[/FONT]
[FONT=Times New Roman]Thank you[/FONT]