Google Base Feeder Support Thread [OLD]

[taf]

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);

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

[mafiasam]

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....

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

[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.

[numinix]

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

[mafiasam]

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?

[mafiasam]

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?

[numinix]

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...