0000406: Error with "Search in titles only" check on

ID	Project	Category	View Status	Date Submitted	Last Update

0000406	WackoWiki	search	public	2011-12-08 09:23	2011-12-09 15:57

Reporter	taskoma	Assigned To
Priority	normal	Severity	minor	Reproducibility	always
Status	resolved	Resolution	fixed
Product Version	5.0.rc
Target Version	5.0.0	Fixed in Version	5.0.0

Summary	0000406: Error with "Search in titles only" check on
Description	actions/search.php : 80 current situation: "ORDER BY supertag". "LIMIT {$pagination['offset']}, $limit"); need: "ORDER BY supertag ". "LIMIT {$pagination['offset']}, $limit");
Steps To Reproduce	1) Go hear http://wackowiki.sourceforge.net/doc/Search check on "Search in titles only" and try search 2) Result: page with text: "Query failed: ============================== SELECT page_id, tag, comment_on_id FROM ww5_page WHERE lower(tag) LIKE binary lower('%Ëìô%') ORDER BY supertagLIMIT 0, 50 ============================== Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0, 50' at line 1"
Tags	No tags attached.

Date Modified	Username	Field	Change
2011-12-08 09:23	taskoma	New Issue
2011-12-09 15:53	administrator	Note Added: 0000829
2011-12-09 15:57	administrator	Status	new => resolved
2011-12-09 15:57	administrator	Resolution	open => fixed
2011-12-09 15:57	administrator	Fixed in Version	=> 5.0.0
2011-12-09 15:57	administrator	Target Version	=> 5.0.0
2011-12-09 15:57	administrator	Steps to Reproduce Updated
2011-12-09 15:58	administrator	Note Edited: 0000829
2011-12-09 15:59	administrator	Note Edited: 0000829

administrator 2011-12-09 15:53 administrator ~0000829 Last edited: 2011-12-09 15:59	already fixed in http://wackowiki.hg.sourceforge.net/hgweb/wackowiki/dev/ -> 5.0 branch But the search action still needs other fixes like word count, parameter passing for paging etc.