RE: problems creating fulltext index

2003-01-31 Thread Salada, Duncan
Thanks for the tip about the 14 columns, Sergei and Dan. I reduced the number of columns by two and the index seemed to build just fine. I would like to make a suggestion though. I originally tried to create the fulltext index with more than 16 columns and received an error saying that I could h

Re: problems creating fulltext index

2003-01-29 Thread Dan Nelson
In the last episode (Jan 28), Salada, Duncan said: > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. > I'm trying to create a fulltext index on an existing myisam table and > running up against an error. From what I can tell, I'm using the > alter table command correctly, but I

Re: problems creating fulltext index

2003-01-29 Thread Sergei Golubchik
Hi! > > > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on > > > i686. I'm > > > trying to create a fulltext index on an existing myisam table > > > and running up > > > against an error. From what I can tell, I'm using the alter > > > table command > > > correctly, but I keep get

RE: problems creating fulltext index

2003-01-29 Thread Salada, Duncan
Hi! > -Original Message- > From: Erlend Hopsø Strømsvik [mailto:[EMAIL PROTECTED]] > > > -Original Message- > > From: Salada, Duncan [mailto:[EMAIL PROTECTED]] > > > > > > Hello everyone, > > > > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on > > i686. I'm > > t

RE: problems creating fulltext index

2003-01-29 Thread Erlend Hopsø Strømsvik
> -Original Message- > From: Salada, Duncan [mailto:[EMAIL PROTECTED]] > Sent: 28. januar 2003 20:40 > To: '[EMAIL PROTECTED]' > Subject: problems creating fulltext index > > > Hello everyone, > > I'm running Ver 8.39 Distrib 4.0.9-gamma,

problems creating fulltext index

2003-01-28 Thread Salada, Duncan
Hello everyone, I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point