What's up with the error messages?

[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()

[DeadPoolX]

Yeah, Maia and I have been getting those a lot lately as well. It's usually when we edit a post.

[Tawmis]

Not seen that yet.

I suppose we could begin with asking...

What operating system and browser are you using?

[DeadPoolX]

Firefox. I haven't tried it with IE, Opera or Chrome.

[dotkel50]

I use IE8 and i've been getting it too.

[Collector]

I have upgraded the phpBB. Lets see if that fixes the issues.

[Tawmis]

Weird. I use Firefox and have not seen the error.

[Collector]

Running the update seems to have sped things up.

[dotkel50]

Mr. C,

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

[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

[dotkel50]

Looks like it's fixed.

[AndreaDraco]

Collector, I try editing your message to see if the fix worked even in this case, and it works. Problem solved!

[Tawmis]

And there was much rejoicing.

[Rath Darkblade]

Why was there much rejoicing? Were we forced to eat Robin's minstrels? *waves a flag*

[MusicallyInspired]

No. Cocunuts. Carried by European Swallows. Two of them holding it together.