PHP Web Host - Quality Web Hosting For All PHP Applications Clan Themes! We make clans look good!!
  Login or Register
 • Home • Downloads • Your Account • Forums • 

View next topic
View previous topic


Google
 
Web RavenPHPScripts (This Site)
Post new topic   Reply to topic
Author Message
Muffin
Client


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

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

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: 2387

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

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.
View user's profile Send private message
Muffin
Client


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

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

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


Joined: Jan 02, 2003
Posts: 2387

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

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.
View user's profile Send private message
Muffin
Client


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

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

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!
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic

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
Forums ©
 

All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters, all the rest © 2002-2010 by Raven

You can syndicate our news using the file xml

CSE HTML Validator Helped Clean up This Page! [Valid RSS] valid RSS 2.0 Valid robots.txt Stop Spam Harvesters, Join Project Honey Pot

Website engines core code is © copyright by PHP-Nuke but has been heavily patched and modified by myself and others.
PHP-Nuke is a free software released under the GNU/GPL.


:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::
:: fisubice Theme Modified by the RavenNuke™ Team ::

:: W3C CSS Compliance Validation :: W3C HTML 4.01 Transitional Compliance Validation ::

zerosum