Google Base Feeder Support Thread [OLD]

[heimskr75]

I get the following error for any version I install even the latest 1.5.3.

Processing: Feed - Yes, Upload - No
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 DESC' at line 11
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, s.specials_new_products_price, s.expires_date, 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, p.products_weight FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_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 DESC]

My server is running mysql 4.1.22-standard. Being a newb to coding and all I have no clue how to fix this. Thanks

[lismith]

I don't have access to php.ini unless I install my own php. I think it would be easier to just create the file offline.

[numinix]

Hi everybody :)

I'm having a bit of a problem setting up the feed.

The issue I believe I am having with the shop is that the location of the shop is at http://www.duckworthsuk.com/shop/ (when you visit http://www.duckworthsuk.com the index.php forwards you on to http://www.duckworthsuk.com/shop)

These are the settings you are after.

Store Address: http://www.duckworthsuk.com/shop (also tried http://www.duckworthsuk.com/)
Output Directory: feed/ (also tried /feed/)

The odd thing is that first of all it puts an extra "shop" in the URL, so it looks in http://www.duckworthsuk.com/shop/sho...orthsukcom.xml (or http://www.duckworthsuk.com/shop/sho...orthsukcom.xml when output directory is "feed/"). I have created a blank file in the above directory that will be overwritten. However, when I click on the "Click [HERE] to create / update your product feed.", the javascript window updates with the index page, and the feed file generated is invalid (it's actually HTML).

You can see it here: http://www.duckworthsuk.com/shop/sho...orthsukcom.xml

I am using SEO URL's 3.0.0-beta1 as well, could that be conflicting with it?

I have created a blank .xml called "duckworthsukcom.xml" in

There shouldn't be a problem with SEO URLS or installing to a /shop/ folder. All paths are relative so you should be uploading googlefroogle.php to /shop/ and all other folders to there relative locations as well.

I get the following error for any version I install even the latest 1.5.3.

Processing: Feed - Yes, Upload - No
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 DESC' at line 11
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, s.specials_new_products_price, s.expires_date, 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, p.products_weight FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_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 DESC]

My server is running mysql 4.1.22-standard. Being a newb to coding and all I have no clue how to fix this. Thanks

You have the same MySQL version as I do, so I am not sure what the error is. Please completely uninstall the script by running the uninstall.sql. Then upload all of the 1.5.3 files overwriting any existing files and then reinstall the googlefroogle.sql file by copying and pasting. Let me know how it goes.

I don't have access to php.ini unless I install my own php. I think it would be easier to just create the file offline.

Yes, you can create a php.ini and place it in your store's root directory.