PDA

View Full Version : Forum Search WordList Error



Memphis
07-03-2008, 10:00 PM
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
08-03-2008, 12:54 AM
same here,

i think its savage managing things to upgrade te forum :)

chronozphere
08-03-2008, 01:04 AM
I allready PM'ed savage about this. ;)

savage
08-03-2008, 05:16 PM
The tables have been repaired, so hopefully this won't appear now, for a little while.

If one sees anything, yell!

JernejL
02-04-2008, 09:05 PM
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
03-04-2008, 09:29 PM
Repaired, but every few days it goes out of whack. Maybe I should set up a cron job to repair it periodically now.

JernejL
03-04-2008, 10:36 PM
make a cron to make backups too!

Christian Knudsen
06-04-2008, 11:43 AM
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
06-04-2008, 11:58 AM
same here.. it's broken for me

paul_nicholls
07-04-2008, 01:29 AM
When I tried to post a reply today, I got this error:


General Error

Could not insert new word

DEBUG MODE

SQL Error &#58; 144 Table './savage_phpb3/phpbb_search_wordlist' is marked as crashed and last &#40;automatic?&#41; repair failed

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

Line &#58; 234
File &#58; functions_search.php


cheers,
Paul

Wizard
07-04-2008, 05:57 AM
I also got this 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 ('100', 0), ('accelerated', 0), ('chronozphere', 0), ('crashed', 0), ('device', 0), ('didn’t', 0), ('duplication', 0), ('error', 0), ('evil', 0), ('few', 0), ('file', 0), ('fps', 0), ('fun', 0), ('game', 0), ('graphics', 0), ('hit', 0), ('keep', 0), ('laptop', 0), ('log', 0), ('play', 0), ('sorry', 0), ('sql', 0), ('submit', 0), ('tried', 0), ('work', 0), ('works', 0), ('–', 0)

Line : 234
File : functions_search.php