Google Base Feeder Support Thread [OLD]

I discovered the reason.
execute the code of googlefroogle.sql will update some records in table configuration, so our web page can not display properley.
but I do not know how to solve it. anybody can help me?

I do not know what is the reason.
my zencart is v1.3.7 I have integrated with ultimate seo module.
after I installed GFF1.6.7
the webpage error. the infromation is below:

Warning: Variable passed to each() is not an array or object in /home/public_html/includes/classes/db/mysql/query_factory.php on line 121
Warning: Division by zero in /home/mallmain/public_html/includes/classes/split_page_results.php on line 76

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 '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '136' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]

anybody can help me?

I have found the answer to our CRON problem which may just help others, even though it may just be something to do with our server.

The instructions for the CRON command show:

GET http://domain/googlefroogle.php?feed=yes&upload=yes&type=products

which failed consistently for us; however, simply adding single quotes

GET [B]'[/B]http://domain/googlefroogle.php?feed=yes&upload=yes&type=products[B]'[/B]

finally brought success.

I think the requirement for the quotes is due to the multiple instructions within the command.

So, I completely removed all files and and uninstalled and then reuploaded all files and reinstalled sql and then it said:

1062 Duplicate entry 'GOOGLE_BASE_ZERO_QUANTITY' for key 2
in......

thanks,

Eric

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:

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??

Woodymon:

For those whom employ Google Checkout I have heard a rumour that a future update to the GC mod will integrate Google Base feed functionality.

Woody

I just wnated to see if there was an update or mod for this? I have GCO and still have to go in and modify each item to turn on GCO as a payment option to get the checkout badge to appear. When the feeder uploads to Google, it overwrites the configuration and I have to do it again. I'm sure that I am either overlooking something, or have not configured something right. Any help would be appreciated.

this is according to google:
If you'd like to use Google Base-hosted item pages and accept Google Checkout for items in a data feed, simply add "GoogleCheckout" as a payment option under the payment_accepted attribute. Don't include the link attribute. If you do, your listing will direct buyers to your website, instead of a Google Base-hosted page that displays the Google Checkout Buy button.

If you're already using Google Checkout on your website, include "Google Checkout" as a payment option under the payment_notes attribute. In this case, you should include the link attribute, as users will be directed to your Google Checkout-integrated website.

I am using the Level 2 Zen Google Checkout module. So the second statement should apply.

still getting this error please help

upload not working through my fireplace site. bathroom site works fine.

Warning: ftp_put() [function.ftp-put]: Transfer complete. in /home2/public_html/googlefroogle.php on line 547
Second attempt (passive mode on): Upload Failed

Still having issues with the feeder... This time I tried v1.6.10 on a FRESH install with no mods, same error:

Google Base Feeder v.1.6.10 02.28.2008 12:13:59 started 2008/03/01 04:02:37
Feed file - /home/pmlcover/public_html/feed/pmlcovers_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 <> 3 AND p.product_is_call <> 1 AND p.product_is_free <> 1 AND pd.language_id = 1 ORDER BY p.products_last_modified DESC]

Can someone please tell me whats going on?? I never knew how much froogle adds to our sales untill this :D

Install AUCTION SITE ATTRIBUTES to add the UPC and ISBN fields to your products admin page.

I have installed the newest version of google base feeder and configured it.

When I try to create the feed I get this error

Warning:  array_pop() [[URL="http://craft-patterns-online.com/function.array-pop"]function.array-pop[/URL] on line ]: The argument should be an array in /home2/shabecom/public_html/craft-patterns-online.com/googlefroogle.php158

can you tell me where I went wrong?

many thanks

that got distorted in the quote box, should read:

Warning: array_pop() [function.array-pop]: The argument should be an array in /home2/shabecom/public_html/craft-patterns-online.com/googlefroogle.php on line 158

still getting the error, please someone help, i cant see an error on the code,

Google Base Feeder v.1.6.7 05.12.2007 12:53:59 started 2008/03/03 04:20:22
Feed file - /home2/fire/public_html/feed/google_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Upload Failed

Warning: ftp_put() [function.ftp-put]: Entering Passive Mode (72,14,200,3,50,75) in /home2/fire/public_html/googlefroogle.php on line 547
Second attempt (passive mode on): Upload Failed

Upload failed...

numinix:

Install AUCTION SITE ATTRIBUTES to add the UPC and ISBN fields to your products admin page.

Thanks! Really appreciate the help! ;)

My FTP account isn't active yet, but when I try to upload the file manually, I get "We didn't understand the header (first) row of your file. Please make sure you're using valid attribute names."

Any ideas?

kitcorsa -

We had similar and found that altering the code, so passive mode was attemtped before port mode, allowed it to connect ok. It is the same with LPS feeder. I think it's just a firewall issue with the host.

Claire

how do i change this???

i have contacted my hosts regarding this but no change yet.

i have 2 site as seen in my siggy and both on the same host and have there own seporate server. one site works one dont!! its really anoying having to manually upload.

I've installed the .10 version. Still the same trouble with a manually uploaded file, however I am awaiting the results on the FTPed version.

Suddenly, it's not excluding my Gift Certificates category. The previous version was.

ceegeeaar:

kitcorsa -

We had similar and found that altering the code, so passive mode was attemtped before port mode, allowed it to connect ok. It is the same with LPS feeder. I think it's just a firewall issue with the host.

Claire

Could you let me know how you did this in LPS? I can't get that to upload through my Admin at all....and I'd like to set up a Cron Job to do it.

I posted on it before, have a look here..

http://www.zen-cart.com/forum/showthread.php?p=445905&highlight=ceegeeaar#post445905

It is pretty much the same code in lps.php for the live product feeder ftp secion.

Hope it helps you!
Claire

that worked Claire thank you very much.

update!

to turn passive mode on and off in the current version of google base on on lines 540 - 545 find the code:

		while ($attempt < 3 && !$success) { // two attempts, one with pasv off, one with on
			if ($attempt == 0) {
				ftp_pasv($cd, false); // on first attempt, turn pasv off
			} else {
				ftp_pasv($cd, true); // on second attempt, turn pasv on
			}

and replace with the following

		while ($attempt < 3 && !$success) { // two attempts, one with pasv off, one with on
			if ($attempt == 0) {
				ftp_pasv($cd, true); // on first attempt, turn pasv on
			} else {
				ftp_pasv($cd, false); // on second attempt, turn pasv off
			}