
Originally Posted by
econcepts
Lloyd,
Wow. Great catch. It looks like that file is not in the package you received. I'll have to add that for older upgrades. It appears to have been "dropped" during one of the releases.
Attached you will find the file you need. (I named it ".txt" for the upload, but it should be ".sql" technically). Copy and paste this into your SQL patch section from the admin.
You should run this file 1st, and then after running this, run the subsequent upgrade file (that is included with the package). This will bring you up to speed without removing any previously entered values.
Let me know if you have any questions.
Okay, so I ran the SQL file googleanalytics-UPGRADE.sql and received the following error message:
Code:
1062 Duplicate entry 'GOOGLE_CONVERSION_ACTIVE' for key 2
in:
[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 ('', '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.
Should I now proceed to run the file UPGRADE-FromVersion1-2-1_ONLY.sql, or will something have to be fixed first?
Best Regards, Lloyd Borrett.
Bookmarks