Isn't there a prefix string in this file as well?? Can't remember, and haven't got the code to hand. Look at the names of the tables that are created, and it they're all prefixed by a string, then update accordingly.
Steve On Fri, 06 Jun 2008 11:15:06 +1200 Roger Searle <[EMAIL PROTECTED]> wrote: > 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} > >
pgpX7d1q3jgaY.pgp
Description: PGP signature
