Hello,
Our wiki site is down and heres the ShowDetails. Please advise. Thanks!
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 `wb_page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1 Function: Article::pageData Error: 1146 Table 'wikidb.wb_page' doesn't exist (localhost) ' in C:\xampp\htdocs\WBWiki\includes\db\Database.php:661 Stack trace: #0 C:\xampp\htdocs\WBWiki\includes\db\Database.php(616): Database->reportQueryError('Table 'wikidb.w...', 1146, 'SELECT page_id...', 'Article::pageDa...', false) #1 C:\xampp\htdocs\WBWiki\includes\db\Database.php(1026): Database->query('SELECT page_id...', 'Article::pageDa...') #2 C:\xampp\htdocs\WBWiki\includes\db\Database.php(1106): Database->select('page', Array, Array, 'Article::pageDa...', Array, Array) #3 C:\xampp\htdocs\WBWiki\includes\Article.php(369): Database->selectRow('page', Array, Array, 'Article::pageDa...') #4 C:\xampp\htdocs\WBWiki\includes\Article.php(381): Article->pageData(Object(DatabaseMysql), Array) #5 C:\xampp\htdocs\WBWiki\includes\Wiki.php(300): Article->pageDataFromTitle(Object(DatabaseMysql), Object(Title)) #6 C:\xampp\htdocs\WBWiki\includes\Wiki.php(60): MediaWiki->initializeArticle(Object(Title), Object(WebRequest)) #7 C:\xampp\htdocs\WBWiki\index.php(116): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest)) #8 {main}
Exception caught inside exception handler: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `wb_objectcache` WHERE keyname='wikidb-wb_:messages:en' Function: MediaWikiBagOStuff::_doquery Error: 1146 Table 'wikidb.wb_objectcache' doesn't exist (localhost) ' in C:\xampp\htdocs\WBWiki\includes\db\Database.php:661 Stack trace: #0 C:\xampp\htdocs\WBWiki\includes\db\Database.php(616): Database->reportQueryError('Table 'wikidb.w...', 1146, 'SELECT value,ex...', 'MediaWikiBagOSt...', false) #1 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(454): Database->query('SELECT value,ex...', 'MediaWikiBagOSt...') #2 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(324): MediaWikiBagOStuff->_doquery('SELECT value,ex...') #3 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(240): SqlBagOStuff->_query('SELECT value,ex...', 'wikidb-wb_:mess...') #4 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(245): SqlBagOStuff->get('wikidb-wb_:mess...') #5 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(589): MessageCache->load('en') #6 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(526): MessageCache->getMsgFromNamespace('Databaseerror', 'en') #7 [internal function]: MessageCache->get('databaseerror', true, false) #8 C:\xampp\htdocs\WBWiki\includes\StubObject.php(58): call_user_func_array(Array, Array) #9 C:\xampp\htdocs\WBWiki\includes\StubObject.php(76): StubObject->_call('get', Array) #10 [internal function]: StubObject->__call('get', Array) #11 C:\xampp\htdocs\WBWiki\includes\GlobalFunctions.php(598): StubObject->get('databaseerror', true, false) #12 C:\xampp\htdocs\WBWiki\includes\GlobalFunctions.php(563): wfMsgGetKey('databaseerror', true, false, true) #13 C:\xampp\htdocs\WBWiki\includes\Exception.php(70): wfMsgReal('databaseerror', Array) #14 C:\xampp\htdocs\WBWiki\includes\db\Database.php(2721): MWException->msg('databaseerror', 'Database error') #15 C:\xampp\htdocs\WBWiki\includes\Exception.php(204): DBQueryError->getPageTitle() #16 C:\xampp\htdocs\WBWiki\includes\Exception.php(167): MWException->htmlHeader() #17 C:\xampp\htdocs\WBWiki\includes\Exception.php(186): MWException->reportHTML() #18 C:\xampp\htdocs\WBWiki\includes\Exception.php(284): MWException->report() #19 C:\xampp\htdocs\WBWiki\includes\Exception.php(344): wfReportException(Object(DBQueryError)) #20 [internal function]: wfExceptionHandler(Object(DBQueryError)) #21 {main}
On 12/29/2010 7:03 PM, Jack Sickels wrote:
Hello,
Our wiki site is down and heres the ShowDetails. Please advise. Thanks!
Did you change your database settings? Did you recently upgrade mediawiki/mysql/etc? What's changed since it was working?
It sounds like Apache was reinstalled by somebody, which may be the root cause of all this. Does that shed any light?
Jack Sickels
Date: Wed, 29 Dec 2010 19:06:49 -0600 From: overlordq@gmail.com To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] FW: Issue with Wiki site and databases?
On 12/29/2010 7:03 PM, Jack Sickels wrote:
Hello,
Our wiki site is down and heres the ShowDetails. Please advise. Thanks!
Did you change your database settings? Did you recently upgrade mediawiki/mysql/etc? What's changed since it was working?
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On first inspection - I think that something went wrong with your database, and its lost some data.
The software can connect to it, but the MediaWiki data doesn't seem to be in it.
Check your MySQL database and see if it got corrupted or dropped data...
On Wed, Dec 29, 2010 at 5:03 PM, Jack Sickels mrsickels@msn.com wrote:
Hello,
Our wiki site is down and heres the ShowDetails. Please advise. Thanks!
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 `wb_page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1 Function: Article::pageData Error: 1146 Table 'wikidb.wb_page' doesn't exist (localhost) ' in C:\xampp\htdocs\WBWiki\includes\db\Database.php:661 Stack trace: #0 C:\xampp\htdocs\WBWiki\includes\db\Database.php(616): Database->reportQueryError('Table 'wikidb.w...', 1146, 'SELECT page_id...', 'Article::pageDa...', false) #1 C:\xampp\htdocs\WBWiki\includes\db\Database.php(1026): Database->query('SELECT page_id...', 'Article::pageDa...') #2 C:\xampp\htdocs\WBWiki\includes\db\Database.php(1106): Database->select('page', Array, Array, 'Article::pageDa...', Array, Array) #3 C:\xampp\htdocs\WBWiki\includes\Article.php(369): Database->selectRow('page', Array, Array, 'Article::pageDa...') #4 C:\xampp\htdocs\WBWiki\includes\Article.php(381): Article->pageData(Object(DatabaseMysql), Array) #5 C:\xampp\htdocs\WBWiki\includes\Wiki.php(300): Article->pageDataFromTitle(Object(DatabaseMysql), Object(Title)) #6 C:\xampp\htdocs\WBWiki\includes\Wiki.php(60): MediaWiki->initializeArticle(Object(Title), Object(WebRequest)) #7 C:\xampp\htdocs\WBWiki\index.php(116): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest)) #8 {main}
Exception caught inside exception handler: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `wb_objectcache` WHERE keyname='wikidb-wb_:messages:en' Function: MediaWikiBagOStuff::_doquery Error: 1146 Table 'wikidb.wb_objectcache' doesn't exist (localhost) ' in C:\xampp\htdocs\WBWiki\includes\db\Database.php:661 Stack trace: #0 C:\xampp\htdocs\WBWiki\includes\db\Database.php(616): Database->reportQueryError('Table 'wikidb.w...', 1146, 'SELECT value,ex...', 'MediaWikiBagOSt...', false) #1 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(454): Database->query('SELECT value,ex...', 'MediaWikiBagOSt...') #2 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(324): MediaWikiBagOStuff->_doquery('SELECT value,ex...') #3 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(240): SqlBagOStuff->_query('SELECT value,ex...', 'wikidb-wb_:mess...') #4 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(245): SqlBagOStuff->get('wikidb-wb_:mess...') #5 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(589): MessageCache->load('en') #6 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(526): MessageCache->getMsgFromNamespace('Databaseerror', 'en') #7 [internal function]: MessageCache->get('databaseerror', true, false) #8 C:\xampp\htdocs\WBWiki\includes\StubObject.php(58): call_user_func_array(Array, Array) #9 C:\xampp\htdocs\WBWiki\includes\StubObject.php(76): StubObject->_call('get', Array) #10 [internal function]: StubObject->__call('get', Array) #11 C:\xampp\htdocs\WBWiki\includes\GlobalFunctions.php(598): StubObject->get('databaseerror', true, false) #12 C:\xampp\htdocs\WBWiki\includes\GlobalFunctions.php(563): wfMsgGetKey('databaseerror', true, false, true) #13 C:\xampp\htdocs\WBWiki\includes\Exception.php(70): wfMsgReal('databaseerror', Array) #14 C:\xampp\htdocs\WBWiki\includes\db\Database.php(2721): MWException->msg('databaseerror', 'Database error') #15 C:\xampp\htdocs\WBWiki\includes\Exception.php(204): DBQueryError->getPageTitle() #16 C:\xampp\htdocs\WBWiki\includes\Exception.php(167): MWException->htmlHeader() #17 C:\xampp\htdocs\WBWiki\includes\Exception.php(186): MWException->reportHTML() #18 C:\xampp\htdocs\WBWiki\includes\Exception.php(284): MWException->report() #19 C:\xampp\htdocs\WBWiki\includes\Exception.php(344): wfReportException(Object(DBQueryError)) #20 [internal function]: wfExceptionHandler(Object(DBQueryError)) #21 {main}
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
It sounds like Apache was reinstalled by somebody, which may be the root cause of all this. Does that shed any light?
Jack Sickels
Date: Wed, 29 Dec 2010 17:07:55 -0800 From: george.herbert@gmail.com To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] FW: Issue with Wiki site and databases?
On first inspection - I think that something went wrong with your database, and its lost some data.
The software can connect to it, but the MediaWiki data doesn't seem to be in it.
Check your MySQL database and see if it got corrupted or dropped data...
On Wed, Dec 29, 2010 at 5:03 PM, Jack Sickels mrsickels@msn.com wrote:
Hello,
Our wiki site is down and heres the ShowDetails. Please advise. Thanks!
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 `wb_page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1 Function: Article::pageData Error: 1146 Table 'wikidb.wb_page' doesn't exist (localhost) ' in C:\xampp\htdocs\WBWiki\includes\db\Database.php:661 Stack trace: #0 C:\xampp\htdocs\WBWiki\includes\db\Database.php(616): Database->reportQueryError('Table 'wikidb.w...', 1146, 'SELECT page_id...', 'Article::pageDa...', false) #1 C:\xampp\htdocs\WBWiki\includes\db\Database.php(1026): Database->query('SELECT page_id...', 'Article::pageDa...') #2 C:\xampp\htdocs\WBWiki\includes\db\Database.php(1106): Database->select('page', Array, Array, 'Article::pageDa...', Array, Array) #3 C:\xampp\htdocs\WBWiki\includes\Article.php(369): Database->selectRow('page', Array, Array, 'Article::pageDa...') #4 C:\xampp\htdocs\WBWiki\includes\Article.php(381): Article->pageData(Object(DatabaseMysql), Array) #5 C:\xampp\htdocs\WBWiki\includes\Wiki.php(300): Article->pageDataFromTitle(Object(DatabaseMysql), Object(Title)) #6 C:\xampp\htdocs\WBWiki\includes\Wiki.php(60): MediaWiki->initializeArticle(Object(Title), Object(WebRequest)) #7 C:\xampp\htdocs\WBWiki\index.php(116): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest)) #8 {main}
Exception caught inside exception handler: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `wb_objectcache` WHERE keyname='wikidb-wb_:messages:en' Function: MediaWikiBagOStuff::_doquery Error: 1146 Table 'wikidb.wb_objectcache' doesn't exist (localhost) ' in C:\xampp\htdocs\WBWiki\includes\db\Database.php:661 Stack trace: #0 C:\xampp\htdocs\WBWiki\includes\db\Database.php(616): Database->reportQueryError('Table 'wikidb.w...', 1146, 'SELECT value,ex...', 'MediaWikiBagOSt...', false) #1 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(454): Database->query('SELECT value,ex...', 'MediaWikiBagOSt...') #2 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(324): MediaWikiBagOStuff->_doquery('SELECT value,ex...') #3 C:\xampp\htdocs\WBWiki\includes\BagOStuff.php(240): SqlBagOStuff->_query('SELECT value,ex...', 'wikidb-wb_:mess...') #4 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(245): SqlBagOStuff->get('wikidb-wb_:mess...') #5 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(589): MessageCache->load('en') #6 C:\xampp\htdocs\WBWiki\includes\MessageCache.php(526): MessageCache->getMsgFromNamespace('Databaseerror', 'en') #7 [internal function]: MessageCache->get('databaseerror', true, false) #8 C:\xampp\htdocs\WBWiki\includes\StubObject.php(58): call_user_func_array(Array, Array) #9 C:\xampp\htdocs\WBWiki\includes\StubObject.php(76): StubObject->_call('get', Array) #10 [internal function]: StubObject->__call('get', Array) #11 C:\xampp\htdocs\WBWiki\includes\GlobalFunctions.php(598): StubObject->get('databaseerror', true, false) #12 C:\xampp\htdocs\WBWiki\includes\GlobalFunctions.php(563): wfMsgGetKey('databaseerror', true, false, true) #13 C:\xampp\htdocs\WBWiki\includes\Exception.php(70): wfMsgReal('databaseerror', Array) #14 C:\xampp\htdocs\WBWiki\includes\db\Database.php(2721): MWException->msg('databaseerror', 'Database error') #15 C:\xampp\htdocs\WBWiki\includes\Exception.php(204): DBQueryError->getPageTitle() #16 C:\xampp\htdocs\WBWiki\includes\Exception.php(167): MWException->htmlHeader() #17 C:\xampp\htdocs\WBWiki\includes\Exception.php(186): MWException->reportHTML() #18 C:\xampp\htdocs\WBWiki\includes\Exception.php(284): MWException->report() #19 C:\xampp\htdocs\WBWiki\includes\Exception.php(344): wfReportException(Object(DBQueryError)) #20 [internal function]: wfExceptionHandler(Object(DBQueryError)) #21 {main}
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
-- -george william herbert george.herbert@gmail.com
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Thu, Dec 30, 2010 at 6:55 PM, Jack Sickels mrsickels@msn.com wrote:
It sounds like Apache was reinstalled by somebody, which may be the root cause of all this. Does that shed any light?
That shouldn't cause tables to vanish. Have you looked at the database? Did someone rename some of the tables, perhaps? Are you using the right database and database prefix?
mediawiki-l@lists.wikimedia.org