Google Base Feeder Support Thread [OLD]

[FONT=Verdana]Hi Numinix[/FONT]

[FONT=Verdana]I do have 2 site , on my live site I install the 1.4.2 and it dose look like all is good.[/FONT]
[FONT=Verdana]I am trying to run the upgrade on my demo site before I upgrade my live site, I keep getting errors when I try to upgrade to 1.4.5 .[/FONT]
[FONT=Verdana] Looking at my Live site I could see that the folder of Image are not in same location as on my live site, just wondering if other file also miss place, also in my live store I got 4 files in my feed folder while on your folder it has only 2[/FONT]

[FONT=Verdana]I completely remove it from my site demo before uploading the files, should I run the upgrade sql also? [/FONT]

[FONT=Verdana]Thank you[/FONT]

The only images folder that the GBF uses is in the admin...

The files in the feed are auto generated.

You only need to run the upgrade.sql if you are upgrading from 1.4.4 to 1.4.5. If upgrading more than 0.0.1 versions, then you'll have to download subsequent versions or just run the googlefroogle.sql file to have the config reset to default settings.

Hi Numinix

Thank you for your respond

In regard to the image , it is not in same order on the 1.4.5, not compare to my other ( live store ) 1.4.2 and it dose work well on my live store , and I do have the Google image ion my admin, that’s why I thought maybe other file miss placed.

Any way I run the un install sql and completely remove all files, I will do fresh install and see how it goes ( on my demo site)

I assume I don’t need to run the upgrade SQL when I do it this way

Thank you

It looks like this may have been covered in th other informal thread a few months ago, but it is obvious that I am still missing something. Here is the error that I get when attempting to create a feed......

Any Ideas?

Michael Humphrey
www.iliketobead.com


Froogle Data Feeder v.1.4.5 15.07.2007 18:02 started 2007/07/16 06:29:43
Feed file - /mnt/Target01/327584/XXX/web/content/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
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 ASC' at line 13
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, 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, pc.categories_id, cd.categories_name, c.parent_id FROM
.
.
.
<end snip>

Quote:

---

Originally Posted by numinix

There shouldn't be any existing statements since the installation file uninstalls any existing configuration before installing the columns to the database table.

I'm sorry that I am unable to help you with this further.

---

Ok i just used to upload method, and it say 9 statements executed, but still nothing under config>froogle config

Hi numinix,

I've noticed an error since (I think) I installed version 1.4.4.

When trying to update a product record (via admin) I receive the following error...

Quote:

---

1054 Unknown column 'products_weight_type' in 'field list'
in:
[update zen_products set products_quantity = '0', products_type = '1', products_model = '1234', products_upc = '', products_isbn = '', products_price = '23.9500', products_date_available = null, products_weight = '0', products_weight_type = 'SYSTEM_WEIGHT_UNITS', products_dim_type = 'SYSTEM_DIMENSION_UNITS', products_length = '0', products_width = '0', products_height = '0', products_ready_to_ship = '0', products_status = '0', products_virtual = '0', products_tax_class_id = '1', manufacturers_id = '18', products_quantity_order_min = '1', products_quantity_order_units = '1', products_priced_by_attribute = '0', product_is_free = '0', product_is_call = '0', products_quantity_mixed = '0', product_is_always_free_shipping = '0', products_qty_box_status = '1', products_quantity_order_max = '0', products_sort_order = '0', products_discount_type = '0', products_discount_type_from = '0', products_price_sorter = '14.3880', products_image = 'products/1234.jpg', products_last_modified = now(), master_categories_id = '41' where products_id = '1065']
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.

---

Now, I think this is due to some code for the Canada Post Module, but I've not installed that. I've upgraded to version 1.4.5, but that's not helped. :(

What do you think?

Quote:

---

Now, I think this is due to some code for the Canada Post Module, but I've not installed that. I've upgraded to version 1.4.5, but that's not helped.

---

Replace admin->includes->modules->product->collect_info.php with the one in v1.4.5.

Quote:

---

Originally Posted by teebo

Ok i just used to upload method, and it say 9 statements executed, but still nothing under config>froogle config

---

I'll have to help you in PM since your error is definitely an issue with your site alone.

[FONT=Verdana]Hi Numinix[/FONT]

As I say last night I completely remove the mod , and re installing it now, with same problem as yesterday,

A point abut the image of Google, I am now positive it is misplace, in the folder I download it is under Admin/include/image, where I right click on the missing picture in my admin it directed me to Admin/Images, if I know more I would look to see if other file are miss placed, but I have no idea what to look for,

I do get same errors as ml-humphrey, if you find the answer please let us know, in the mean time I wait for other to come with same issue hopefully some one solve it soon.

I made abut 5 to 6 installation of the 1.4.5 after each time I got same errors, and I did a complete un install and clean up all the files, and I got same errors every time.

No rush on my behalf , I got on my live site the 1.4.2 working perfect.
This is the link of my demo site

www.tiledepot.us/storedemo if you need it

Thank you

hello you guys. I was browsing for how to get a flash banner up on my site and got carried away with the Google base feeder, can you tell me what it does and does it benefit my store? Thank you for all who reply!:D