Steve Holdoway wrote:
On Fri, 30 May 2008 19:41:39 +1200
Nick Rout <[EMAIL PROTECTED]> wrote:
On Fri, May 30, 2008 at 4:24 PM, Roger Searle <[EMAIL PROTECTED]> wrote:
Steve Holdoway wrote:
Roger's Wiki has a problem
Sorry! This site is experiencing technical difficulties.
Try waiting a few minutes and reloading.
(Can't contact the database server: Access denied for user
'roger'@'localhost' to database 'wiki' (locahlost)
Is this a permission error somewhere?
yes, but not a file permissions error.It is to do with mysql's permissions.
check your mysql permissions.
google gives me this as its first choice on the subject:
http://www.databasejournal.com/features/mysql/article.php/3311731
ok, you need to tell mysql to...
grant all permissions on wiki.* to [EMAIL PROTECTED] identified by 'password';
Hi, having done:
mysql> grant all privileges on wiki.* to [EMAIL PROTECTED] identified by
'password';
Query OK, 0 rows affected (0.03 sec)
Viewing http://localhost/mediawiki/index.php/Main_Page gives the
following - complaining about a non-existent table wiki.Wikipage. So
far I know that there is no reference to "wikipage" in either
LocalSettings.php or in the "wiki" database. Can anyone point out where
I should go from here?
MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database
error has occurred
Query: SELECT
page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len
FROM `Wikipage` WHERE page_namespace = '0' AND page_title = 'Main_Page'
LIMIT 1
Function: Article::pageData
Error: 1146 Table 'wiki.Wikipage' doesn't exist (localhost)
' in /usr/share/mediawiki/includes/Database.php:840
Stack trace:
#0 /usr/share/mediawiki/includes/Database.php(795):
Database->reportQueryError('Table 'wiki.Wik...', 1146, ' SELECT
page_i...', 'Article::pageDa...', false)
#1 /usr/share/mediawiki/includes/Database.php(1240): Database->query('
SELECT page_i...', 'Article::pageDa...')
#2 /usr/share/mediawiki/includes/Database.php(1259):
Database->select('page', Array, Array, 'Article::pageDa...', Array)
#3 /usr/share/mediawiki/includes/Article.php(280):
Database->selectRow('page', Array, Array, 'Article::pageDa...')
#4 /usr/share/mediawiki/includes/Article.php(292):
Article->pageData(Object(DatabaseMysql), Array)
#5 /usr/share/mediawiki/includes/Wiki.php(259):
Article->pageDataFromTitle(Object(DatabaseMysql), Object(Title))
#6 /usr/share/mediawiki/includes/Wiki.php(46):
MediaWiki->initializeArticle(Object(Title), Object(WebRequest))
#7 /usr/share/mediawiki/index.php(89):
MediaWiki->initialize(Object(Title), Object(StubObject), Object(User),
Object(WebRequest))
#8 {main}
Exception caught inside exception handler: exception 'DBUnexpectedError'
with message 'Error in fetchObject(): Table 'wiki.Wikipage' doesn't
exist (localhost)' in /usr/share/mediawiki/includes/Database.php:969
Stack trace:
#0 /usr/share/mediawiki/includes/MessageCache.php(314):
Database->fetchObject(false)
#1 /usr/share/mediawiki/includes/MessageCache.php(251):
MessageCache->loadFromDB()
#2 /usr/share/mediawiki/includes/MessageCache.php(441): MessageCache->load()
#3 /usr/share/mediawiki/includes/GlobalFunctions.php(467):
MessageCache->get('databaseerror', true, false)
#4 /usr/share/mediawiki/includes/GlobalFunctions.php(421):
wfMsgGetKey('databaseerror', true, false, true)
#5 /usr/share/mediawiki/includes/Exception.php(23):
wfMsgReal('databaseerror', Array)
#6 /usr/share/mediawiki/includes/Database.php(292):
MWException->msg('databaseerror', 'Database error')
#7 /usr/share/mediawiki/includes/Exception.php(125):
DBQueryError->getPageTitle()
#8 /usr/share/mediawiki/includes/Exception.php(88):
MWException->htmlHeader()
#9 /usr/share/mediawiki/includes/Exception.php(111):
MWException->reportHTML()
#10 /usr/share/mediawiki/includes/Exception.php(191): MWException->report()
#11 /usr/share/mediawiki/includes/Exception.php(225):
wfReportException(Object(DBQueryError))
#12 [internal function]: wfExceptionHandler(Object(DBQueryError))
#13 {main}
