Forum Search WordList Error

[Memphis]

Could not insert new word

DEBUG MODE

SQL Error : 145 Table './savage_phpb3/phpbb_search_wordlist' is marked as crashed and should be repaired

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('app', 0), ('test', 0), ('thanks', 0), ('think', 0), ('u', 0)

Line : 234
File : functions_search.php

got this whilst replying to a thread

[arthurprs]

same here,

i think its savage managing things to upgrade te forum

[chronozphere]

I allready PM'ed savage about this.

[savage]

The tables have been repaired, so hopefully this won't appear now, for a little while.

If one sees anything, yell!

[JernejL]

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1194 Table 'phpbb_search_results' is marked as crashed and should be repaired

DELETE FROM phpbb_search_results WHERE search_time < 1207166603

Line &#58; 658
File &#58; search.php

Tables got broken again, i suggest you do a full backup too.

[savage]

Repaired, but every few days it goes out of whack. Maybe I should set up a cron job to repair it periodically now.

[JernejL]

make a cron to make backups too!

[Christian Knudsen]

I'm getting the "could not insert new word" error when I try to post, but at the same time I see other posts from other people appearing, so am I the only one getting this error right now?

[jasonf]

same here.. it's broken for me

[paul_nicholls]

When I tried to post a reply today, I got this error:

General Error
 
Could not insert new word

DEBUG MODE

SQL Error : 144 Table './savage_phpb3/phpbb_search_wordlist' is marked as crashed and last (automatic?) repair failed

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('0', 0), ('123', 0), ('125', 0), ('16bit', 0), ('512', 0), ('22050', 0), ('22khz', 0), ('achannel', 0), ('add', 0), ('afilename', 0), ('amount', 0), ('aname', 0), ('ansistring', 0), ('anything', 0), ('array', 0), ('audio', 0), ('audios16', 0), ('begin', 0), ('below', 0), ('boolean', 0), ('break', 0), ('buf', 0), ('callback', 0), ('cdecl', 0), ('channel', 0), ('channels', 0), ('cheers', 0), ('chunks', 0), ('class', 0), ('classes', 0), ('closeaudio', 0), ('cmaxsounds', 0), ('code', 0), ('complete', 0), ('const', 0), ('constructor', 0), ('convert', 0), ('coud', 0), ('create', 0), ('cvt', 0), ('data', 0), ('delphi', 0), ('destroy', 0), ('destructor', 0), ('device', 0), ('dlen', 0), ('dpos', 0), ('empty', 0), ('end', 0), ('endif', 0), ('engineaudiosdl', 0), ('examples', 0), ('exit', 0), ('false', 0), ('faudioinitialized', 0), ('faudiomodule', 0), ('fdatapath', 0), ('file', 0), ('filename', 0), ('files', 0), ('finished', 0), ('first', 0), ('fmt', 0), ('following', 0), ('format', 0), ('fpc', 0), ('fprintf', 0), ('free', 0), ('freemem', 0), ('freq', 0), ('fsoundnames', 0), ('function', 0), ('games', 0), ('getmem', 0), ('gp2x', 0), ('hacked', 0), ('helps', 0), ('hope', 0), ('i', 0), ('ifdef', 0), ('immediately', 0), ('implementation', 0), ('inc', 0), ('index', 0), ('inherited', 0), ('initaudio', 0), ('initialization', 0), ('initsounds', 0), ('integer', 0), ('interface', 0), ('later', 0), ('least', 0), ('len', 0), ('lencvt', 0), ('lenmult', 0), ('load', 0), ('methods', 0), ('miss', 0), ('misssound', 0), ('mixaudioproc', 0), ('mode', 0), ('move', 0), ('music', 0), ('n', 0), ('nil', 0), ('open', 0), ('override', 0), ('paul', 0), ('pbytearray', 0), ('pchar', 0), ('play', 0), ('playing', 0), ('playmusicwav', 0), ('plays', 0), ('playsoundwav', 0), ('pointer', 0), ('private', 0), ('procedure', 0), ('public', 0), ('puint8', 0), ('quot', 0), ('regards', 0), ('register', 0), ('registermusicwav', 0), ('registersoundwav', 0), ('result', 0), ('return', 0), ('sample', 0), ('samples', 0), ('sdl', 0), ('sdlbuildaudiocvt', 0), ('sdlcloseaudio', 0), ('sdlconvertaudio', 0), ('sdlfreewav', 0), ('sdlgeterror', 0), ('sdlloadwav', 0), ('sdllockaudio', 0), ('sdlmixaudio', 0), ('sdlmixer', 0), ('sdlmixmaxvolume', 0), ('sdlopenaudio', 0), ('sdlpauseaudio', 0), ('sdlunlockaudio', 0), ('send', 0), ('set', 0), ('slot', 0), ('sound', 0), ('sounds', 0), ('starts', 0), ('stderr', 0), ('stereo', 0), ('still', 0), ('stopmusicwav', 0), ('stopsound', 0), ('stopsoundwav', 0), ('stream', 0), ('stuff', 0), ('taudiomodulesdl', 0), ('thomas', 0), ('timer', 0), ('tmusic', 0), ('together', 0), ('tsdlaudiocvt', 0), ('tsdlaudiospec', 0), ('tsound', 0), ('tstringlist', 0), ('type', 0), ('uint32', 0), ('unable', 0), ('und', 0), ('unit', 0), ('unused', 0), ('update', 0), ('userdata', 0), ('uses', 0), ('using', 0), ('value', 0), ('values', 0), ('var', 0), ('virtual', 0), ('wav', 0), ('wave', 0), ('web', 0), ('while', 0), ('win32', 0), ('working', 0)

Line : 234
File : functions_search.php

cheers,
Paul