Leah
05-31-2003, 08:06 PM
I need to uninstall the canned text hack because I've done something that causes a lot of errors and can't find out what it is. So I want to uninstall and start from scratch, but I dont know what queries to run to undo these:
Creating Settings...
Getting current highest + 1 displayorder for settings...
query_first: SELECT MAX(settinggroupid) + 1 AS newdisplayorder FROM setting
Creating settings group...
query: INSERT INTO settinggroup (title, displayorder) VALUES ("Canned Text", 44)
Getting newly created settinggroupid...
Writing script to create individual settings...
Caching highest settingid + 1...
query_first: SELECT MAX(settingid) + 1 AS sidplusone FROM setting
Creating setting "Maximum allowed canned text items"...
query: INSERT INTO setting (settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES (45,
"Maximum allowed canned text items",
"ctmax",
"5",
"The maximum allowed number of unique canned text responses users can save. Set to 0 to disable the use of canned text.",
"",
0)
Can anyone help me?
Creating Settings...
Getting current highest + 1 displayorder for settings...
query_first: SELECT MAX(settinggroupid) + 1 AS newdisplayorder FROM setting
Creating settings group...
query: INSERT INTO settinggroup (title, displayorder) VALUES ("Canned Text", 44)
Getting newly created settinggroupid...
Writing script to create individual settings...
Caching highest settingid + 1...
query_first: SELECT MAX(settingid) + 1 AS sidplusone FROM setting
Creating setting "Maximum allowed canned text items"...
query: INSERT INTO setting (settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES (45,
"Maximum allowed canned text items",
"ctmax",
"5",
"The maximum allowed number of unique canned text responses users can save. Set to 0 to disable the use of canned text.",
"",
0)
Can anyone help me?