I'm running 1.3.8a and I had to. I noted that in the GoogleAnalytics.sql file, these commands right at the beginning deleted a bunch of stuff:
First of all, the default install of zen-cart on my system never had a configuration_group_title of 'Google Analytics Configuration' Thus t4 remained set to 0 and then anything in my DB that was configuration_group_id == 0 was deleted.Code:SET @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Google Analytics Configuration'; DELETE FROM configuration WHERE configuration_group_id = @t4; DELETE FROM configuration_group WHERE configuration_group_id = @t4;
This in turn deletes the following configuration keys from my configuration table:
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX
And that's just not right.
I now don't know why the following table row is needed. I just used it on recommendation of Ajeh in this thread. It wasn't deleted by the analyytics install.
I'm 97% certain that none of the modifications or additions I've made to the base zen-cart package have caused this error for me. I'm writing this so you will be able to know how to fix your zen-cart IF this problem arises.Code:INSERT INTO `configuration` VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');
So, in conclusion, you CAN install google analytics just fine. BUT, it will probably mess up your products attributes AND you can fix it by running the query I mentioned earlier.
Thanks,
Dave


Reply With Quote
