PDA

View Full Version : SQL error


JTF
9-26-05, 02:09 AM
Yesterday and today we can bring up our site www.journeytowardsfreedom.com
but when we try to post, we receive a debug error. I have emailed powweb support but am on vacation and cannot access my email to see if I have a reply. My tech admin said to notify my server as this is a problem with the mysql data base. Help!
We have had quite a few problems with downtime.

Could not insert new word matches

DEBUG MODE

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

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 57891, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('test')

Line : 251
File : functions_search.php

tbonekkt
9-26-05, 09:21 AM
Repair the 'phpbb_search_wordmatch' table using phpmyadmin.

JTF
9-26-05, 05:02 PM
My admin repaired it and it worked for a few hours but now we are still having problems logging in. At first I get cannot find server, then I don't get anything, then after about 8 tries I got in. Everyone is still having problems.

How can I get this resolved?

JTF

Vinny @ SBA
9-26-05, 05:12 PM
My admin repaired it and it worked for a few hours but now we are still having problems logging in. At first I get cannot find server, then I don't get anything, then after about 8 tries I got in. Everyone is still having problems.

How can I get this resolved?

JTF

The REPAIR command is the first line of action that most here will tell you to take. It's sort of like calling a help desk line about a problem with a sticky spacebar and they ask you to reboot your computer.

The issue you're seeing is likely due to yet another DDoS powweb is facing.

quick5pnt0
9-27-05, 05:00 PM
See this post
http://www.phpbb.com/phpBB/viewtopic.php?t=259967