View Issue Details

IDProjectCategoryView StatusLast Update
0000406WackoWikisearchpublic2011-12-09 15:57
Reportertaskoma Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version5.0.rc 
Target Version5.0.0Fixed in Version5.0.0 
Summary0000406: Error with "Search in titles only" check on
Descriptionactions/search.php : 80

current situation:
"ORDER BY supertag".
"LIMIT {$pagination['offset']}, $limit");

need:
"ORDER BY supertag ".
"LIMIT {$pagination['offset']}, $limit");
Steps To Reproduce1) 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"
TagsNo tags attached.

Activities

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.

Issue History

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