Google Base Feeder Support Thread [OLD]

OK

I ran the uninstall.sql It executed properly. Install.sql I don't see. I ran the googlefroogle.sql but I get errors.

Error : #1062 - Duplicate entry 'GOOGLE_FROOGLE_USERNAME' for key 2

Thanks for helping!!!

Tom

You must have multiple installs of the Google Base Feeder.

I suggest running the uninstall.sql a couple of times until you don't see GOOGLE BASE FEEDER in the configuration menu.

I do not have FREE SHIPPER! installed because I also sell products.

Here is a screenshot of the settings:

OK I ran it until there were no records affected.

But I found a problem ...I think...maybe not the problem.

I have two more Froogle type configuration groups in the data base.

ID 33 Froogle Configuration
and
ID 34 Google Froogle Configuration

Both of these have associated records in the configuration table.

Tom

you were using a very old version that has a different name. You'll have to run the uninstall.sql from the version u were using, most likely 1.3.3

numinix:

you were using a very old version that has a different name. You'll have to run the uninstall.sql from the version u were using, most likely 1.3.3

Can I just delete the entries from table configuration_group and related entries from table configuration?

As I don't have the old install files. Here's a lesson for everyone! Keep all of the install files, I will going forward.

Thanks Again for your Help!!
Tom

Go to the download section of the Zen Cart website and download the second to last version in the list. Run the uninstall.sql provided with that version until all of the Google FROOGLE Configuration settings are gone.

Once that is done you should be free to install fresh!

Or just execute this:

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

Hi there,

When I try and upload my products I get the following log and I'm confused because it says it's sucessful to start with and then I get upload failed errors....

if i connect to uploads.google.com through an FTP client the file does not exist, but I am able to upload the store_products.xml file manually through the FTP client.

Google Base Feeder v.1.6.4 08.11.2007 00:15:59 started 2007/11/09 11:43:34
Feed file - D:/inetpub/vhosts/xxxxxx.com/httpdocs/store/feed/store_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Uploaded Successfully
-r--r----- 1 ftp root 56854 Nov 9 09:48 store_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp root 56854 Nov 9 09:48 store_products.xml

(this message occurs 37 times)
Warning: ftp_put():store_products.xml: Permission denied on server. (Overwrite) in D:\inetpub\vhosts\xxxxxxxx.com\httpdocs\store\googlefroogle.php on line 546
First attempt (passive mode off): Upload Failed

Fatal error: Maximum execution time of 30 seconds exceeded in D:\inetpub\vhosts\xxxxxxxx.com\httpdocs\store\googlefroogle.php on line 548

It is uploading properly, I just messed around with the FTP function in the latest release to try and solve some people's issues. I need to use an AND statement instead of an OR. I'll post a fix today.

Can you try this file:

Would this fix also cure uploads? When I try to upload to googlebase, the popup window comes up and just times out with a page not found. Any ideas? Thanks by the way for a nice mod!

Thanks numinix!

I got it to work. I modified your sql, a little and deleted those extra records and it allowed me to exec the googlefroogle.sql file with no errors. I still have to upload my feed and see if it works.

Great job!!

Thanks
Tom

bhunted:

Would this fix also cure uploads? When I try to upload to googlebase, the popup window comes up and just times out with a page not found. Any ideas? Thanks by the way for a nice mod!

If you can't upload then the issue is to do with restrictions from your host not allowing ftp functions from your installed scripts. I would confidently say that no FTP script will work for you. You can try by downloading a generic FTP script in php and see if you can execute it to send a file to google base.

I tried the 1.6.5 patch and I'm not getting any error messages anymore - just the successful one now.

After uploading, should I be able to see the file if I connect to uploads.google.com via an FTP client because right now I don't see it?

Thanks

This is a great mod!

jbrit:

I tried the 1.6.5 patch and I'm not getting any error messages anymore - just the successful one now.

After uploading, should I be able to see the file if I connect to uploads.google.com via an FTP client because right now I don't see it?

Thanks

This is a great mod!

i also updated the googlefroogle.php to 1.6.5 but i am having worse results than before

i went from xml error on google base to it timing out in both ie & firefox when the script is running
it doesn't create the xml file properly

any ideas?

also it creates the file as "secret_garden.xml_.xml" but in the configuration i have Output File Name = secret_garden.xml where is the xtra _.xml coming from?

sgflowers:

i also updated the googlefroogle.php to 1.6.5 but i am having worse results than before

i went from xml error on google base to it timing out in both ie & firefox when the script is running
it doesn't create the xml file properly

any ideas?

also it creates the file as "secret_garden.xml_.xml" but in the configuration i have Output File Name = secret_garden.xml where is the xtra _.xml coming from?

hmm, why would your configuration settings have changed? All you had to do was overwrite the files. Anyways, it says to just use a word like "domain." So, in your case just put secret_garden. Then it should create a file called secret_garden_products.xml.

This upgrade made no changes to the code other than to the FTP so there is no reason for it to timeout if the previous version worked for you...

installed the Google Base Feeder 1.5.3 into Zen Cart 1.3.7.1 with SEO URLs and Easy Populate as addons. First copied all the files and directories, set dir feed to 777, then did all the sql updates update_1_4_3.sql, update_1_4_9.sql, update_1_5_0.sql, update_1_5_2.sql, update_1_5_3.sql and then did the googlefroogle.sql all via copy and paste. went into Google Base Feeder config set the user / pass, store URL. Then went to execute the Google Base Feeder in the TOOLS menu and all I get is this: TEXT_GOOGLE_FROOGLE_STARTED
TEXT_GOOGLE_FROOGLE_FILE_LOCATION/home/bidet/public_html/store/feed/gotbidet.xml
Processing: Feed - No, Upload - No

please help:lookaroun

When I upload my products by Google Base Feeder, all processes was ok, but items doesn't appear at google at all. Can anyone help?

This is what happens when I try to upload to Google Base:

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/11/13 13:55:27

Feed file - /hsphere/local/home/peterdd/XXXXXX.co.uk/feed/tenent_base.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /

Upload failed...

Appears to logon correctly but not sure why it fails.

Would the 1.6.5. patch help here?

Any help appreciated.

You can try, that was the point of v1.6.5 to fix the loops for pasv on and off.