Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL
Author Message
Muffin
Client



Joined: Apr 10, 2004
Posts: 649
Location: UK

PostPosted: Thu Jul 29, 2004 7:18 am Reply with quote

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?
 
View user's profile Send private message
sixonetonoffun
Spouse Contemplates Divorce



Joined: Jan 02, 2003
Posts: 2496

PostPosted: Thu Jul 29, 2004 7:36 am Reply with quote

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.

_________________
[b][size=5]openSUSE 11.4-x86 | Linux 2.6.37.1-1.2desktop i686 | KDE: 4.6.41>=4.7 | XFCE 4.8 | AMD Athlon(tm) XP 3000+ | MSI K7N2 Delta-L | 3GB Black Diamond DDR
| GeForce 6200@433Mhz 512MB | Xorg 1.9.3 | NVIDIA 270.30[/size:2b8 
View user's profile Send private message
Muffin







PostPosted: Thu Jul 29, 2004 7:54 am Reply with quote

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







PostPosted: Thu Jul 29, 2004 8:09 am Reply with quote

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







PostPosted: Thu Jul 29, 2004 8:20 am Reply with quote

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!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©