Simple Google Analytics - Support

[shrimp-gumbo-mmmhhh]

For ecommerce- some of my orders don't have the items or amounts in them... some are Paypal and some are Credit Card (authorizenet_aim). Any idea why it is working sometimes and not others?

Thanks,

Shrimp-Gumbo

[mrblaq]

Has anyone covered the fact that the installation sql deletes important configuration data related to attributes and breaks zen-cart?

I had to run these SQL commands to fix my zen-cart install after installing this analytics module.

INSERT INTO `configuration` VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
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(');

[keylesslocks]

Has anyone covered the fact that the installation sql deletes important configuration data related to attributes and breaks zen-cart?

I had to run these SQL commands to fix my zen-cart install after installing this analytics module.

INSERT INTO `configuration` VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
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 just installed this mod in my 1.3.8 do I have to run this code so my cart won't break?

[mrblaq]

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

[keylesslocks]

how can I test if I need to run some other code that this deleted or replaced? how do I know?

[mrblaq]

First, run this query

SELECT configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Analytics Configuration';

If no row is returned, just delete the two "DELETE" lines from the beginning of googleanalytics.sql:

DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

Otherwise, if it does return a number, you'll then need to run the following queries to see what may be deleted. Replace <number> with what was returned above

SELECT * FROM configuration WHERE configuration_group_id = <number>;
SELECT * FROM configuration_group WHERE configuration_group_id = <number>;

If any rows are returned by those two queries, you'll need to back up those lines before running the googleanalytics.sql script.

[shrimp-gumbo-mmmhhh]

Hello,

It appears that if someone purchases 2 items that have the same SKU and model number but different attributes then google is ignoring the second one and only reporting one instead of two. Would it be very easy to add attributes to the checkout_success product information?

Thank you!

Shrimp Gumbo

[keylesslocks]

First, run this query

SELECT configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Analytics Configuration';

If no row is returned, just delete the two "DELETE" lines from the beginning of googleanalytics.sql:

DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

Otherwise, if it does return a number, you'll then need to run the following queries to see what may be deleted. Replace <number> with what was returned above

SELECT * FROM configuration WHERE configuration_group_id = <number>;
SELECT * FROM configuration_group WHERE configuration_group_id = <number>;

If any rows are returned by those two queries, you'll need to back up those lines before running the googleanalytics.sql script.

I ran the first query and got this:
SQL query:

SELECT configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Google Analytics Configuration'
LIMIT 0 , 30
MySQL said:
#1146 - Table 'midwest_mydb.configuration_group' doesn't exist



any suggestions?

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

[keylesslocks]

will this work for 1.3.8, we have it on our 1.3.7 and it works fine.... thanks