Simple Google Analytics - Support

[econcepts]

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:

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;

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.

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.

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

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.

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

Here is an important fix that you can use to remedy the situation before you install it. I have been looking into this myself, and came up with the following fix.

In the beginning of your SQL file, alter the lines that look like this:

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;

To read as follows.

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 AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @t4 AND configuration_group_id != 0;

This in effect says "delete the entry for Google Analytics if it is there, otherwise do not delete anything. I applied this to a release (patch) here today and re-uploaded to the zen-cart site.