Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,472
There are 1406 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     HTML/XHTML/DHTML/CSS :

phpBB forum error, HELP!

Thread title: phpBB forum error, HELP!
Closed Thread    
    Thread tools Search this thread Display Modes  
10-17-2005, 08:43 PM
#1
t0m is offline t0m
Status: Request a custom title
Join date: Jan 2005
Location: West Sussex, England
Expertise:
Software:
 
Posts: 2,829
iTrader: 21 / 100%
 

t0m is on a distinguished road

  Old  phpBB forum error, HELP!

SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MYI'. (errno: 145)

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 5766, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('particularly', 'great', 'passable', 'tho')

Line : 251
File : functions_search.php

People are getting this everytime they post, what does it mean, and how is it fixable? the post still goes ahead fine, but the 'last post by' bit is wrong

HELP!!!

10-17-2005, 10:24 PM
#2
mderbyshire is offline mderbyshire
Status: Member
Join date: Nov 2004
Location:
Expertise:
Software:
 
Posts: 203
iTrader: 0 / 0%
 

mderbyshire is on a distinguished road

Send a message via MSN to mderbyshire

  Old

Is this 'wordmatch' something included with phpBB, or a seperate module/plugin you have installed? I ask because I can't say i've ever seen any reference to this before.

Anyway - it looks to be an error with your MySQL database (or rather, the 'phpbb_search_wordmatch' table), because phpBB is having problems opening this table. Perhaps it has become corrupt.

Do you have phpMyAdmin installed on the server where your forum resides? If so, perhaps try using the 'Repair' tool on that particular table to see if that corrects the issue?

10-17-2005, 10:29 PM
#3
Aros is offline Aros
Aros's Avatar
Status: Lurker
Join date: Jul 2004
Location: the Netherlands
Expertise:
Software:
 
Posts: 1,074
iTrader: 2 / 100%
 

Aros is on a distinguished road

  Old

Doesn't phpBB offer support?

10-24-2005, 12:45 PM
#4
Cooleo is offline Cooleo
Status: Member
Join date: Sep 2005
Location: Stoke, UK
Expertise:
Software:
 
Posts: 151
iTrader: 0 / 0%
 

Cooleo is on a distinguished road

Send a message via MSN to Cooleo

  Old

Yeah they do at their forums.
http://www.phpbb.com/phpBB/viewtopic...hwordmatch+myi

Apparently you need to repair your database.

10-24-2005, 01:07 PM
#5
DateinaDash is offline DateinaDash
Status: The BidMaster
Join date: Nov 2004
Location: England
Expertise:
Software:
 
Posts: 10,821
iTrader: 0 / 0%
 

DateinaDash is on a distinguished road

  Old

Repair the table in the database and it should work fine!

10-25-2005, 01:24 PM
#6
t0m is offline t0m
Status: Request a custom title
Join date: Jan 2005
Location: West Sussex, England
Expertise:
Software:
 
Posts: 2,829
iTrader: 21 / 100%
 

t0m is on a distinguished road

  Old

Excellent guys, thanks for the help, appears to work fine now

Closed Thread    


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed