Textpattern CMS

#1 2012-03-27 20:20:16

Mats

Member

From: Sweden

Registered: 2011-01-16

Posts: 30

Website

Solved: Database problem

Hi!

I’m having some trouble with a database when searching:

Tagg-fel: <txp:article limit="30" pageby="10" searchsticky="1" sort="Posted desc" /> ->  Textpattern Warning: Can't find FULLTEXT index matching the column list
select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod, match (`Title`, `Body`, `Keywords`) against ('mats') as score from lstextpattern as textpattern where 1=1 and Status >= 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and ((`Title` like '%mats%') or (`Body` like '%mats%') or (`Keywords` like '%mats%')) and Section != 'search' order by Posted desc limit 0, 30
textpattern/lib/txplib_db.php:227 startRows()  on line 89
textpattern/lib/txplib_db.php:89 trigger_error()
textpattern/lib/txplib_db.php:289 safe_query()
textpattern/lib/txplib_db.php:227 startRows()
textpattern/publish.php:815 safe_rows_start()
textpattern/publish.php:964 doArticles()
textpattern/publish.php:592 parseArticles()
textpattern/publish.php:1188 article()
textpattern/publish.php:1100 processTags()
textpattern/lib/txplib_misc.php:1706 parse()
textpattern/publish/taghandlers.php:314 parse_form()

Not sure when this problem occurred. There are hits on the searchterm but the article tag doesn’t display them.

Any help appreciated!

(I usually don’t search my own name. Honestly :-) )

/Mats

Last edited by Mats (2012-03-27 21:30:21)

#2 2012-03-27 20:36:55

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,315

Re: Solved: Database problem

Seems like it’s something to do with wet_haystack. I’ve not tried it yet, so my idea might be a dumb one, but can you re-index your database?

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#3 2012-03-27 20:43:25

Mats

Member

From: Sweden

Registered: 2011-01-16

Posts: 30

Website

Re: Solved: Database problem

Hi Uli!

Any tips how to re-index? I’m using PHPMyAdmin.

Thanks!

/Mats

#4 2012-03-27 20:49:59

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,315

Re: Solved: Database problem

Mats wrote:

Any tips how to re-index? I’m using PHPMyAdmin.

Might be the wrong kind of gun ;) I meant wet_haystack. It must have an extension tab of its own where it lets you re-index your database. But you don’t say whether you use it at all? If so, this post here seems to be related to your problem, do you also have MLP installed?

Last edited by uli (2012-03-27 21:19:00)

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#5 2012-03-27 21:23:20

Mats

Member

From: Sweden

Registered: 2011-01-16

Posts: 30

Website

Re: Solved: Database problem

Sorry Uli… I did use wet_haystack, but deactivated it and deleted it.

#6 2012-03-27 21:29:46

Mats

Member

From: Sweden

Registered: 2011-01-16

Posts: 30

Website

Re: Solved: Database problem

Installed the haystack again and now it’s back in business!

Thanks for your help Uli!

/Mats

#7 2012-03-27 21:49:39

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,315

Re: Solved: Database problem

Mats wrote:

back in business!

Cool! You’re welcome!

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}