General Error SQL ERROR [ mysqli ]

Started by rusix, July 20, 2010, 09:44:35 PM

Previous topic - Next topic

rusix

QuoteGeneral 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.


Seems you need to repair the table phpbb_search_wordmatch.  Thanks.

Ognir

Yes we are badly in need of a webmaster
Most zionists don't believe that God exists, but they do believe he promised them Palestine

- Ilan Pappe

§N9sh2bj

I'm no webmaster but it seems like a simple command.
Maybe rusix can post it?
moved on.
the author does not adopt jewish \'race theory\' or \'darwinism\'.
and believes \'jewish culture\' is mostly one of supporting their organized crime syndicates, with a enough veneer and an organized system of destroying and reshaping other cultures, to obfuscate the truth to most people.

rusix

You can go to the host control panel and go to the 'MySQL Database' section, you should see a 'repair database' section.  In there you can select a database, select the one that has the phpbb3 info, maybe 'tiu_forum' or 'tiu_phpbb3'.  Once selected, click on the repair button.

Or as a MySQL command, using phpMyAdmin would work, select the database, then click on the SQL tab, and enter the command:  
Quotemyisamchk --recover phpbb_search_wordmatch
this should do the same if above for some odd reason does not work, use:
Quotemyisamchk --safe-recover phpbb_search_wordmatch

You can read up on the commands here: http://dev.mysql.com/doc/refman/5.0/en/ ... epair.html

abduLMaria

if the error occurs during a search request, i think it is possible to use Joogle to do the search.

where you tell it the URL (TIU) and the search terms, and it searches on the specific website.

that's without installing a specific Joogle feature to the website, it's just using the Joogle search engine.

but i don't know the exact syntax.
Planet of the SWEJ - It's a Horror Movie.

http://www.PalestineRemembered.com/!

rusix

in search engine like so:

site:theinfounderground.com what im searching for

§N9sh2bj

did you fix this yet?

I'm inching my own way towards knowledge of these things, and rusix and others have essentially posted the way to fix it, so... go ahead and fix it.  :up:  :Whip:
moved on.
the author does not adopt jewish \'race theory\' or \'darwinism\'.
and believes \'jewish culture\' is mostly one of supporting their organized crime syndicates, with a enough veneer and an organized system of destroying and reshaping other cultures, to obfuscate the truth to most people.