Tried to edit a post:
General Error
SQL ERROR [ mysqli ]
Table './tiu_forum/phpbb_search_wordmatch' is marked as crashed and should be repaired [145]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
I get that too occasionally , hitting F5 usually fixes it and allows your edit to go thru.
Any time I try to search I encounter this error on the crashed ./tiu_forum/phpbb_search_wordmatch table and trying the refresh (F5) work around described here doesn't resolve. I heard the webmaster's spread thin so I presumed this was a glitch low on the list for resolution, but I've been shut out of searching for months now which really hampers research not to mention ensuring cogent thoughts for the board.
I looked up that corrupted table error message on the phpBB site and a support team member replies as I would expect:
QuoteThis is a problem with your database server, and cannot be corrected by phpBB itself.
What you need to do is access the "Database management" tools supplied by your web host. This should be an option somewhere on the control panel you use to configure your websire, NOT the phpBB control panel.
Most often this runs a program called phpMyAdmin, which is a very popular utility for managing MySQL databases.
Otherwise, you may need to report this error to your web hosting company, and ask them to do the repair.
So they recommend using the site host's MySQL admin tools to rebuild the ./tiu_forum/phpbb_search_wordmatch table. I don't know, maybe the search error's unique to my connection?
Does rmstock know anything about this?
well do i know about this? Yes, it always (mostly) happens when editing a fresh post on a forum here.
then click (go back one page) in your brower, then
"fait vos jeuz , rien ne va plus" and try again.
I did have some major problems getting registered on TiU because the registry part of TiU
doesn't like my email address. I then used a different email address . If e.g. today i want to readjust
my account settings here with my regular email address (
stock@stokkie.net) the TiU mysql
backend will simply fail to work.
It still edits properly just goes to the error page if you click board index then view you post you will see it worked :up:
think this might be related to a bug injected into the TIU software by the Talmud-worshippers ?
i'm sure they watch this website.
Hardly, we need someone capable of doing the upgrades
I think it's on the database side:
-----
SQL Error : 1194 Table 'phpbb_search_wordmatch' is marked as crashed and should be repaired
The problem occures because of the table 'phpbb_search_wordmatch' into the database is crashed. We need to repair the table 'phpbb_search_wordmatch'. You may receive error message as below.
————————————————————————————
SQL Error : 1194 Table 'phpbb_search_wordmatch' is marked as crashed and should be repaired
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 43146, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('test')
Line : 251
File : functions_search.php
————————————————————————————-
To fix the problem go to your phpmyadmin and execute the following query.
REPAIR TABLE phpbb_search_wordmatch;
This query repairs the table 'phpbb_search_wordmatch' from the database and your forum will work fine.
You may receive similar error message for any table into the phpbb the solution is same. Ony the database name in the above query will be change. Suppose your table 'phpbb_disallow' in the database crashed, the command will be as below,
REPAIR TABLE phpbb_disallow;
Find the difference between above two REPAIR TABLE commands. The change is only the table name.
http://www.goonclick.com/sql-error-1194 ... -repaired/ (http://www.goonclick.com/sql-error-1194-table-phpbb_search_wordmatch-is-marked-as-crashed-and-should-be-repaired/)
Maybe joe will sort it out for us
Quote from: "Ognir"Maybe joe will sort it out for us
I know that it shall entail a complete upgrade of the software. How about next weekend for down-time?
I shall begin the preparations.