summaryrefslogtreecommitdiffstats
path: root/frontends/php/include/items.inc.php
diff options
context:
space:
mode:
authorartem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-06-12 08:55:06 +0000
committerartem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-06-12 08:55:06 +0000
commit5240ec718c5c9a6befee0c421e224396fc7b747a (patch)
treeeb006bf74560b61e82a37e60c46b8448a8c8a511 /frontends/php/include/items.inc.php
parent412fd1bca83c5bb8229a9bfa3b9a77a5573db3ba (diff)
downloadzabbix-5240ec718c5c9a6befee0c421e224396fc7b747a.tar.gz
zabbix-5240ec718c5c9a6befee0c421e224396fc7b747a.tar.xz
zabbix-5240ec718c5c9a6befee0c421e224396fc7b747a.zip
- [DEV-137] fixed SQL error for PGSQL8.3 (Artem)
- [DEV-137] fixed Apache Auth loop problem (Artem) git-svn-id: svn://svn.zabbix.com/trunk@5759 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/items.inc.php')
-rw-r--r--frontends/php/include/items.inc.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/frontends/php/include/items.inc.php b/frontends/php/include/items.inc.php
index 4334d7d4..5ebc692a 100644
--- a/frontends/php/include/items.inc.php
+++ b/frontends/php/include/items.inc.php
@@ -800,7 +800,7 @@
$result = delete_history_by_itemid($itemid, 1 /* use housekeeper */);
if(!$result) return $result;
- $result &= DBexecute('delete from screens_items where resourceid='.$itemid.' and resourcetype in ('.
+ $result &= DBexecute('DELETE FROM screens_items WHERE resourceid='.$itemid.' AND resourcetype IN ('.
(implode(',',array(
SCREEN_RESOURCE_SIMPLE_GRAPH,
SCREEN_RESOURCE_PLAIN_TEXT)
@@ -809,7 +809,7 @@
$result &= DBexecute('delete from items_applications where itemid='.$itemid);
$result &= DBexecute('delete from items where itemid='.$itemid);
- $result &= DBexecute('DELETE FROM profiles WHERE idx="web.favorite.graphids" AND source="itemid" AND value='.$itemid);
+ $result &= DBexecute("DELETE FROM profiles WHERE idx='web.favorite.graphids' AND source='itemid' AND value='$itemid'");
if($result){
info("Item '".$host["host"].":".$item["key_"]."' deleted");