Forums Error Could not insert new word

Posted: Tue Mar 25, 2003 5:03 am

Everything was working fine (using nuke 6.5 final) bu today i noticed that when someone posts a message to the forum there's an error. any idea?

Could not insert new word

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordlist.MYD'. (errno: 145)

INSERT IGNORE INTO nuke_bbsearch_wordlist (word_text, word_common) VALUES ('test', 0)

Line : 265
File : /usr/local/psa/home/vhosts/turkrock.com/httpdocs/includes/functions_search.php

Posted: Tue Mar 25, 2003 6:41 am

Make a backup of the bbsearch_wordlist table, then drop it, then create it again through phpMyAdmin.

Code:

CREATE TABLE nuke_bbsearch_wordlist (
word_text varchar(50) binary NOT NULL default '',
word_id mediumint(8) unsigned NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (word_text),
KEY word_id (word_id)
) TYPE=MyISAM;

.
Once recreated use your backup to insert the data into it, only use the insert lines from your backup.

Posted: Tue Mar 25, 2003 7:00 am

i couldn't wait for an answer and i dropped the nuke_bbsearch_wordlist table before your post, and recreated again. now it works but i didn't make a backup. just created a fresh table.

same thing happened with private messages few months ago and i solved the problem same way but i lost all the private messages in the site of course. but that was not very important for me.

now what have i lost? i couldn't make a backup because phpmyadmin gave errors while trying to backup that table.

why is this happening? is it about my hosting company? is it because of heavy traffic in mysql? it is important for me because i can't know if the same thing will happen in a more important table.

Posted: Tue Mar 25, 2003 7:07 am

Each table's structure gets saved into .MYD files, at times they become corrupt, why they dissapear is not clear to me at the moment but just like any other problem, you should always make regular backups of your database in case things like this happen so that you don't lose data or at least not all of it.

Posted: Thu Apr 17, 2003 5:52 pm

The problem you may be facing now is with your Forum search.

All those words that were stored in that table were all words from your forums posts.
Now when a user tries to search for a WORD or WORDS that YOUR know is in a forum post, it may come back with No results found. Confused

The wordlist table is almost like a log file for all your forum posts text for use by the Search in the forums.

What happens is whenever a user posts a topic, the text from that topic gets inserted into the wordslist table. If the table is corrupted or not there, then the end result is the error you got
"Could not insert new word matches"
Where is it inserting them?..in the wordlist table so that when you go to search your forums, it can find the wordmatches in the wordslist table...
Hope that makes sense...

mikem

Posted: Thu Apr 17, 2003 5:57 pm

I believe Anor has a search rebuild script at www.portedmods.com, it didn't work for me but maybe i didn't follow instructions or something

Posted: Thu Apr 17, 2003 6:21 pm

chatserv wrote:

I believe Anor has a search rebuild script at www.portedmods.com, it didn't work for me but maybe i didn't follow instructions or something

That would be excellent if it actually works. That table seems to be a bugger to backup as it is...

mikem

Nuke Cadet Joined: Aug 12, 2004 Posts: 1

Heya, im having this problem with our forums also. Could you tell me where;

Quote:

Make a backup of the bbsearch_wordlist table

Is located..... I cant seem to find that file, to backup and then recreate..

Any help will be much appreciated.... Wink

Thor