User:WikiSysop

From InterSciWiki
Jump to: navigation, search

record of fixes

e.g., October 7th. 2007

Hi Prof White,
It seems that the MySQL database service died.  I'll review the /var/log/mysqld.log file to see if I can figure out why. 
To get it started again, I did:
su - root                              (this allows you to become the "root" or administrator user) 
Password:                              type this  
service mysqld restart                 tells the MySQL service to stop (or be killed if it is "frozen") and then start again. 

The command "service" can be run at any level in the Unix directory when you are the root user because its absolute location, /sbin/service, is in the PATH. This will not work as a normal user, such as your normal login.

This is all a fix for the Oct 7:

MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred
Query: SELECT value,exptime FROM `mw_objectcache` WHERE keyname='mediawiki-mw_:messages-hash'
Function: MediaWikiBagOStuff::_doquery
Error: 1033 Incorrect information in file: './mediawiki/mw_objectcache.frm' (localhost)
' in /home/intersci/wiki/includes/Database.php:806
Stack trace:
#0
etc