PDA

View Full Version : Undo queries


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?

filburt1
06-01-2003, 01:26 AM
The queries are listed in the top of the installer, although a better idea would be to get the original problem resolved instead by posting in the hack's support thread.

Leah
06-01-2003, 10:48 AM
The problem is that I don't know which one of the hacks I installed that day that causes the errors. But I think I've successfully uninstalled this one now. Thanks. :)