Author: ralfbecker
Date: Wed Apr 27 10:30:46 2016
New Revision: 55873
URL: http://svn.stylite.de/viewvc/egroupware?rev=55873&view=rev
Log:
* Wiki/PostgreSQL: fix SQL error while searching
Modified:
branches/14.2/wiki/inc/class.wiki_so.inc.php
Modified: branches/14.2/wiki/inc/class.wiki_so.inc.php
URL: http://svn.stylite.de/viewvc/egroupware/branches/14.2/wiki/inc/class.wiki_so.inc.php?rev=55873&r1=55872&r2=55873&view=diff
==============================================================================
--- branches/14.2/wiki/inc/class.wiki_so.inc.php (original)
+++ branches/14.2/wiki/inc/class.wiki_so.inc.php Wed Apr 27 10:30:46 2016
@@ -505,7 +505,7 @@
" FROM $this->PgTbl AS t1, (select wiki_id,wiki_lang,wiki_name, max(wiki_version) as wiki_version from $this->PgTbl GROUP BY wiki_id, wiki_lang, wiki_name) AS t2".
" WHERE t1.wiki_name=t2.wiki_name AND t1.wiki_lang=t2.wiki_lang AND t1.wiki_id=$this->wiki_id AND t2.wiki_id=$this->wiki_id".
" AND ".$sowikipage->acl_filter(true,false,'t1'). // only include pages we are allowed to read!
- " GROUP BY t1.wiki_name,t1.wiki_lang,t1.wiki_version,t1.wiki_title,t1.wiki_body".
+ " GROUP BY t1.wiki_name,t1.wiki_lang,t1.wiki_version,t1.wiki_title,t1.wiki_body,t1.wiki_comment".
" HAVING t1.wiki_version=MAX(t2.wiki_version) AND (";
$search_in = $search_in ? explode(',',$_search_in) : array('t1.wiki_name','t1.wiki_title','t1.wiki_body','t1.wiki_comment');
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.