Hi All
I originally had around 13,000 prods and the mod ran fine. Then I added a cat with subcats that has around 21,000 prods. I was able to run it on only that cat a few days ago. I have a few a 15 MB XMLs files that it created and Google accepted, so I know it worked fine until today. ZC 1.3.8, PHP 5
Now, it won't run at all. I haven't added anything since the last run, just moved prods around. I get an out of memory error, my host (hostgator) says they haven't made any changes recently.
I added half of my cats to the "Excluded Category" list, and still get the error. Then I cleared the excluded and just put 1 cat in the "Included Cats" list. Still get the memory error.
I'm using the category IDs, seperated by commas. Is that correct?
I'd really like to find a way to create these files. Is there a place I can hard-code the cat IDs in the code files?
Here's the memory error:
Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2009/01/19 17:35:20
Feed file - address.com/feed/filename_products.xml
Processing: Feed - Yes, Upload - No
2008 MySQL client ran out of memory
in:
[SELECT distinct(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_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 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) WHERE p.products_status = 1 AND p.products_type <> 3 AND p.product_is_call <> 1 AND p.product_is_free <> 1 AND pd.language_id = 1 GROUP BY p.products_id ORDER BY p.products_last_modified DESC]