I'm experiencing some problems with the feeder. I recently tried to upload a new feed but the feed was rejected because it was missing the UPC field. I turned on the auction feilds and now I get the following error:
PHP Code:
Google Base Feeder v.1.6.8 02.08.2008 22:33:59 started 2008/02/26 18:14:29
Feed file - /home/moesperf/public_html/feed/prommotion_moesperformance_com_products.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
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, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category 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 specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.products_type = 1 OR p.products_type = 4 OR p.products_type = 2 OR p.products_type = 5 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_last_modified DESC]
I tried a upgrade to 1.6.8, but still get the error. Any idea what I need to do to get things working agian??