Google Base Feeder Support Thread [OLD]

Posted this a few days ago and still no response. Any help would be appreciated. Thanks!

Quote:

---

Originally Posted by phycel

Ok -- I tried to weed my way through this thread to find my answer -- but nothing has worked so far.

I installed this mod on one of my client's sites and it worked perfectly.

Now I have installed it on another client's site - only difference being he has larger quantities and more products/categories. They are hosted with the same company, using the same plans, etc. But when I try to create the product feed xml, the window pops up, says it's done, but nothing happens. I check the feed folder and there is no file there. I made sure the feed folder chmod is 777 and I even tried re-uploading all the files to make sure I didn't miss anything. I also uploaded a php.ini file with the following code:

Code:

---

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

---

So, any thoughts to what I may be doing wrong with this one? I just can't seem to figure out why this install would be different from the others. Everything was done the same.

Thanks in advance for your time. Great Mod!

Rene

---

Quote:

---

Originally Posted by surf7.net

Dear developer of this excellent mod,

Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0

The effected keys are

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Deletion of above keys will effect the proper functionality of Zen Cart.

---

In reply to the email from surf7.net, in another Thread RSS2 Feed Contribution a_berezin posted a fix for this problem it is shown below. Anyone know if this fix will work for google base feeder. I have not tired it. Don't know to much about mysql and databases.

The Possible fix is:

Please execute this sql to restore deleted records:
Code:
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

##############################___

Quote:

---

Originally Posted by sgflowers

i am getting an error from the feed

Error Bad data Line #
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
4

i attached a zip of the feed xml


any ideas?

---

still getting this error any one can help - not sure if it is a configuration issue
when it say line 4 do i have to literally look at line #4 on the code?

Quote:

---

Originally Posted by taf

In reply to the email from surf7.net, in another Thread RSS2 Feed Contribution a_berezin posted a fix for this problem it is shown below. Anyone know if this fix will work for google base feeder. I have not tired it. Don't know to much about mysql and databases.

The Possible fix is:

Please execute this sql to restore deleted records:
Code:
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

##############################___

---

This looks like it might be something that is very important and could cause some serious problems. Are there any Master Zenners out there that might have any insight at all on this?

I removed my base feeder recently and ran the uninstall.sql file included in the package from the download section. I was concerned after seeing this because I do not want to break my store just trying to uninstall a component.

Luckily I did backups of the database but some people may not be so lucky. I am not sure either if it affected anything at all.

Like I said some expert insight is desperately needed regarding the unistall.sql file included with this package.

here is the code from that file....

Code:

---

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Base 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;


#REMOVE #'s to remove UPC/ISBN support:

#ALTER TABLE products DROP COLUMN products_upc;
#ALTER TABLE products DROP COLUMN products_isbn;

---

thanks in advance

mafiasam

okay the reason I uninstalled this contribution in the first place was because it worked once and then just started failing without even throwing errors. It just sat there when I attempted to create the file. Just gave me a blank page.

So I uninstalled and reinstalled. It continues to do the same thing even after I tried every trick in this thread.
1. added a php.ini file - no help
2. added the timeout changes to .htaccess - actually killed the entire site with a server error
3. all the necessary files and directories are chmod to 777.

This contribution just simply does not work at all.

Problem is I need to upload a file to google base because my items have expired.

It seems that there should be another contribution or way to get a file to upload to google since this contribution does not work on everyone's installations.

PLEASE - any advice is appreciated. desperate at this point.

The mod doesn't work with wordpress. You can search that keyword in the thread for a fix.

Quote:

---

Originally Posted by numinix

The mod doesn't work with wordpress. You can search that keyword in the thread for a fix.

---

is there another solution that would work with wordpress?

It seems that Live Product search is not working with WordPress either.

I am so upset about this. Now I have to untangle WordPress from Zen cart.

Or does anyone know if there will be compatibility in the next release?

I'm not a full time programmer and I usually charge for any additional changes to the scripts other than the additions I've made. Most of the scripts have been created/modified for my own website and then I share them with the community. As my external projects to Zen Cart grow, I will be spending less and less time updating these scripts.

I don't have the time right now to find out how the two are conflicting, but you may want to check all of the function names etc. I've never used wordpress...

Quote:

---

Originally Posted by RobM

Seem to be having a few problems.

On Google Base, it shows the kettle as being here: http://www.prideofthefleet.org.uk/su...4v-p-1243.html

When the actual link for the kettle on the site is http://www.prideofthefleet.org.uk/su...olt-p-298.html

As you can see when you click the link that Google Base gives, it takes it to a "Product Not Found" page, even though the Product is in the title, and the breadcrumbs.

It does this for all the products i've added (only 3 so far).

The product hasn't been switched to any different categories so i've no idea what could be causing the difference in links?

Any help appreciated.

---

Still have this original problem...

Also noticed the following:

Say I added some products to Zencart and ran the Google Base uploader, it would add the previously added products.

Then when I add more products and run it, it'l add the ones that it should have added last time.

It's like it's always one step behind?