Quote Originally Posted by jds580s View Post
This happened to me after installing Simple Google Analytics Mod

What is the proper SQL syntax to re-insert these 3 keys with their default values?

I have my backedup databased and can see the line they appear on, but the line is huge (when viewing with text wrap it's over 1000 lines of code)

I would prefer not to roll back to my previous database backup in it's entirety since multiple orders have been placed since then while I was figuring out what was causing the issues I was experiencing on the site (tracking back the problems to those 3 keys, searched and found this thread)

Any help is much appreciated

The portions of that line of code that seem pertinent to those keys are:
Code:
(364,'Product option type Select','PRODUCTS_OPTIONS_TYPE_SELECT','0','The number representing the Select type of product option.',0,NULL,'2007-10-08 10:56:19','2007-10-08 10:56:19',NULL,NULL)

(370,'Upload prefix','UPLOAD_PREFIX','upload_','Prefix used to differentiate between upload options and other options',0,NULL,'2007-10-08 10:56:19','2007-10-08 10:56:19',NULL,NULL)

(371,'Text prefix','TEXT_PREFIX','txt_','Prefix used to differentiate between text option values and other option values',0,NULL,'2007-10-08 10:56:19','2007-10-08 10:56:19',NULL,NULL)
A few questions.

1) What version of Zen are you running?
2) What other mods do you have installed (and were any others installed around the time you installed Simple GA?)

3) Are you certain the installation of the GA mod caused it?

Out of all the other users in this forum with the mod, there are only two that reported this (1 being you, and the other being surfnet7).

I have been unable to duplicate this on any install of Zen to date.

Let me know the above and we'll see if we can't get to the bottom of what may have caused it.