Not sure this is because Sentinel has been updated or not

Muffin · Client Joined: Apr 10, 2004 Posts: 649 Location: UK

Each time someone tries to post on the forum they are getting errors

Heres 3 examples:

Quote:

General Error

Could not insert new word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordmatch.MYI'. (errno: 145)

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 18396, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('rofl')

Line : 292
File : /home/minicity/public_html/nuke/html/includes/functions_search.php

---------------------------------

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordmatch.MYI'. (errno: 145)

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 18401, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('dirty', 'car')

Line : 292
File : /home/minicity/public_html/nuke/html/includes/functions_search.php

-------------------------------------

General Error

Could not insert new word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordmatch.MYI'. (errno: 145)

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 18398, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('yea', 'makes', 'wonder', 'whether', 'reading')

Line : 292
File : /home/minicity/public_html/nuke/html/includes/functions_search.php

Can someone help please?

sixonetonoffun · Posted: Thu Jul 29, 2004 7:36 am

Try running check table on 'nuke_bbsearch_wordmatch' I'd guess its corrupt. If it is try "repair" if that fails drop the table and reinstall (copy from nuke.sql) just that table.

Muffin · Client Joined: Apr 10, 2004 Posts: 649 Location: UK

Thanks

I got this error:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'nuke_bbsearch_wordmatch' at line 1

I did get 'Page cannot be displayed' shortly before the errors occurred so maybe the server crashed?

I must find a good book on databases and learn about them. Can anyone suggest an Idiots Guide to mySQL?

sixonetonoffun · Posted: Thu Jul 29, 2004 8:09 am

Actually the MySQL manual is pretty good and written in fairly plain language thats not too hard to follow. And it doesn't cost a thing. I'm going to move this topic out of Sentinel.

Muffin · Client Joined: Apr 10, 2004 Posts: 649 Location: UK

Thank you for your help it's much appreciated.

I'll print out the manual and work my way thru it

I'd like to just say I think the support on this site is amazing. Even for people like myself, that must be a liablity to ya! lol

Thank you all so much!