Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

domm (4030)

domm
  (email not shown publicly)
http://domm.plix.at/

Just in case you like to know, I'm currently full-time father of 2 kids, half-time Perl hacker, sort-of DJ, bicyclist, no longer dreadlocked and 33 years old

I'm also head of Vienna.pm [pm.org], maintainer of the CPANTS [perl.org] project, member of the TPF Grants Commitee [perlfoundation.org] and the YAPC Europe Foundation [yapceurope.org].

I've got stuff on CPAN [cpan.org], held various talks [domm.plix.at] and organised YAPC::Europe 2007 in Vienna [yapceurope.org].

Journal of domm (4030)

Tuesday April 04, 2006
03:09 PM

MySQL crazyness

[ #29217 ]

I'm still maintaing a certain $project, which runs on MySQL (and Class::DBI, Template::Toolkit, mod_perl and a whole lot other stuff). Today, I got a bug report stating that the programme search cannot find a certain programm ("Help - Das Konsumentenmagazin").

So I tried the search, and it didn't work, even though the data is there. Yay, Heisenbug, I thought, and tried the query directly in the mysql shell. Didn't work either. After some tinkering I realized that 'help' is a MySQL fulltext search stopword. D'oh!

While I can see a point in making 'help' a stopword (it seems to be used quite often), it's IMO a very dumb decision to make it a stopword. People will look for 'help'!

To top it, you have to recompile (!) MySQL to change the stopwords list. Me hates MySQL!

As the sysadmins running the site will never, ever recompile MySQL (they also turned down switching from 5.6.something to 5.8.something because that might break some of the other apps (done in Java) running on the server...), my only options seems to hardcode a workaround into the app ($search='konsumentenmagazin' if $search == 'help').

Sigh...

My only hope for the future is that they issue a company guideline to not name any new radio programmes after a MySQL stopword.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.