From: <cb...@us...> - 2005-05-31 20:10:44
|
Update of /cvsroot/tikiwiki/tiki/lib/search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10750 Modified Files: Tag: BRANCH-1-9 searchlib.php Log Message: Add backticks around galName so postgres gets it properly quoted. Index: searchlib.php =================================================================== RCS file: /cvsroot/tikiwiki/tiki/lib/search/searchlib.php,v retrieving revision 1.19.2.8 retrieving revision 1.19.2.9 diff -u -d -r1.19.2.8 -r1.19.2.9 --- searchlib.php 27 May 2005 13:42:51 -0000 1.19.2.8 +++ searchlib.php 31 May 2005 20:10:34 -0000 1.19.2.9 @@ -1042,7 +1042,7 @@ global $user; if ($feature_file_galleries == 'y' && count($words) >0) { $query="select s.`page`, s.`location`, s.`last_update`, s.`count`, f.`search_data`, - f.`data`,f.`lastModif`, f.`filename`, f.`downloads`, f.`description`, f.`name`, g.`name` as galName from + f.`data`,f.`lastModif`, f.`filename`, f.`downloads`, f.`description`, f.`name`, g.`name` as `galName` from `tiki_searchindex` s, `tiki_files` f, `tiki_file_galleries` g where `searchword` in (".implode(',',array_fill(0,count($words),'?')).") and s.`location`='file' and f.`galleryId`= g.`galleryId` and |