diff --git a/webui/model/search/message.php b/webui/model/search/message.php index 8399fbe..37f98d0 100644 --- a/webui/model/search/message.php +++ b/webui/model/search/message.php @@ -353,7 +353,7 @@ * If the hashes are the same, then verify by the public key as well */ - $query = $this->db->query("SELECT `start_id`, `stop_id`, `hash_value`, `response_time`, `response_string` FROM " . TABLE_TIMESTAMP . " WHERE start_id <= ? AND stop_id >= ? ORDER BY id", array($id, $id)); + $query = $this->db->query("SELECT `start_id`, `stop_id`, `hash_value`, `response_time`, `response_string` FROM " . TABLE_TIMESTAMP . " WHERE start_id <= ? AND stop_id >= ?", array($id, $id)); if(isset($query->row['start_id']) && isset($query->row['stop_id'])) { @@ -365,7 +365,7 @@ if($computed_hash == '') { - $query2 = $this->db->query("SELECT digest FROM " . TABLE_META . " WHERE id >= ? AND id <= ?", array($query->row['start_id'], $query->row['stop_id'])); + $query2 = $this->db->query("SELECT digest FROM " . TABLE_META . " WHERE id >= ? AND id <= ? ORDER BY id", array($query->row['start_id'], $query->row['stop_id'])); foreach($query2->rows as $q) { $s .= $q['digest'];