
Originally Posted by
surf7.net
Dear developer of this excellent mod,
Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0
The effected keys are
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX
Deletion of above keys will effect the proper functionality of Zen Cart.
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)
Bookmarks