Google analytics SQL install error

[miles]

Anybody know what's the problem here? I can't install google analytics mod.

[TheOracle]

Would it be possible to see that SQL content file in order to assist you with this problem ?

[miles]

Of course, here's the SQL file. Please have a look.

[TheOracle]

What will this version say ?

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;

INSERT INTO configuration_group VALUES (NULL, 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Google Analytics Configuration';

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Enter your Google Analytics account number', @t4, 1, NOW(), NOW(), NULL, NULL),
(NULL, 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'What adress (City/State/Country to correlate the transaction with) use in Analytics transaction?', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'customers\', \'delivery\', \'billing\'))',
(NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Optional partner or store affilation', @t4, 3, NOW(), NOW(), NULL, NULL),
(NULL, 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Using as Product SKU code', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'products_id\', \'products_model\'),');
# ,(NULL, 'Currency', 'GOOGLE_ANALYTICS_CURRENCY', '1', 'Google Analytics currency', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'products_id\', \'products_model\'),') 

[miles]

Google Analytics Integration : version 1.2.2
Zen Cart : version 1.3.5

[TheOracle]

Assuming you did tried my modification above and that this MOD seem to be available for Zen-Cart v1.35, I'd first contact the author of this MOD to see if it's also compatible with the current version of Zen-Cart (v1.37).

[miles]

Ok, now I tried your modification SQL file. And it gives me this error.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customers', 'delivery', 'billing'))', (NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AF' at line 1
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Enter your Google Analytics account number', @t4, 1, NOW(), NOW(), NULL, NULL), (NULL, 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'What adress (City/State/Country to correlate the transaction with) use in Analytics transaction?', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('customers', 'delivery', 'billing'))', (NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Optional partner or store affilation', @t4, 3, NOW(), NOW(), NULL, NULL), (NULL, 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Using as Product SKU code', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('products_id', 'products_model'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[MSport]

Miles, you rock. Wonder why this file isn't included in the download?

Thanks!

Of course, here's the SQL file. Please have a look.

[csimmons83]

I have installed simple Google Analytics v1.2.3 and after working through numerous issues I've hit a brick wall. The last thing I had to do was change the Emty Strings to NULL in the SQL patch like the post above mentioned.

After I corrected that the Simple Google Analytics configuration pane finally shows up and I input my GA tracking code but when I view the source of the pages.

The other thing is that currently I have the code set to ga.js because when i tried out the asynchronous tracking code all the homepage loads completly blank.

I've read that when this happens its usually a PHP error/typo so i went back through the 2 template files I had to modify to verify they were correct. Any input/advice/insite/suggestions you could provide would be most helpful. I've since moved the tracking code back to ga.js but here is what the source of the main page looks like when I set the tracking code to asynchronous:

[SCR]
http://www.zen-cart.com eCommerce" />
<link rel="icon" href="favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />

<base href="http://store.chocolatmoderne.com/" />

<link rel="stylesheet" type="text/css" href="includes/templates/test/css/stylesheet.css" />

<link rel="stylesheet" type="text/css" href="includes/templates/test/css/stylesheet_css_buttons.css" />
<link rel="stylesheet" type="text/css" media="print" href="includes/templates/test/css/print_stylesheet.css" />
<script type="text/javascript" src="includes/modules/pages/product_info/jscript_textarea_counter.js"></script>
<script language="javascript" type="text/javascript"><!--
function popupWindow(url) {
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screen X=150,screenY=150,top=150,left=150')
}
function popupWindowPrice(url) {
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=600,height=400,scree nX=150,screenY=150,top=150,left=150')
}
//--></script>

">
[/SCR]