Mailing List Archive

Mediawiki internal error
I am getting a Mediawiki Internal Error message that I don't know how to
resolve. Can someone help? Where is the missing table supposed to reside?

> 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 `page` WHERE page_namespace = '0' AND page_title = 'Main_Page'
> LIMIT 1
> Function: Article::pageData
> Error: 1146 Table 'wikidb.page' doesn't exist (localhost)
> ' in /Library/WebServer/Documents/wiki/includes/Database.php:806
> Stack trace:
> #0 /Library/WebServer/Documents/wiki/includes/Database.php(761):
> Database->reportQueryError('Table 'wikidb.p...', 1146, ' SELECT
> page_i...', 'Article::pageDa...', false)
> #1 /Library/WebServer/Documents/wiki/includes/Database.php(1179):
> Database->query(' SELECT page_i...', 'Article::pageDa...')
> #2 /Library/WebServer/Documents/wiki/includes/Database.php(1198):
> Database->select('page', Array, Array, 'Article::pageDa...', Array)
> #3 /Library/WebServer/Documents/wiki/includes/Article.php(265):
> Database->selectRow('page', Array, Array, 'Article::pageDa...')
> #4 /Library/WebServer/Documents/wiki/includes/Article.php(277):
> Article->pageData(Object(DatabaseMysql), Array)
> #5 /Library/WebServer/Documents/wiki/includes/Wiki.php(254):
> Article->pageDataFromTitle(Object(DatabaseMysql), Object(Title))
> #6 /Library/WebServer/Documents/wiki/includes/Wiki.php(46):
> MediaWiki->initializeArticle(Object(Title), Object(WebRequest))
> #7 /Library/WebServer/Documents/wiki/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
> 'wikidb.page' doesn't exist (localhost)' in
> /Library/WebServer/Documents/wiki/includes/Database.php:929
> Stack trace:
> #0 /Library/WebServer/Documents/wiki/includes/MessageCache.php(313):
> Database->fetchObject(false)
> #1 /Library/WebServer/Documents/wiki/includes/MessageCache.php(250):
> MessageCache->loadFromDB()
> #2 /Library/WebServer/Documents/wiki/includes/MessageCache.php(440):
> MessageCache->load()
> #3
> /Library/WebServer/Documents/wiki/includes/GlobalFunctions.php(463):
> MessageCache->get('databaseerror', true, false)
> #4
> /Library/WebServer/Documents/wiki/includes/GlobalFunctions.php(421):
> wfMsgGetKey('databaseerror', true, false, true)
> #5 /Library/WebServer/Documents/wiki/includes/Exception.php(23):
> wfMsgReal('databaseerror', Array)
> #6 /Library/WebServer/Documents/wiki/includes/Database.php(276):
> MWException->msg('databaseerror', 'Database error')
> #7 /Library/WebServer/Documents/wiki/includes/Exception.php(125):
> DBQueryError->getPageTitle()
> #8 /Library/WebServer/Documents/wiki/includes/Exception.php(88):
> MWException->htmlHeader()
> #9 /Library/WebServer/Documents/wiki/includes/Exception.php(111):
> MWException->reportHTML()
> #10 /Library/WebServer/Documents/wiki/includes/Exception.php(191):
> MWException->report()
> #11 /Library/WebServer/Documents/wiki/includes/Exception.php(225):
> wfReportException(Object(DBQueryError))
> #12 [internal function]: wfExceptionHandler(Object(DBQueryError))
> #13 {main}
bobj

--
--------------------------------
Dr Bob Jansen
Turtle Lane Studios Pty Ltd
PO Box 26, Erskineville NSW 2043, Australia
Ph: +61-414 297 448
Resume: http://au.linkedin.com/in/bobjan
Skype: bobjtls
http://www.turtlelane.com.au

In line with the Australian anti-spam legislation, if you wish to receive no further email from me, please send me an email with the subject "No Spam"


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Re: Mediawiki internal error [ In reply to ]
On Tue, Oct 4, 2011 at 6:38 PM, Dr Bob Jansen
<bob.jansen@turtlelane.com.au>wrote:

> I am getting a Mediawiki Internal Error message that I don't know how to
> resolve. Can someone help? Where is the missing table supposed to reside?
>
> > Error: 1146 Table 'wikidb.page' doesn't exist (localhost)
>

Likely possibilities:
* your database tables have a prefix on their names ('mw_' + 'page' ->
'mw_page'), but you've lost the $wgDBprefix setting from your
LocalSettings.php
* your database is actually empty
* your database looks like it's empty because your MySQL setup is hosed (for
instance, something disabling InnoDB causing all InnoDB-based tables to
disappear)

-- brion
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Re: MediaWiki internal error [ In reply to ]
For info

Problem resolved by doing an SQL row delete of the page ID and running
'deleteOrphanedRevisions.php'

On 13/01/2020 11:50, Peter Presland wrote:
> The error and backtrace shown below is thrown when trying to load the
> system page 'Mediawiki:Sitenotice'. It is the result of a system upgrade
> duringĀ  which the database was edited AFTER the database had been
> updated, but BEFORE the new Mediawiki version installation scripts had
> been installed. Since it was the only page affected, we have lived with
> it through several further upgrades . However, it is becoming a pain not
> to able to use sitenotice so I would like (try??) to fix it.
>
> Any suggestions as to how I should go about this, since the page itself
> can be neither edited, deleted or restored to an earlier version through
> the Mediwiki user interface itself? Is there a maintenance script for
> example that might do the trick? or am I faced with manual database editing?
>
> Any suggestions / advice would be much appreciated
>
> Peter Presland
>
> MediaWiki internal error.
>
> Original exception: [XhxQLsGV-@FwxVwKJWJu8wAAAA8]
> /wiki/MediaWiki:Sitenotice MediaWiki\Revision\RevisionAccessException
> from line 1643 of /var/www/html/w/includes/Revision/RevisionStore.php:
> Main slot of revision 163209 not found in database!
> Backtrace:
> #0 /var/www/html/w/includes/Revision/RevisionStore.php(1680):
> MediaWiki\Revision\RevisionStore->loadSlotRecords(string, integer)
> #1 [internal function]:
> MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}()
> #2 /var/www/html/w/includes/Revision/RevisionSlots.php(165):
> call_user_func(Closure)
> #3 /var/www/html/w/includes/Revision/RevisionSlots.php(107):
> MediaWiki\Revision\RevisionSlots->getSlots()
> #4 /var/www/html/w/includes/Revision/RevisionRecord.php(192):
> MediaWiki\Revision\RevisionSlots->getSlot(string)
> #5 /var/www/html/w/includes/Revision.php(689):
> MediaWiki\Revision\RevisionRecord->getSlot(string, integer)
> #6 /var/www/html/w/includes/Revision.php(956): Revision->getMainSlotRaw()
> #7 /var/www/html/w/includes/page/WikiPage.php(659):
> Revision->getContentModel()
> #8 /var/www/html/w/includes/libs/objectcache/WANObjectCache.php(1414):
> WikiPage->{closure}(boolean, integer, array, NULL)
> #9 /var/www/html/w/includes/libs/objectcache/WANObjectCache.php(1275):
> WANObjectCache->doGetWithSetCallback(string, integer, Closure, array)
> #10 /var/www/html/w/includes/page/WikiPage.php(665):
> WANObjectCache->getWithSetCallback(string, integer, Closure)
> #11 /var/www/html/w/includes/page/WikiPage.php(287):
> WikiPage->getContentModel()
> #12 /var/www/html/w/includes/page/WikiPage.php(274):
> WikiPage->getContentHandler()
> #13 /var/www/html/w/includes/actions/Action.php(98):
> WikiPage->getActionOverrides()
> #14 /var/www/html/w/includes/actions/Action.php(155):
> Action::factory(string, WikiPage, RequestContext)
> #15 /var/www/html/w/includes/MediaWiki.php(155):
> Action::getActionName(RequestContext)
> #16 /var/www/html/w/includes/MediaWiki.php(782): MediaWiki->getAction()
> #17 /var/www/html/w/includes/MediaWiki.php(515): MediaWiki->main()
> #18 /var/www/html/w/index.php(42): MediaWiki->run()
> #19 {main}
>
>
>
> _______________________________________________
> MediaWiki-l mailing list
> To unsubscribe, go to:
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l