Page 1 of 1

Problem: 'Could not insert new word'

Posted: Tue Dec 26, 2006 11:57 pm
by 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

Posted: Wed Dec 27, 2006 12:11 am
by 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.

Posted: Wed Dec 27, 2006 12:14 am
by 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)

Posted: Wed Dec 27, 2006 12:30 am
by Lumpy Burgertushie
did you do the repair that marshall told you?

robert

Posted: Wed Dec 27, 2006 12:31 am
by Captain Jim
Lumpy Burgertushie wrote: 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!