[geeklog-cvs] geeklog: Fixed SQL error in the search when multi-language suppo...

[geeklog-cvs at lists.geeklog.net]

changeset 7833:e4b0894b8d00
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/e4b0894b8d00
user: Dirk Haun <dirk at haun-online.de>
date: Thu Mar 25 20:00:06 2010 +0100
description:
Fixed SQL error in the search when multi-language support was enabled (bug #0001099)

diffstat:

 plugins/staticpages/functions.inc |  2 +-
 public_html/docs/history          |  2 ++
 2 files changed, 3 insertions(+), 1 deletions(-)

diffs (24 lines):

diff -r f918cdabd25a -r e4b0894b8d00 plugins/staticpages/functions.inc
--- a/plugins/staticpages/functions.inc	Thu Mar 25 14:15:55 2010 -0400
+++ b/plugins/staticpages/functions.inc	Thu Mar 25 20:00:06 2010 +0100
@@ -786,7 +786,7 @@
 
     $sql .= "FROM {$_TABLES['users']} AS u, {$_TABLES['comments']} AS c ";
     $sql .= "LEFT JOIN {$_TABLES['staticpage']} AS s ON ((s.sp_id = c.sid) ";
-    $sql .= COM_getPermSQL('AND',0,2,'s') . COM_getLangSQL('sid','AND','s') . ") ";
+    $sql .= COM_getPermSQL('AND',0,2,'s') . COM_getLangSQL('sp_id','AND','s') . ") ";
     $sql .= "WHERE (u.uid = c.uid) AND (s.draft_flag = 0) AND (s.commentcode >= 0) AND (s.created <= NOW()) ";
 
     if (!empty($author)) {
diff -r f918cdabd25a -r e4b0894b8d00 public_html/docs/history
--- a/public_html/docs/history	Thu Mar 25 14:15:55 2010 -0400
+++ b/public_html/docs/history	Thu Mar 25 20:00:06 2010 +0100
@@ -131,6 +131,8 @@
 
 Static Pages Plugin 1.6.2
 -------------------
+- Fixed SQL error in the search when multi-language support was enabled (bug
+  #0001099) [Dirk]
 - Added What's New Block Support for Static Page comments
   (feature request #0000835) [Tom]
 - Added modified date column. What's New Block Support for Static Page now