WebGUI - searching non-ascii-characters (e.g. wiki) - Content Management System Website - CMS - Open Source Content Management System Website - Website System - Content Management System (CMS) | Open Source Content Management Software | Application Framework | WebGUI - Content Management System Website | CMS | WebGUI | Open Source Content Management System Website

Username Password

Home Features Sightings Download Partners Community

Community Support
Wiki
Forums
Report A Bug
Request Features
WebGUI 8
WebGUI TV
Add-ons and Plug-ins
Service Providers
webGUI in the news
Karma
API Docs
the people behind wg
webgui worldwide
Mascot
wallpapers
Stats
powered by icons

View All Tickets

searching non-ascii-characters (e.g. wiki) (#10797)

Issue

If I use a german character (äÄöÖüÜß) in a wiki search, it's not possible to find the article.

I'm not sure, but it seems to be a general (MySQL/DBD/DBI) problem.

For test, just make a wiki-article with a title "Ä".

I tested this on the actual versions (stable and beta) and the wre with 7.6.33.

Solution Summary

That sounds good.  If, in 7.7.19 it isn't fixed, then please reopen this bug.<br />
Resolved by perlDreamer

Comments

Graham 8/20/2009 4:24 pm	Fixed for next release.
martien 8/21/2009 1:44 am	I installed 7.7.18 now and reindexed, but there is no difference. testEnvironment was OK. Neither articles with non-ascii in the title nor text with a non-ascii search can be found. Within a wiki, also the links to a non-ascii title aren't shown. (btw. search.pl does not have the Custom-branch in it's INC)
martien 8/21/2009 2:17 am	There seem to be more reasons for this behaviour: Due to the Rich Text Editor, the non-ascii characters in texts are changed to HTML-Entities ;(( But also if I use Konqueror, where RTE doesn't work and the characters aren't changed, I can't get results.
perlDreamer 8/21/2009 11:56 am	Refixed in 7.7.19 Resolved by perlDreamer
martien 8/24/2009 5:12 pm	As far as I couldn try with the svn-version, there is no difference. Decoding seems to change to latin1. I tried this with source-install and on the wre. On http://www.gyford.com/phil/writing/2008/04/25/utf8_mysql_perl.php and its links I found some advices about utf which I don't use and aren't used within wre. ( e.g. perl -C ) So give me some time to wait for your 7.7.19 to see, if I'm wrong
perlDreamer 8/24/2009 5:51 pm	That sounds good. If, in 7.7.19 it isn't fixed, then please reopen this bug. Resolved by perlDreamer
martien 8/25/2009 4:52 pm	It works ( in the svn today)!! One DB was using latin1. So the gotchas: 1. Control the DB with mysql: mysql> STATUS; evtl: mysql> ALTER DATABASE database_name CHARACTER SET utf8; and (perhaps on some tables): mysql> SHOW CREATE TABLE table_name; mysql> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8; ... 2. Do the reindex: > cd <webguiroot>/sbin > perl search.pl --configFile=<configfile> --indexsite On wre it went wrong, while I was using the stable-version there. Should be nice, if it could be changed in that version soon.
perlDreamer 8/25/2009 5:05 pm	There won't be any more releases of 7.6. http://www.plainblack.com/tbb/webgui-7.7-stable-delayed

Details

Ticket Status	Closed
Rating
Submitted By	martien
Date Submitted	2009-08-20
Assigned To	Graham
Date Assigned	2009-08-20
Assigned By	perlDreamer
Severity	Critical (mostly not working)
What's the bug in?	WebGUI Stable
WebGUI / WRE Version	7.6.35/7.7.17
URL	use/bugs/tracker/10797

Keywords

Ticket History

8/25/2009 4:52 PM	Closed	martien
8/24/2009 5:51 PM	Resolved	perlDreamer
8/24/2009 5:12 PM	Pending	martien
8/21/2009 11:56 AM	Resolved	perlDreamer
8/21/2009 1:44 AM	Pending	martien
8/20/2009 4:25 PM	Resolved	Graham
8/20/2009 10:13 AM	Assigned to Graham	perlDreamer
8/20/2009 5:36 AM	Ticket created	martien