SQL Errors

[discspeed]

Has anyone else been experiencing a lot of SQL errors with this site the last couple of days?

[Booter]

i have since yesterday. ive had about 4 today. alot less than yesterday

[BCR-9er]

Yeah, I had one about an hour ago.

[elnino]

General Error
SQL ERROR [ mysql4 ]

Table 'm0' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


is this what everyone is seeing? the error doesn't allow me to search in firefox will try ie in a few minutes!

[discspeed]

Yeah, I posted this like I know what I'm talking about, but I don't at all. Any of you tech geeks know what the hell is going on?

[Timko]

We need Fritz to tell the the other admins some stuff about the backend first.

[dgdave]

I don;t think Fritzy needs to be told anything about the back end

[discspeed]

We need Fritz to tell the the other admins some stuff about the backend first.

I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).

[Dag]

General Error
SQL ERROR [ mysql4 ]

Table 'm0' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

This has been happening for a day or two when I attempt to search. Happens in Explorer and in Chrome fwiw.

[Timko]

We need Fritz to tell the the other admins some stuff about the backend first.

I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).

Actually, I did know about the 4 degrees warmer thing. "4 Degrees" is the title of a Tool song:

Apparently the anal cavity has 8 more working muscles and is 4 degrees warmer than the vagina. This, however, is NOT a song about violation. It is a song about opening up, completely, without reservation.

[discspeed]

We need Fritz to tell the the other admins some stuff about the backend first.

I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).

Actually, I did know about the 4 degrees warmer thing. "4 Degrees" is the title of a Tool song:

Apparently the anal cavity has 8 more working muscles and is 4 degrees warmer than the vagina. This, however, is NOT a song about violation. It is a song about opening up, completely, without reservation.

Yeah, that Maynard quote is where I got it from... Prison sex on the other hand is all about violation.

[Timko]

We need Fritz to tell the the other admins some stuff about the backend first.

I hear its 4 degrees warmer and has 8 more working muscles than the front end...but I guess Fritz knows all about that already. You other admins should man up and probe for yourselves. (BTW, I just got an SQL error trying to submit this).

Actually, I did know about the 4 degrees warmer thing. "4 Degrees" is the title of a Tool song:

Apparently the anal cavity has 8 more working muscles and is 4 degrees warmer than the vagina. This, however, is NOT a song about violation. It is a song about opening up, completely, without reservation.

Yeah, that Maynard quote is where I got it from... Prison sex on the other hand is all about violation.

I would be all about looking into the issue, but I to be able to query tables. The admin console is just a frontend application.

[Timko]

One more thing.

Here's another one you get when editing a post:

SQL ERROR [ mysql4 ]

Table 'm' is marked as crashed and should be repaired [1194]

SQL

SELECT w.word_id, w.word_text, m.title_match FROM search_wordlist w, search_wordmatch m WHERE m.post_id = 237310 AND w.word_id = m.word_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->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()

[JimW]

If I recall correctly from my time running a phpBB board someone probably just needs to run a repair query on each table in the database using something like phpMyAdmin. Pretty simple thing, the database just gets a bit funky at random times and needs to be ordered to fix itself. As mentioned before though it can't be done through the board admin panel, it's not actually the board software acting up (it may have caused the problem, dunno for sure, but it can't fix it). You'd have to have access to the hosting control panel to take care of it.

[what'shisname]

Every attempt at searching for the last few days has produced this error:

General Error
SQL ERROR [ mysql4 ]

Table 'm0' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.