aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authorFriendika <info@friendika.com>2011-09-29 21:56:44 -0700
committerFriendika <info@friendika.com>2011-09-29 21:56:44 -0700
commit52557b011d2c05e83b1df91d2d766317dd2c5223 (patch)
treed307ee9f06d5247b5fc1527b97edc37173a47628 /include
parent097c1f8da774c82f441f370f391f93acc2025ccd (diff)
downloadvolse-hubzilla-52557b011d2c05e83b1df91d2d766317dd2c5223.tar.gz
volse-hubzilla-52557b011d2c05e83b1df91d2d766317dd2c5223.tar.bz2
volse-hubzilla-52557b011d2c05e83b1df91d2d766317dd2c5223.zip
possible sql errors
Diffstat (limited to 'include')
-rw-r--r--include/delivery.php2
-rw-r--r--include/notifier.php2
2 files changed, 2 insertions, 2 deletions
diff --git a/include/delivery.php b/include/delivery.php
index 06cc1f679..3ab820b62 100644
--- a/include/delivery.php
+++ b/include/delivery.php
@@ -72,7 +72,7 @@ function delivery_run($argv, $argc){
$normal_mode = false;
$expire = true;
$items = q("SELECT * FROM `item` WHERE `uid` = %d AND `wall` = 1
- AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP - INTERVAL 30 MINUTE",
+ AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP() - INTERVAL 30 MINUTE",
intval($item_id)
);
$uid = $item_id;
diff --git a/include/notifier.php b/include/notifier.php
index 748d15743..864fa517b 100644
--- a/include/notifier.php
+++ b/include/notifier.php
@@ -86,7 +86,7 @@ function notifier_run($argv, $argc){
$normal_mode = false;
$expire = true;
$items = q("SELECT * FROM `item` WHERE `uid` = %d AND `wall` = 1
- AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP - INTERVAL 10 MINUTE",
+ AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP() - INTERVAL 10 MINUTE",
intval($item_id)
);
$uid = $item_id;