• Registered: 2006-09-09
  • Posts: 15

Topic: error

when trying to post, delete, edit, move post / topics i get:

Error: Unable to fetch search index word match.

what is the problem? it started after mysql database breakdown.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: error

Enable debug mode and paste the full error

  • Registered: 2006-09-09
  • Posts: 15

Re: error

at ths moment i have no access to ftp. but what i see in phpmyadmin is :

search_matches     Browse     Structure     Search     Insert     Empty     Drop      in use
search_words     Browse     Structure     Search     Insert     Empty     Drop     44,800     MyISAM

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: error

Oh noes, in use. I'd say, delete the search tables, recreate them and run the search rebuilding in Administration.

  • Registered: 2006-09-09
  • Posts: 15

Re: error

what does it mean "in use"?

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: error

I don't know precisecly, but last time I had it it meant the server shut down uncleanly while there was a query going on to that table. And I have no idea on how to get rid of it except to remake the table.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: error

You don't have to drop the tables, but you might have to run a repair from the command line. Talk to your host.

  • Registered: 2006-09-09
  • Posts: 15

Re: error

i used repair, seems it helped

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: error

Then you're in luck, it never helped for me tongue