Google Base Feeder Support Thread [OLD]

[ARRSE]

Just to add my thanks to numinix for the regular updates to this excellent module - I've just upgraded to 1.5.1 without any problems.

[numinix]

Well I'm not having a problem with FTP portion of the module. Its when I install the sql portion of the newest version 1.5.1. My site will not display at all and I get the errors right of the batt.

I will send you a screen shot.

There shouldn't be any SQL errors... Are you copying and pasting? It's the exact same SQL file from previous versions...

[batteryman]

Yes I am copy and pasting. I began to think on how I set the whole mod up and I did an upgrade to 1.4.10 from 1.33a originally which worked grreat but then I tried to upgrade to 1.5.1 and that where I started to get the problems.

So I went through all of my database removing all the old tables and then I went through my site manually to remove all the old files, after backing up of course.

Then I reinstalled the mod from a fresh start reading the instrutions carefully. I have no website display problems anymore however I cant actually use the mod either. I get BOX_GOOGLEFROOGLE under the Tools menu instead of Google Base Feeder and when I click on it i get this error:

http://www.batteriesinaflash.com/adm...GLEFROOGLE.php

"The requested URL /admin/FILENAME_GOOGLEFROOGLE.php was not found on this server.

 
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

Click on it and you will get the same error i get. So i went to the directory to see if the file is there and it is. The permissions are set to 644.

Doesn't make sense to me. Argg...

[numinix]

To uninstall all you had to do was run the uninstall.sql for that version which you are removing. You also can't just upgrade from 1.33 all the way to 1.4.10 without running a lot of sql files. It's better to run the uninstall.sql and then just overwrite your files.

This is what you should do now, run the uninstall.sql for the latest version and if there is a configuration settings profile for "Google Froogle Feeder" you will also need to run one of the older uninstall.sql files that removes "Google Froogle Feeder".

Next, reupload the entire file package except for the files that are for the UPC/ISBN module (in the next release I won't be including these files by default). Then run the googlefroogle.sql file and it should all be installed correctly. The reason you are getting BOX_GOOGLEFROOGLE is because you are missing one of the admin files which defines this constant.

Good luck.

[BlessIsaacola]

The errors should be fixed in version 1.5.0.

Thank you for all your hard work on this. I have one quick questions for you:

Can you please explain how to utilize the RSS Feed that is now supported. I did not see anything in the readme file that explains how to use this.

Thanks!

[batteryman]

Hello,

I tried all of your suggestion last night and they didnt seem wot work. Even after I use the uninstall the box_googlefroogle menu option is still in the tools menu.

Whats weird is I installed the isbn and upc support because everything has a common upc but when I try to uninstall it I get an error code:

1054 Unknown column 'p.products_upc' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_upc, p.products_isbn, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = '1413' and p.products_id = pd.products_id and pd.language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Which is probally why you are not adding in the next version as a default.. lol

Well I am going to try it again and see what happens. I will document my steps so you can see if there is an error in what I am doing.

thank you for all your help, I really do appreciate it. I know your mod works perfectly just a small problem with my setup perhaps. we will get it fixed.

[TJR Stores]

Hi.

I firstly would like to say congratulations to all those that had no issues with installing this mod.

Also well done to the mod developer, its a great mod.

Unfortunatly i was very unsuccessful in installing this mod, Its 18:40 here in the UK and I have been trying to do this mod since 15:00 today!

If anyone can help me install the mod, well basically install it for me, as I have had to uninstall it and restore my backup.

I am running v1.3.7 and the mod is v1.5.1

It just did not work at all.

Nevermind spending hours trying to find the .xml file, when I had to infact create it myself, only to find it just does not work.

Please do not ask me all sorts of technical questions as I will not be able to answer them. I am a novice and even got help from a programmer and her followed the instrutions to the letter and could not get it to work.

Please I need serious help with this mod as I am not sitting here all day just uplaoding to google froogle, base, MSN live etc etc.

Thanks in advance guys and gals.

[BlessIsaacola]

Hi.

I firstly would like to say congratulations to all those that had no issues with installing this mod.

Also well done to the mod developer, its a great mod.

Unfortunatly i was very unsuccessful in installing this mod, Its 18:40 here in the UK and I have been trying to do this mod since 15:00 today!

If anyone can help me install the mod, well basically install it for me, as I have had to uninstall it and restore my backup.

I am running v1.3.7 and the mod is v1.5.1

It just did not work at all.

Nevermind spending hours trying to find the .xml file, when I had to infact create it myself, only to find it just does not work.

Please do not ask me all sorts of technical questions as I will not be able to answer them. I am a novice and even got help from a programmer and her followed the instrutions to the letter and could not get it to work.

Please I need serious help with this mod as I am not sitting here all day just uplaoding to google froogle, base, MSN live etc etc.

Thanks in advance guys and gals.

When you say it doesn't work, did you get any error messages?
Is the feed folder as well as the xml set to read/write/execute?
Have you use any previous version of this mod?

[numinix]

Thank you for all your hard work on this. I have one quick questions for you:

Can you please explain how to utilize the RSS Feed that is now supported. I did not see anything in the readme file that explains how to use this.

Thanks!

You upload it to Google Base just like the tabbed file. But make sure you've defined it.

You are right though, it does create an RSS feed. However, because it contains g:mpn, it doesn't validate but will still display the title and descriptions in most readers. In order to use it as an RSS feed in general, I'd have to change it to display the products in order from newest to oldest and create an XLS file to display the prices, images, etc. Rather than change this mod, I will just be updating the RSS 2.0 v1.5.7 to v1.5.8 in the next month with added Admin support. v1.5.7 is not currently publicly available and doesn't have any documentation.

Hello,

I tried all of your suggestion last night and they didnt seem wot work. Even after I use the uninstall the box_googlefroogle menu option is still in the tools menu.

Whats weird is I installed the isbn and upc support because everything has a common upc but when I try to uninstall it I get an error code:



Which is probally why you are not adding in the next version as a default.. lol

Well I am going to try it again and see what happens. I will document my steps so you can see if there is an error in what I am doing.

thank you for all your help, I really do appreciate it. I know your mod works perfectly just a small problem with my setup perhaps. we will get it fixed.

Wait for v1.5.2 which will avoid the SQL errors for those not using the UPC/ISBN mod and contains all the updates that I've pasted in the thread as well.

[batteryman]

Hi.

Unfortunatly i was very unsuccessful in installing this mod, Its 18:40 here in the UK and I have been trying to do this mod since 15:00 today!

If anyone can help me install the mod, well basically install it for me, as I have had to uninstall it and restore my backup.

TJR,

I have installed and reinstalled the new version more time than i can count so I consider myself a self proclaimed expert. I can help you however I need more details on what problems you are having and how you installed it.

Here is a really generally summary of what you should do. First of all did you upgrade or start from a fresh install?? I had tried both way. If you started fresh do not install any of the previous sql updates only the current sql for 1.5.1. So what you need to do is run the uninstall sql file and if this was your first tiime install the mod if not run the previous versions uninstall files as well

Then reinstall the googlefroogle feeder files files to your server and then go to your store admin>tools>install sql patches and copy and paste the sql install file into the big open box and then hit send. should take care of your problem

I also had to create a blamk xml file in the folder FEED and upload it to my server. be sure to name the file the same as the file name specified in your configuration in admin>configuration>Google Base Feeder Configuration

hope this helps, numinix spent hours helping me so hopefully I got it right.