GoFuckYourself.com - Adult Webmaster Forum - View Single Post

darnit · 08-12-2005, 07:26 PM

Fixed it via this post I found:

this problem appeared to us when we tried to place a normal "INDEX" on a column of datatype TEXT. Our solution, which is definitely legal but not necessarily effective (currently unknown) was to change the ALTER TABLE... command from INDEX to ALTER TABLE... FULLTEXT (column).

Thanks all for the suggestions.

08-12-2005, 07:26 PM
darnit Confirmed User Join Date: Jul 2001 Location: Teh Interweb Posts: 2,439	Fixed it via this post I found: this problem appeared to us when we tried to place a normal "INDEX" on a column of datatype TEXT. Our solution, which is definitely legal but not necessarily effective (currently unknown) was to change the ALTER TABLE... command from INDEX to ALTER TABLE... FULLTEXT (column). Thanks all for the suggestions.