error after installation
I am using version 1.17.0 with postgres 9.1.2 after i installed and configured the wiki i tried to go to the wiki and got this message MediaWiki internal error.
Exception caught inside exception handler.
Set $wgShowExceptionDetails = true; at the bottom of LocalSettings.php to show detailed debugging information. so i did what it said and then got this
MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT value,exptime FROM objectcache WHERE keyname = 'mediawiki:messages:en' LIMIT 1 Function: SqlBagOStuff::get Error: 1 ERROR: relation "objectcache" does not exist LINE 1: ...ECT /* SqlBagOStuff::get */ value,exptime FROM objectcach... ^ ' in C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php:781 Stack trace:
- 0 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php(751): DatabaseBase->reportQueryError('ERROR: relatio...', 1, 'SELECT value,e...', 'SqlBagOStuff::g...', false)
- 1 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php(1050): DatabaseBase->query('SELECT value,e...', 'SqlBagOStuff::g...')
- 2 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php(1134): DatabaseBase->select('objectcache', Array, Array, 'SqlBagOStuff::g...', Array, Array)
- 3 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\BagOStuff.php(267): DatabaseBase->selectRow('objectcache', Array, Array, 'SqlBagOStuff::g...')
- 4 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\MessageCache.php(252): SqlBagOStuff->get('mediawiki:messa...')
- 5 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\MessageCache.php(606): MessageCache->load('en')
- 6 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\MessageCache.php(545): MessageCache->getMsgFromNamespace('Mainpage', 'en')
- 7 [internal function]: MessageCache->get('mainpage', true, true)
- 8 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\StubObject.php(58): call_user_func_array(Array, Array)
- 9 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\StubObject.php(76): StubObject->_call('get', Array)
- 10 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\GlobalFunctions.php(781): StubObject->__call('get', Array)
- 11 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\GlobalFunctions.php(781): StubObject->get('mainpage', true, true)
- 12 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\GlobalFunctions.php(744): wfMsgGetKey('mainpage', true, true, true)
- 13 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\GlobalFunctions.php(688): wfMsgReal('mainpage', Array, true, true)
- 14 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Title.php(318): wfMsgForContent('mainpage')
- 15 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Wiki.php(122): Title::newMainPage()
- 16 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\index.php(60): MediaWiki->checkInitialQueries(NULL, 'view')
- 17 {main}
Exception caught inside exception handler: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT lc_value FROM l10n_cache WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1 ERROR: relation "l10n_cache" does not exist LINE 1: ...T /* LCStore_DB::get 127.0.0.1 */ lc_value FROM l10n_cache... ^ ' in C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php:781 Stack trace:
- 0 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php(751): DatabaseBase->reportQueryError('ERROR: relatio...', 1, 'SELECT lc_valu...', 'LCStore_DB::get', false)
- 1 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php(1050): DatabaseBase->query('SELECT lc_valu...', 'LCStore_DB::get')
- 2 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php(1134): DatabaseBase->select('l10n_cache', Array, Array, 'LCStore_DB::get', Array, Array)
- 3 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\LocalisationCache.php(792): DatabaseBase->selectRow('l10n_cache', Array, Array, 'LCStore_DB::get')
- 4 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\LocalisationCache.php(327): LCStore_DB->get('en', 'deps')
- 5 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\LocalisationCache.php(356): LocalisationCache->isExpired('en')
- 6 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\LocalisationCache.php(268): LocalisationCache->initLanguage('en')
- 7 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\LocalisationCache.php(211): LocalisationCache->loadItem('en', 'defaultUserOpti...')
- 8 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\languages\Language.php(471): LocalisationCache->getItem('en', 'defaultUserOpti...')
- 9 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\User.php(1075): Language->getDefaultUserOptionOverrides()
- 10 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\User.php(1980): User::getDefaultOptions()
- 11 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\StubObject.php(150): User->getOption('language')
- 12 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\StubObject.php(103): StubUserLang->_newObject()
- 13 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\StubObject.php(57): StubObject->_unstub('getCode', 5)
- 14 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\StubObject.php(145): StubObject->_call('getCode', Array)
- 15 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\MessageCache.php(525): StubUserLang->__call('getCode', Array)
- 16 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\MessageCache.php(525): StubUserLang->getCode()
- 17 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\GlobalFunctions.php(781): MessageCache->get('databaseerror', true, false)
- 18 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\GlobalFunctions.php(744): wfMsgGetKey('databaseerror', true, false, true)
- 19 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Exception.php(91): wfMsgReal('databaseerror', Array)
- 20 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\db\Database.php(3074): MWException->msg('databaseerror', 'Database error')
- 21 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Exception.php(240): DBQueryError->getPageTitle()
- 22 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Exception.php(199): MWException->htmlHeader()
- 23 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Exception.php(220): MWException->reportHTML()
- 24 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Exception.php(325): MWException->report()
- 25 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediaWiki\includes\Exception.php(393): wfReportException(Object(DBQueryError))
- 26 [internal function]: wfExceptionHandler(Object(DBQueryError))
- 27 {main}
Can you help?
This means that the install did not work properly (Specifically the objectcache table wasn't created - which is used for storing parsed pages if you don't have any other cache available). I guess you could try re-installing. As a general rule mysql gets better tested than postgress sql - you could try using mysql instead maybe.