The Info Underground

Info Underground Sanctum => TIU Radio Guest/Show and Forum Suggestions => Topic started by: rusix on July 20, 2010, 09:44:35 PM

Title: General Error SQL ERROR [ mysqli ]
Post by: rusix on July 20, 2010, 09:44:35 PM
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.
Title: Re: General Error SQL ERROR [ mysqli ]
Post by: Ognir on July 21, 2010, 02:23:20 AM
Yes we are badly in need of a webmaster
Title: Re: General Error SQL ERROR [ mysqli ]
Post by: §N9sh2bj on July 21, 2010, 07:44:01 AM
I'm no webmaster but it seems like a simple command.
Maybe rusix can post it?
Title: Re: General Error SQL ERROR [ mysqli ]
Post by: rusix on July 26, 2010, 10:21:13 AM
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 (http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html)
Title: Re: General Error SQL ERROR [ mysqli ]
Post by: abduLMaria on July 27, 2010, 10:08:34 AM
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.
Title: Re: General Error SQL ERROR [ mysqli ]
Post by: rusix on July 28, 2010, 11:34:47 PM
in search engine like so:

site:theinfounderground.com what im searching for
Title: Re: General Error SQL ERROR [ mysqli ]
Post by: §N9sh2bj on September 02, 2010, 02:58:18 PM
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: