From a6e12d101bfa0aa2e6a93717cc8bb4bacc3aab2a Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Mon, 2 Jul 2007 10:26:03 +0000
Subject: [PATCH] SQLite compatibvility

---
 include/functions_comments.inc.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/include/functions_comments.inc.php b/include/functions_comments.inc.php
index e33bceb..a7a15ab 100644
--- a/include/functions_comments.inc.php
+++ b/include/functions_comments.inc.php
@@ -169,12 +169,12 @@ function serendipity_fetchComments($id, $limit = null, $order = '', $showAll = f
                     co.id AS commentid,
                     co.parent_id AS parent_id
               FROM
-                    {$serendipity['dbPrefix']}comments co
-                    LEFT JOIN {$serendipity['dbPrefix']}entries e ON (co.entry_id = e.id)
+                    {$serendipity['dbPrefix']}comments AS co
+                    LEFT JOIN {$serendipity['dbPrefix']}entries AS e ON (co.entry_id = e.id)
               WHERE co.type LIKE '" . $type . "' AND co.entry_id > 0 $and
               $group
               ORDER BY
-                    " . ($where != '' ? '' : 'co.id') . " " . ($order != '' ? $order : '') . "
+                    " . ($where != '' ? '' : 'co.id') . " " . ($where == '' && $order != '' ? ',' : '') . ($order != '' ? $order : '') . "
                     $limit";
     $comments = serendipity_db_query($query, false, 'assoc');
 
-- 
2.39.5