Problem: 'Could not insert new word'

[Captain Jim]

This is the error message I or anyone else makes a post, the post goes through correctly though.......but it doesn't show up as the latest post but it's there.

Could not insert new word

DEBUG MODE

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('congrats', 0), ('miamiu', 0)

Line : 234
File : functions_search.php

[espicom]

Start with a repair of the affected table - if the problem still exists, and you have phpmyadmin (the best way to do the repair mentioned a moment ago), you can try executing the same query in its SQL window, and see what the actual error message MySQL is giving is.

First link in my signature can help with repairs, if you do not have phpmyadmin.

[Captain Jim]

The Collation for this table is 'In Use'

While all the other tables are 'latin1_swedish_ci'

Here is what SQL error I'm getting from phpmyadmin:

#1016 - Can't open file: 'phpbb_search_wordlist.MYI' (errno: 145)

[Lumpy Burgertushie]

did you do the repair that marshall told you?

robert

[Captain Jim]

did you do the repair that marshall told you?

robert

I ran the repair and the issue is fixed.

Thanks a lot! You guys are good!