---------- Forwarded message ----------
From: Nicholas Washington <washington367(a)gmail.com>
Date: 2011/11/10
Subject: HELP
To: mediawiki-l-owner(a)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.