Fossil SCM

Fix faulty SQL in the "db_unset()" routine. Ticket [31bd22c31fcc]

drh 2009-08-15 16:50 trunk
Commit 74f7f6e6ad30a59a508d65db1045e6b8581177c0
1 file changed +2 -2
+2 -2
--- src/db.c
+++ src/db.c
@@ -1227,14 +1227,14 @@
12271227
}
12281228
void db_unset(const char *zName, int globalFlag){
12291229
db_begin_transaction();
12301230
if( globalFlag ){
12311231
db_swap_connections();
1232
- db_multi_exec("DELETE INTO global_config WHERE name=%Q", zName);
1232
+ db_multi_exec("DELETE FROM global_config WHERE name=%Q", zName);
12331233
db_swap_connections();
12341234
}else{
1235
- db_multi_exec("DELETE INTO config WHERE name=%Q", zName);
1235
+ db_multi_exec("DELETE FROM config WHERE name=%Q", zName);
12361236
}
12371237
if( globalFlag && g.repositoryOpen ){
12381238
db_multi_exec("DELETE FROM config WHERE name=%Q", zName);
12391239
}
12401240
db_end_transaction(0);
12411241
--- src/db.c
+++ src/db.c
@@ -1227,14 +1227,14 @@
1227 }
1228 void db_unset(const char *zName, int globalFlag){
1229 db_begin_transaction();
1230 if( globalFlag ){
1231 db_swap_connections();
1232 db_multi_exec("DELETE INTO global_config WHERE name=%Q", zName);
1233 db_swap_connections();
1234 }else{
1235 db_multi_exec("DELETE INTO config WHERE name=%Q", zName);
1236 }
1237 if( globalFlag && g.repositoryOpen ){
1238 db_multi_exec("DELETE FROM config WHERE name=%Q", zName);
1239 }
1240 db_end_transaction(0);
1241
--- src/db.c
+++ src/db.c
@@ -1227,14 +1227,14 @@
1227 }
1228 void db_unset(const char *zName, int globalFlag){
1229 db_begin_transaction();
1230 if( globalFlag ){
1231 db_swap_connections();
1232 db_multi_exec("DELETE FROM global_config WHERE name=%Q", zName);
1233 db_swap_connections();
1234 }else{
1235 db_multi_exec("DELETE FROM config WHERE name=%Q", zName);
1236 }
1237 if( globalFlag && g.repositoryOpen ){
1238 db_multi_exec("DELETE FROM config WHERE name=%Q", zName);
1239 }
1240 db_end_transaction(0);
1241

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button