1 files changed, 15 insertions, 7 deletions

diff --git a/inc/poche/Database.class.php b/inc/poche/Database.class.php
index 28d4a232..7ec1602d 100755
--- a/inc/poche/Database.class.php
+++ b/inc/poche/Database.class.php
@@ -266,10 +266,10 @@ class Database {
     {
         $entries = $this->retrieveAll($userID);
         if ($entries) {
-            foreach($entries as $entryid) {
-                $tags = $this->retrieveTagsByEntry($entryid);
+            foreach($entries as $entry) {
+                $tags = $this->retrieveTagsByEntry($entry['id']);
                 foreach($tags as $tag) {
-                    $this->removeTagForEntry($entryid,$tags);
+                    $this->removeTagForEntry($entry['id'], $tags);
                 }
                 $this->deleteById($entryid,$userID);
             }
@@ -454,20 +454,28 @@ class Database {
 
     public function getPreviousArticle($id, $user_id) 
     {
-        $sql = "SELECT id FROM entries WHERE id = (SELECT max(id) FROM entries WHERE id < ? AND is_read=0) AND user_id=? AND is_read=0";
+        $sqlcondition = "is_read=0";
+        if (STORAGE == 'postgres') {
+            $sqlcondition = "is_read=false";
+        }
+        $sql = "SELECT id FROM entries WHERE id = (SELECT max(id) FROM entries WHERE id < ? AND " . $sqlcondition . ") AND user_id=? AND " . $sqlcondition;
         $params = array($id, $user_id);
         $query = $this->executeQuery($sql, $params);
-        $id_entry = $query->fetchAll();
+        $id_entry = ($query) ? $query->fetchAll() : false;
         $id = ($query) ? $id_entry[0][0] : false;
         return $id;
     }
 
     public function getNextArticle($id, $user_id) 
     {
-        $sql = "SELECT id FROM entries WHERE id = (SELECT min(id) FROM entries WHERE id > ? AND is_read=0) AND user_id=? AND is_read=0";
+        $sqlcondition = "is_read=0";
+        if (STORAGE == 'postgres') {
+            $sqlcondition = "is_read=false";
+        }
+        $sql = "SELECT id FROM entries WHERE id = (SELECT min(id) FROM entries WHERE id > ? AND " . $sqlcondition . ") AND user_id=? AND " . $sqlcondition;
         $params = array($id, $user_id);
         $query = $this->executeQuery($sql, $params);
-        $id_entry = $query->fetchAll();
+        $id_entry = ($query) ? $query->fetchAll() : false;
         $id = ($query) ? $id_entry[0][0] : false;
         return $id;
     }