Google analytics SQL install error

[miles]

Here's what I did

2) variant_include install method:

1. UPLOAD:
/includes/templates/YOUR_TEMPLATE/common/tpl_footer_googleanalytics.php

2. EDIT:
tpl_footer.php or tpl_main_page.php or any other that you want.
(for example: copy template_default/common/tpl_footer.php then edit and save in YOUR_TEMPLATE/common directory).
To any place that you want add
<?php include($template->get_template_dir('tpl_footer_googleanalytics.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_footer_googleanalytics.php'); ?>
For ex. to the bottom of the tpl_footer.php.

3. Go to Admin->Tools->Install SQL Patches and install googleanalytics.sql;

4. Go to Admin>Configuration>Google Analytics and setting up your Google Analytics configuration;

5. Go to your Google Analytics Settings -> Edit Settings -> Edit Main Website Profile -> E-Commerce Website : Yes

The problem is on the third step. I couldn't install googleanalytics.sql file. 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_A' 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.

Help me please!!

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

[a_berezin]

miles
Copying SQL code from googleanalytics.sql file (using a text editor) and paste into form in your shops admin at Tools > Install SQL patches (copy & paste, don't upload).

http://www.zen-cart.com/forum/showthread.php?t=58654

[miles]

I just copy & paste the googleanalytics.sql file code into admin and guess what, IT WORKS finally..!! thanks to both of you (TheOracle & a_berezin) for your supports.