RE: FULLTEXT error?

2002-02-27 Thread Al Caponi
Hi Doug, What's the MySQL version you're running? Your SQL query worked fine on my PC. MySQL 3.23.47 Win98SE Last time I had some problem (that was 3.23.32 I think) when mixing VARCHAR and TEXT types in the FULLTEXT index. After upgrading to MySQL 3.23.47, I did not encounter anymore problem lik

Re: FULLTEXT error?

2002-02-27 Thread DL Neil
Doug, Can quite see why you have id as a key twice, but... This worked first time for me (3.23.40-nt). Regards, =dn > Error > > SQL-query: > > CREATE TABLE quotes ( > id int(9) NOT NULL auto_increment, > author varchar(255), > content text, >