Lately I get a lot of Database errors..[see [mediawiki-l] Database Error when saving] At first it seemed that restarting the whole thing took care of it, however now I encounter more and more of these errors. As for now I canŽt even access cerrtain pages without getting: Warning: mysql_query(): Unable to save result set in /var/www/html/itwiki/includes/Database.php on line 312
No refresh or restart seems to fix this.. IŽm running: MediaWiki : 1.4.0 PHP : 4.3.8 (apache2handler) MySQL : 4.0.20
Is there something I could do? greetings
sebastian n/a wrote:
Lately I get a lot of Database errors..[see [mediawiki-l] Database Error when saving] At first it seemed that restarting the whole thing took care of it, however now I encounter more and more of these errors.
Check what the errors actually are:
$wgShowSQLErrors = true;
Remember you can get additional info on MySQL error numbers with the 'perror' command. If you're seeing something like 'Table marked as crashed and needs to be repaired', issue a REPAIR TABLE command on the table.
-- brion vibber (brion @ pobox.com)
Thank you for you reply Brion, Sorry just one quick question...where does the $wgShowSQLErrors = true; go? in LocalSettings.php, or is it located in another file? Thank you
sebastian n/a wrote:
Thank you for you reply Brion, Sorry just one quick question...where does the $wgShowSQLErrors = true; go? in LocalSettings.php, or is it located in another file?
In LocalSettings.php, same place you'd put any other settings.
See DefaultSettings.php for a list of all configurable settings.
-- brion vibber (brion @ pobox.com)
At the end of the errorcode following line seems to be of importance.
Parser::replaceLinkHolders(the first part changes depending on what page I go, but the rest of the error code stays the same)". MySQL meldete den Fehler "1030: Got error 127 from table handler (localhost)".
Could this be of any help?
I still didnŽt really figure out which table(s) might be broken, this way leaving me in the dark where to apply the 'repair table' command. How can I execute the 'perror' command?
I'm sorry IŽm a real notech and apologize ...
sebastian n/a wrote:
At the end of the errorcode following line seems to be of importance.
Parser::replaceLinkHolders(the first part changes depending on what page I go, but the rest of the error code stays the same)". MySQL meldete den Fehler "1030: Got error 127 from table handler (localhost)".
Could this be of any help?
I still didn´t really figure out which table(s) might be broken, this way leaving me in the dark where to apply the 'repair table' command.
Just run it on all the tables. If you don't have shell access to the MySQL interpreter, use phpMyAdmin or whatever control panel your provider provides for you.
How can I execute the 'perror' command?
At a shell, like any other program:
$ perror 127 Error code 127: Unknown error: 127 127 = Record-file is crashed
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org