aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/nodetree_tree_sql.erl4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/nodetree_tree_sql.erl b/src/nodetree_tree_sql.erl
index fb5141bf3..edfdbc1d5 100644
--- a/src/nodetree_tree_sql.erl
+++ b/src/nodetree_tree_sql.erl
@@ -202,7 +202,7 @@ get_subnodes_tree(Host, Node) ->
?SQL("select @(node)s, @(parent)s, @(type)s, @(nodeid)d from "
"pubsub_node where host=%(H)s"
" and node like %(N)s escape '^'"
- " and type='hometree'"))
+ " and \"type\"='hometree'"))
of
{selected, RItems} ->
[raw_to_node(Host, Item) || Item <- RItems];
@@ -264,7 +264,7 @@ delete_node(Host, Node) ->
catch ejabberd_sql:sql_query_t(
?SQL("delete from pubsub_node where host=%(H)s"
" and (node=%(Node)s"
- " or (type = 'hometree' and node like %(N)s escape '^'))")),
+ " or (\"type\"='hometree' and node like %(N)s escape '^'))")),
Removed.
%% helpers