I am upgrading to the new 1.2.1 on ZenCart 1.3.7. Simple Google Analytics has been installed and working since December, but I am getting an error when I run the upgrade sql patch for the new one. These are the steps I did:
1) uploaded google_analytics.php to:
includes/templates/cherry_zen/google_analytics folder.
2) opened includes/modules/pages/checkout_success/on_load_main.js and determined "javascript:__utmSetTrans();" was the only line in the file, so I deleted it from the directory.
3) copied the googleanalytics-UPGRADE.sql contents into the SQL query executer and hit "SEND"
4) got the following page:
1062 Duplicate entry 'GOOGLE_CONVERSION_ACTIVE' for key 2
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 ('', 'Activate Conversion Tracking', 'GOOGLE_CONVERSION_ACTIVE', 'No', 'This element enables you turn on or off Google Conversion Tracking.
Please Note: Conversion tracking is used to track the effectiveness of Google AdWords paid search campaigns. If you are not running any paid search campaigns, then you should leave this set to "No".
If you are running Google AdWords (paid search) campaigns, then turning this on will place the proper conversion tracking code on your checkout success page and enable you to start tracking conversions.
Turning this on requires you to enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" number shown in the next section.
For more hints and tips on how to use Google Analytics to increase sales from your store, visit ZenCartOptimization.com
Do you want to turn on Google AdWords Conversion Tracking?
', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), ');]
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.
I've double-checked the location of the files and tried running the query again with the same results. The only way to exit this page is the "back" button or close the page.
website: flagstore.flagsbay.com
Bookmarks