Quote Originally Posted by Larry Hendrick View Post
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
Larry,

since you were running a previous version that already had conversion tracking etc.. in place, you did not need to run the update (doing so should not hurt anything though).

All you had to do was copy the new files to their respective locations, and you should be set.

How are things looking after you do that.

The error you are getting when trying to run the SQL patch simply means that there was already a value in the configuration table which was identical to the one being inserted and you can't have two of the same values within that portion of the table.

Hope that helps.