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?