Google Base Feeder Support Thread [OLD]

I have had a cron job running for a few months now, and it worked great

GET 'http://www.shoepeddlers.com/googlefroogle.php?feed=yes&upload=yes&type=products' > /dev/null 2>&1

The file created was shoepeddlers_products.xml and all product were listed

My hosting company switched to a new server
the difference is
apache 2 as compared to 1.3.9
more cpus
more ram
more speed and better security
and a new version of cpanel

now the cron would not run untill I changed it to use “WGET”
now it runs, but it saves the files to shoepeddlers_.xml and no products are listed
the contence of the files is just this

I’ve been work with the hosting company, but we can’t seem to figure it out.

Any suggestions please:frusty::frusty:

I have a same problem that some people had.
Please help me how to solve the problem below.

A thread said "Install Auction Site Attributes".
I activated Auction Site Attributes.
But I still have the same error.
Please help.

1054 Unknown column 'p.products_upc' in 'field list'
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_upc, p.products_isbn, 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) 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]

HiHiHi:

I have a same problem that some people had.
Please help me how to solve the problem below.

A thread said "Install Auction Site Attributes".
I activated Auction Site Attributes.
But I still have the same error.
Please help.

1054 Unknown column 'p.products_upc' in 'field list'
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_upc, p.products_isbn, 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) 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]

You need the following module:

http://www.numinix.com/index.php?main_page=document_general_info&products_id=748

fvb:

I have had a cron job running for a few months now, and it worked great

GET 'http://www.shoepeddlers.com/googlefroogle.php?feed=yes&upload=yes&type=products' > /dev/null 2>&1

The file created was shoepeddlers_products.xml and all product were listed

My hosting company switched to a new server
the difference is
apache 2 as compared to 1.3.9
more cpus
more ram
more speed and better security
and a new version of cpanel

now the cron would not run untill I changed it to use “WGET”
now it runs, but it saves the files to shoepeddlers_.xml and no products are listed
the contence of the files is just this

<?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" xmlns:g="<http://base.google.com/ns/1.0>"> <channel> <title>Shoe Peddlers</title> <link>http://www.shoepeddlers.com</link> <description>shoepeddlers</description>

I’ve been work with the hosting company, but we can’t seem to figure it out.

Any suggestions please:frusty::frusty:

numinix
got any suggestions for me

I have a problem when I set Magic SEO URL's to true, there's no output, I have Magic SEO URL's Installed.

everything works correctly with Magic SEO URL's set to false.

Is there some other configuration required?

I tried searching for a answer, but there's too many threads.

any help would be great

the MSN and Yahoo feeders do the same thing, work set to false, no out put when set to true.

pete

colemanpa:

I have a problem when I set Magic SEO URL's to true, there's no output, I have Magic SEO URL's Installed.

everything works correctly with Magic SEO URL's set to false.

Is there some other configuration required?

I tried searching for a answer, but there's too many threads.

any help would be great

the MSN and Yahoo feeders do the same thing, work set to false, no out put when set to true.

pete

Ok I read about this Magic SEO URL add-on for $25, question do I need this to make the magic SEO URL to work with google base feeder, and if so will it work for the MSN and Yahoo feeder?

pete

colemanpa:

Ok I read about this Magic SEO URL add-on for $25, question do I need this to make the magic SEO URL to work with google base feeder, and if so will it work for the MSN and Yahoo feeder?

pete

ok I figured it out finely, the information wasn't on the forum it was on a web site.

pete

Hello,

I just updated by feeder from a very old version to the latest version on the download pages. I'm using Zencart 1.3.7 and when I upload my feed to Google I'm getting errors. The errors are:

This attribute is no longer supported. Please use a supported attribute. for label.

We Recommend including this attribute for UPC, MPN, ISBN, and brand

The item is missing a required attribute for id. It seems to be blank for all my products in the feed.

Any ideas?

I'm having the exact same problem as fvb:

...it saves the files to shoepeddlers_.xml and no products are listed...

My host uses CPanel as well; my cron cmd line:

curl -s http://your_http_catalog/googlefroogle.php?feed=yes&upload=no&type=products

What am I missing?

Hi all

Apologies if this is an obvious question but I cannot find an answer in this thread.

I currently use this wonderful module to submit to google uk but I would also like to submit simultaneously to google usa.

Any suggestions as to how I do this?

Thanks in advance

Bichon Hotel- healthy products for healthy dogs

I need an automation of the xml file creation on the server.

can I do that w/o setting up a cron job?

I've insatlled this mod on two sites.

Everything seems to work ok -

Checked the feed tahat is created and products are there.
I then upload the feed and the feed "says" it uploaded to google- but when I check the uploaded file, it shows -0- products. The feed doesn't appear in the list of feeds on googlebase either.

This happens for both sites.

What am I missing???

Tina

PS - I can manually updload the feed file just fine!

OK - I just got an error that I need to register the feed - did it will try to upload again.

OK - I just got an error that I need to register the feed - did it will try to upload again.

That's all I needed. File status "SUCCESS" with googleBase.

Thanks,

Tina

imaginarynumber:

Hi all

Apologies if this is an obvious question but I cannot find an answer in this thread.

I currently use this wonderful module to submit to google uk but I would also like to submit simultaneously to google usa.

Any suggestions as to how I do this?

Thanks in advance

---

Bichon Hotel- healthy products for healthy dogs

The difference between USA and UK I think is just a change in configuration for not including the location, correct? If so, just clone the module to have different filenames and configuration keys and then you could have two versions running simultaneously.

Okay, I've tried everything I can remotely think of so...I'll start from scratch.

I've been using the Google Base Feed Uploader for a long while now and have had very few problems. Whenever I had a problem I would go in and change an illegal character from a product so that the feed would go through. My feeds automatically get updated every Monday night and every Friday morning. Last Friday's went fine, Monday nights didn't get any status change until late last night. It was "Successful with errors" and only 834 of 1147 products were inserted. I looked at the products and descriptions and nothing seemed wrong...so I checked to see if there was an upgrade. Noticed that there was a new upgrade out and upgraded. Still didn't work....thought maybe my upgrade was corrupt so I used the uninstall sql and then re-installed it with the googlefroogle sql....still having issues. Went in and moved two products to a category that I put on the "excluded" list so that they wouldn't be sent to the Google Base feed....still having problems. The errors it's giving me are for products that always got listed previously, all I did between Friday and Monday night was add 7 products. Any ideas?

I'd post the Google error details here but considering it's over 200 products that it won't insert....well...it would be a novel.

New update....

I've now also tried completely removing and then installing the Base Feeder fresh and that didn't work. I then tried to exclude ALL of the products that I added since the issue and that didn't work either.

I'm beginning to think that this isn't actually an issue with the Base Feeder now and that maybe Google changed something and now we have to figure out how to fix the Base Feeder to link to it again.

Sorry for the triple post but....after reading through all the issues I'm having right now it seems that the biggest cause of my problems is "invalid characters" being the "Trademark logo" (I forgot how to type it) and apostrophes and such. I thought you put a fix in for those issues?

I'm not sure if this has been answered as there is no easy way to search the post.

I have everything installed and while the mod is working, it does not pickup a single item I have in a category with no other products. It does catch all of the items I have in other categories though. Those other categories have multiple products in them, the one I'm having problems with does not.

Anybody else experience this?

fvb:

I have had a cron job running for a few months now, and it worked great

GET 'http://www.shoepeddlers.com/googlefroogle.php?feed=yes&upload=yes&type=products' > /dev/null 2>&1

The file created was shoepeddlers_products.xml and all product were listed

My hosting company switched to a new server
the difference is
apache 2 as compared to 1.3.9
more cpus
more ram
more speed and better security
and a new version of cpanel

now the cron would not run untill I changed it to use “WGET”
now it runs, but it saves the files to shoepeddlers_.xml and no products are listed
the contence of the files is just this

<?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" xmlns:g="<http://base.google.com/ns/1.0>"> <channel> <title>Shoe Peddlers</title> <link>http://www.shoepeddlers.com</link> <description>shoepeddlers</description>

I’ve been work with the hosting company, but we can’t seem to figure it out.

Any suggestions please:frusty::frusty:

Following up on this cron job problem: I have the same thing with the output file in /feed. It just creates myfilename_.xml instead myfilename_products.xml exactly as described in the quote. Now I checked my google base account and the file lists as successfully uploaded by the cron at the specified time and products were inserted. Strange, but somehow it still works even if the local file does not get created the way I expected, the upload of ALL products worked.

wget works for my cpanel. File in /feed does not show correctly. Upload and insertion of all products in google base works. Don't know why this is. Anybody see the same happening?

I am getting an error when I try to create my google feed:

Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2008/09/18 11:31:02
Feed file - /home/content/t/e/s/test1/html/shop/feed/google-base.txt
Processing: Feed - Yes, Upload - No
Froogle File Complete In 54.109161 Seconds 205 Records
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = 'bd01680209009a0f7976dcabb24ec82b']

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

If I run the SQL query manually, the count is 0. Not really sure where to go next to clear out whatever it thinks is going on. This all started because of a database timeout about a week ago when my site was running painfully slowly.