On Tue, 2007-08-07 at 19:34 +0200, MESHine Team wrote:
I issued this command on mysql (v5.0.45) command line:
ALTER TABLE
dewiki.text ADD FULLTEXT (old_text);
I have a question: How are you able to even execute this command without
an error, since old_text is of 'mediumblob' type? You can't add a
fulltext search on a mediumblob column type.
# time mysql mediawiki -e "ALTER TABLE ep_de_text ADD
FULLTEXT(old_text);"
ERROR 1283 (HY000) at line 1: Column 'old_text' cannot be part
of FULLTEXT index
Did you alter the table to set that to 'longtext' or something first?
--
David A. Desrosiers
desrod(a)gnu-designs.com
setuid(a)gmail.com
http://projects.plkr.org/
Skype...: 860-967-3820