Totally Zenned
- Join Date:
- Apr 2007
- Location:
- Vancouver, Canada
- Posts:
- 1,567
- Plugin Contributions:
- 58
Google Base Feeder Support Thread [OLD]
If you run the SQL script it wil simply overwrite all of your stored configurations which isn't that big of a deal.
If no SQL upgrade is required since the last release, I normally remove the update files. But, perhaps I will include them all in the next release which HOPEFULLY will not happen for some time. However, I did notice one problem:
WARNING when uninstalling your copy of the Google Base Feeder, do NOT run these two lines in your uninstall.sql unless you want to completely remove the stored UPC and ISBN information from your database:
ALTER TABLE products DROP COLUMN products_upc;
ALTER TABLE products DROP COLUMN products_isbn;
The uninstall.sql should look like this:
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
I will remove this in the next release and make a note to only use these if you want to completely remove the GBF and never use it again. In most cases people are just uninstalling to reinstall and having to reinput all of the UPC information can be very tiresome.
