• Registered: 2005-05-04
  • Posts: 3

Topic: Unable to insert search index words

Hi,

I get this error with PunBB 1.2.5 when trying to post/reply :

Error: Unable to insert search index words

I've done a REPAIR TABLE, it then works, but the error always comes back a bit later !

please help me ...

  • Registered: 2005-05-04
  • Posts: 3

Re: Unable to insert search index words

Here is more information about the error :

File: /var/alternc/html/c/forum/include/search_idx.php
Line: 99

PunBB reported: Unable to fetch search index words

Database reported: Can't open file: 'forum_search_words.MYI' (errno: 145) (Errno: 1016)

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

Re: Unable to insert search index words

You have to repair the table.
If you have the DB Management Plugin, jsut hit the Repair button

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Unable to insert search index words

PunBB can't crash a table, willingly or not. If the table keeps crashing and needing a repair, there's a problem with your MySQL setup.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

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

Re: Unable to insert search index words

Mmm, I didn't read the part that said you repaired the table before tongue
So, what Rickard said wink

  • Registered: 2005-05-04
  • Posts: 3

Re: Unable to insert search index words

So what setup do I need to use with MySQL ?

Rickard wrote:

PunBB can't crash a table, willingly or not. If the table keeps crashing and needing a repair, there's a problem with your MySQL setup.

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

Re: Unable to insert search index words

Well, I saw something similar to this at a game I modded. A table used to crash every so often for seemingly no particluar reason. The admin thought the problem might have been some corrupted MySQL libraries, but he was too lazy to re-install it, since we were moving to a new server. We moved and haven't had a problem since wink
Basically, if this is on a server you control, think about re-installing MySQL and seeing if that helps.