---------- Forwarded message ---------- From: Nicholas Washington washington367@gmail.com Date: 2011/11/10 Subject: HELP To: mediawiki-l-owner@lists.wikimedia.org
*Hi, I just recently got on board with MediaWiki and am looking forward to utilizing its functionality for use with a story I am in the process of writing.
Which MediaWiki version are you using? Is it a new install or an update of a previous one? From mediawiki.org or is it modified by a linux distro?
Upon installation, I noticed I am unable to access my wiki main page, nor am I able to edit it because of a DATABASE ERROR. After temporarily adding the function: $wgShowSQLErrors =true; It reads precisely as follows:*
(...)
Database returned error "1176: Key 'user_time' doesn't exist in table 'logging' (localhost)".
Much appreciated.
*To be perfectly honest I have no idea what this means. I've attempted to re-install mediawiki only to arrive at the same dead end. From what I can tell, something seems to be missing, but I'm no tech guru or anything. Any help on this matter would be much appreciated!*
Thanks, Nick.
When installed, the wiki should had run the sql statement: CREATE INDEX user_time ON logging (log_user, log_timestamp);
to create the user_time index. Even worse, a reinstall should have recreated it if missing. You could try running it manually, but I'm concerned about what other things could be missing.