Page 1 of 2

What's up with the error messages?

Posted: Fri Jan 15, 2010 2:29 am
by MusicallyInspired
Keep getting these error messages at random when I go to post, reply, PM, or edit a post. Just making sure you're aware of it. Next time it happens I'll copy and paste the message.

EDIT: Oh, there it is. Soon as I edited my post to say that it gives the error. Here it is:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table './collectr_phpb2/phpbb_search_wordmatch' is marked as crashed and should be repaired [145]

SQL

SELECT w.word_id, w.word_text, m.title_match FROM phpbb_search_wordlist w, phpbb_search_wordmatch m WHERE m.post_id = 11239 AND w.word_id = m.word_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/search/fulltext_native.php
LINE: 1085
CALL: dbal_mysql->sql_query()

FILE: includes/functions_posting.php
LINE: 2368
CALL: fulltext_native->index()

FILE: posting.php
LINE: 1000
CALL: submit_post()

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 2:39 am
by DeadPoolX
Yeah, Maia and I have been getting those a lot lately as well. It's usually when we edit a post.

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 2:40 am
by Tawmis
Not seen that yet.

I suppose we could begin with asking...

What operating system and browser are you using?

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 3:12 am
by DeadPoolX
Firefox. I haven't tried it with IE, Opera or Chrome.

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 3:31 am
by dotkel50
I use IE8 and i've been getting it too.

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 4:40 am
by Collector
I have upgraded the phpBB. Lets see if that fixes the issues.

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 4:52 am
by Tawmis
Weird. I use Firefox and have not seen the error.

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 5:49 am
by Collector
Running the update seems to have sped things up.

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 12:11 pm
by dotkel50
Mr. C,

I just tried editing my previous post to see if I still got the error, and I did.

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 1:48 pm
by Collector
After manually replacing the fingered files I was able replicate the error, so the problem has to be in the SQL database. I am not really familiar with SQL, but the CPanel does have a repair function. Let's see if it is fixed, now.

Edit: TEST, TEST, TEST, TEST

Re: What's up with the error messages?

Posted: Fri Jan 15, 2010 2:37 pm
by dotkel50
Looks like it's fixed.

Re: What's up with the error messages?

Posted: Sat Jan 16, 2010 7:31 am
by AndreaDraco
Collector, I try editing your message to see if the fix worked even in this case, and it works. Problem solved! :D

Re: What's up with the error messages?

Posted: Tue Jan 19, 2010 12:24 pm
by Tawmis
And there was much rejoicing. :P

Re: What's up with the error messages?

Posted: Wed Jan 20, 2010 4:59 am
by Rath Darkblade
Why was there much rejoicing? Were we forced to eat Robin's minstrels? ;) *waves a flag* ;)

Re: What's up with the error messages?

Posted: Wed Jan 20, 2010 12:02 pm
by MusicallyInspired
No. Cocunuts. Carried by European Swallows. Two of them holding it together.