Textpattern CMS

#1 2008-04-21 19:30:16

renobird

Member

From: Gainesville, Florida

Registered: 2005-03-02

Posts: 786

Website

Search Results MySQL error?

Hello All,

My search stopped working today, and I’m getting this error:

Warning: Can't find FULLTEXT index matching the column list select *, unix_timestamp(Posted) as uPosted, match (Title,Body) against...

full/path/xxx/xxx/textpattern/lib/txplib_db.php on line 81

Does this look like a MySQL error that could be caused by something the hosting provider did?
(Media Temple)

I had everything working fine for weeks now, and this morning when I came into do a final test on the site I found this happening.

Any suggestions would be great.

Thanks!
—
Tom

#2 2008-04-21 19:42:37

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Search Results MySQL error?

Looks like you’re missing an index. You can fix this in PHPmyAdmin:

• select your database
• select the ‘textpattern’ table
• scroll down, choose “create index on [2] columns”
  • index name: searching
  • index type: FULL TEXT
  • fields: Title and Body
• press save

#3 2008-04-21 19:50:11

renobird

Member

From: Gainesville, Florida

Registered: 2005-03-02

Posts: 786

Website

Re: Search Results MySQL error?

Thanks Ruud,

I’ll give that a shot. Any idea how this could happen?
I’ve been using this database for quite a while, and the site has a lot of content.
Is this something that could have happened by accident?

UPDATE

The INDEX was there. I deleted and recreated.
Now all is working again.

I’m a bit out of my depth here
I have no idea what could have caused this…I’m just glad it’s working again.

Thanks for the help Ruud,
I would have NEVER found that.

)

—
Tom

Last edited by renobird (2008-04-21 20:01:17)

#4 2008-04-21 20:29:38

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Search Results MySQL error?

Hmm.. I have no idea what could cause this, but if the index already existed, perhaps it would have been enough to simply repair the table (using PHPmyAdmin). Quite often it’s easier to fix a problem than it is to find the cause.

#5 2008-04-21 20:45:05

renobird

Member

From: Gainesville, Florida

Registered: 2005-03-02

Posts: 786

Website

Re: Search Results MySQL error?

Quite often it’s easier to fix a problem than it is to find the cause.

Very true.

)

#6 2008-10-24 15:16:35

nabrown78

Member

From: Northampton, MA, USA

Registered: 2006-10-04

Posts: 294

Website

Re: Search Results MySQL error?

This thread totally saved me! I was getting the same error, and the same fix worked. I think I might have used an earlier search hack to include the Keywords field, which might have screwed things up.

Thanks!