Fix this if you can pls

[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

[Martrae]

Yeah...I just got that about 5 minutes ago.

[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

[vonkaar]

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


wtf???

[Scoota McGee]

Compact and Repair MySQL database?

[vonkaar]

yup, it should be fixed now

[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'

[Harrison]

I found this thread funny

(and I was getting those errors as well)