Page 1 of 1

Fix this if you can pls

Posted: Sat Jun 12, 2004 9:25 am
by labbats
Sometimes after editing posts, which I seem to do too often :shock: , I get this and it won't edit. It just hangs on this screen until I back up. Started happening this morning, and only does it about half the time.


Error in deleting post

DEBUG MODE

SQL Error : 1034 Incorrect key file for table: 'phpbb_search_wordmatch'. Try to repair it

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (30750)

Line : 417
File : /var/www/html/phpBB2/includes/functions_search.php

Posted: Sat Jun 12, 2004 9:48 am
by Martrae
Yeah...I just got that about 5 minutes ago.

Posted: Sun Jun 13, 2004 9:24 am
by Phantomfist
Just got it now:


Could not insert new word matches

DEBUG MODE

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 30827, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('wait', 'minute', 'actually', 'thought', 'movie', 'one', 'coulda', 'told', 'blow', 'biggest', 'cock', 'thing', 'vin', 'motherfuckin', 'diesal', 'tuggan', 'frosty', 'visiting', 'hell', 'agree', 'tug', 'garfield')

Line : 249
File : /var/www/html/phpBB2/includes/functions_search.php

Posted: Sun Jun 13, 2004 10:46 am
by vonkaar
'wait', 'minute', 'actually', 'thought', 'movie', 'one', 'coulda', 'told', 'blow', 'biggest', 'cock', 'thing', 'vin', 'motherfuckin', 'diesal', 'tuggan', 'frosty', 'visiting', 'hell', 'agree', 'tug', 'garfield')


wtf???

Posted: Sun Jun 13, 2004 10:51 am
by Scoota McGee
Compact and Repair MySQL database?

Posted: Sun Jun 13, 2004 10:52 am
by vonkaar
yup, it should be fixed now

Posted: Sun Jun 13, 2004 10:55 am
by Scoota McGee
test test

'wait', 'minute', 'actually', 'thought', 'movie', 'one', 'coulda', 'told', 'blow', 'biggest', 'cock', 'thing', 'vin', 'motherfuckin', 'diesal', 'tuggan', 'frosty', 'visiting', 'hell', 'agree', 'tug', 'garfield'

Posted: Wed Jun 16, 2004 10:20 am
by Harrison
I found this thread funny

(and I was getting those errors as well)