Textpattern CMS

#1 2006-10-24 20:41:05

axelheyst

Member

Registered: 2006-10-18

Posts: 12

Blank Search Results

There is a search box on the homepage of my site. When I use this to search (http://www.dumic.org/?q=drum) I get the following message:

- – - – - – - – - – - – - – - -

tag_error <txp:article/> -> Textpattern Warning: Can’t find FULLTEXT index matching the column list
select *, unix_timestamp(Posted) as uPosted, match (Title,Body) against (‘drum’) as score from textpattern where 1 and Status = 4 and Posted <= now() and (Title rlike ‘drum’ or Body rlike ‘drum’) order by score desc limit 0, 10
textpattern/lib/txplib_db.php:222 startrows() on line 84

textpattern/lib/txplib_db.php:84 trigger_error()
textpattern/lib/txplib_db.php:284 safe_query()
textpattern/lib/txplib_db.php:222 startrows()
textpattern/publish.php:676 safe_rows_start()
textpattern/publish.php:804 doarticles()
textpattern/publish.php:504 parsearticles()
textpattern/publish.php:958 article()
processtags()
textpattern/publish.php:917 preg_replace_callback()
textpattern/publish.php:453 parse()

- – - – - – - – - – - – - – - -

Any ideas? I have not really touched my TXP DB so I don’t know why it’s doing this. This began happening after the recent upgrade to 4.0.4 …

#2 2006-10-25 00:12:26

jm

Plugin Author

From: Missoula, MT

Registered: 2005-11-27

Posts: 1,746

Website

Re: Blank Search Results

Did you try this?

---

What? My name is… | GitHub

#3 2006-10-25 00:28:05

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Blank Search Results

It means your FULLTEXT index is now missing or has been altered. If you open up a program like phpMyAdmin, and look at the “textpattern” table in your database, you should be able to see the “Indexes” listed at the bottom. There should be one named “searching” containing fields “Title” and “Body”.

#4 2006-10-25 01:38:15

axelheyst

Member

Registered: 2006-10-18

Posts: 12

Re: Blank Search Results

I am not sure that the FULLTEXT index thing was altered. This is what it looks like now:

Any ideas? Thanks you in advance.

#5 2006-10-25 01:39:53

zem

Developer Emeritus

From: Melbourne, Australia

Registered: 2004-04-08

Posts: 2,579

Re: Blank Search Results

It has been altered, to add custom_1 and custom_2 as searchable fields.

---

Alex

#6 2006-10-25 01:42:46

axelheyst

Member

Registered: 2006-10-18

Posts: 12

Re: Blank Search Results

Thank you very much.

Removing the custom fields seemed to fix this. Any thoughts on why that was breaking the search?

Last edited by axelheyst (2006-10-25 01:43:14)

#7 2006-10-25 02:08:40

axelheyst

Member

Registered: 2006-10-18

Posts: 12

Re: Blank Search Results

Hmm, now I remember I added those custom fields to the INDEX for a separate search I built in PHP. Is there anyway I can leave those custom_fields in the FULLTEXT index and not break the TXP search?

Thanks.

#8 2006-10-25 02:57:42

zem

Developer Emeritus

From: Melbourne, Australia

Registered: 2004-04-08

Posts: 2,579

Re: Blank Search Results

you should be able to add a second index, with a different name.

---

Alex

#9 2006-10-25 03:00:19

axelheyst

Member

Registered: 2006-10-18

Posts: 12

Re: Blank Search Results

Thanks, I will try that. Is there a way to specify which index to use when running a simple PHP / MySQL FULLTEXT search query?

#10 2006-10-25 04:11:08

zem

Developer Emeritus

From: Melbourne, Australia

Registered: 2004-04-08

Posts: 2,579

Re: Blank Search Results

Please see the MySQL manual.

---

Alex

#11 2006-10-25 04:24:12

axelheyst

Member

Registered: 2006-10-18

Posts: 12

Re: Blank Search Results

Thank you.

#12 2006-10-26 03:32:57

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Blank Search Results

I believe MySQL will use whichever index matches the columns you search.