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)