1 Topic by AlanCollier (edited by AlanCollier 2006-10-11 13:14)

  • Registered: 2006-05-03
  • Posts: 102

Topic: Table locking? Search index problems..

Hi

Just today I'm getting lots of problems with:

"Unable to insert search index word matches."

When I try and post.

and

"Error: Unable to fetch search index word match."

When I try and delete messages.

Query   | 2297  | Locked       | SELECT m.post_id FROM punbb_search_words AS w INNER JOIN punbb_search_matches AS m ON m.word_id = w. |
| 701322 | *database name*      | localhost         

Some issue with locking?

--Alan

AlanCollier's Website

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

Re: Table locking? Search index problems..

Please enable DEBUG mode and post the full error message.

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

Rickard's Website

  • Registered: 2006-05-03
  • Posts: 102

Re: Table locking? Search index problems..

When I try to post:

An error was encountered
File: *******/public_html/messageboard/include/search_idx.php
Line: 183

PunBB reported: Unable to insert search index word matches

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

When I try to delete a post:

An error was encountered
File: ******/public_html/messageboard/include/search_idx.php
Line: 202

PunBB reported: Unable to fetch search index word match

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

Any ideas?

--Alan

AlanCollier's Website

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

Re: Table locking? Search index problems..

You need to repair the table

  • Registered: 2006-05-03
  • Posts: 102

Re: Table locking? Search index problems..

Can I just rebuild the search index? Will that do it?

--Alan

AlanCollier's Website

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

Re: Table locking? Search index problems..

No, you need to repair the MySQL table wink

7 Reply by AlanCollier (edited by AlanCollier 2006-10-12 11:01)

  • Registered: 2006-05-03
  • Posts: 102

Re: Table locking? Search index problems..

I knew that's what you meant, I just couldn't find the option in PhpMyAdmin so I was hoping to get around it.
Found it now though and it's done the trick!

Thank you.

--Alan

AlanCollier's Website