Thread:Project:Support desk/Need to migrate a mediawiki MySql database from a server to an other.../reply (5)

After my host migrated our wiki to a new server I started getting that error message. Nothing was changed to my knowledge - except that slightly newer version of PHP was on the new server. I've browsed through the databases and don't see any missing tables.

I added the ShowException script above, and the following is shown. Is there anything below that gives a clue to the problem?

MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT * FROM `jcreatio_live`.`user` WHERE user_id = '2' LIMIT 1 Function: User::loadFromDatabase Error: 1142 SELECT command denied to user 'jcreatio_live'@'localhost' for table 'user' (localhost) ' in /home/jcreatio/public_html/includes/db/Database.php:576 Stack trace:
 * 1) 0 /home/jcreatio/public_html/includes/db/Database.php(538): DatabaseBase->reportQueryError('SELECT command ...', 1142, 'SELECT * FROM...', 'User::loadFromD...', false)
 * 2) 1 /home/jcreatio/public_html/includes/db/Database.php(874): DatabaseBase->query('SELECT * FROM...', 'User::loadFromD...')
 * 3) 2 /home/jcreatio/public_html/includes/db/Database.php(954): DatabaseBase->select('user', '*', Array, 'User::loadFromD...', Array, Array)
 * 4) 3 /home/jcreatio/public_html/includes/User.php(955): DatabaseBase->selectRow('user', '*', Array, 'User::loadFromD...')
 * 5) 4 /home/jcreatio/public_html/includes/User.php(297): User->loadFromDatabase
 * 6) 5 /home/jcreatio/public_html/includes/User.php(901): User->loadFromId
 * 7) 6 /home/jcreatio/public_html/includes/User.php(265): User->loadFromSession
 * 8) 7 /home/jcreatio/public_html/includes/User.php(1505): User->load
 * 9) 8 [internal function]: User->getId
 * 10) 9 /home/jcreatio/public_html/includes/StubObject.php(58): call_user_func_array(Array, Array)
 * 11) 10 /home/jcreatio/public_html/includes/StubObject.php(182): StubObject->_call('getId', Array)
 * 12) 11 /home/jcreatio/public_html/extensions/ConfirmAccount/SpecialConfirmAccount.php(131): StubUser->__call('getId', Array)
 * 13) 12 /home/jcreatio/public_html/extensions/ConfirmAccount/SpecialConfirmAccount.php(131): StubUser->getId
 * 14) 13 [internal function]: efLoadConfirmAccount
 * 15) 14 /home/jcreatio/public_html/includes/Setup.php(370): call_user_func('efLoadConfirmAc...')
 * 16) 15 /home/jcreatio/public_html/includes/WebStart.php(132): require_once('/home/jcreatio/...')
 * 17) 16 /home/jcreatio/public_html/index.php(42): require_once('/home/jcreatio/...')
 * 18) 17 {main}

Exception caught inside exception handler: exception 'DBUnexpectedError' with message 'Error in fetchObject: SELECT command denied to user 'jcreatio_live'@'localhost' for table 'user_properties' (localhost)' in /home/jcreatio/public_html/includes/db/DatabaseMysql.php:159 Stack trace:
 * 1) 0 /home/jcreatio/public_html/includes/User.php(3637): DatabaseMysql->fetchObject(false)
 * 2) 1 /home/jcreatio/public_html/includes/User.php(1968): User->loadOptions
 * 3) 2 /home/jcreatio/public_html/includes/StubObject.php(150): User->getOption('language')
 * 4) 3 /home/jcreatio/public_html/includes/StubObject.php(103): StubUserLang->_newObject
 * 5) 4 /home/jcreatio/public_html/includes/StubObject.php(57): StubObject->_unstub('getCode', 5)
 * 6) 5 /home/jcreatio/public_html/includes/StubObject.php(145): StubObject->_call('getCode', Array)
 * 7) 6 /home/jcreatio/public_html/includes/GlobalFunctions.php(582): StubUserLang->__call('getCode', Array)
 * 8) 7 /home/jcreatio/public_html/includes/GlobalFunctions.php(582): StubUserLang->getCode
 * 9) 8 /home/jcreatio/public_html/includes/MessageCache.php(506): wfGetLangObj(false)
 * 10) 9 [internal function]: MessageCache->get('databaseerror', true, false)
 * 11) 10 /home/jcreatio/public_html/includes/StubObject.php(58): call_user_func_array(Array, Array)
 * 12) 11 /home/jcreatio/public_html/includes/StubObject.php(76): StubObject->_call('get', Array)
 * 13) 12 /home/jcreatio/public_html/includes/GlobalFunctions.php(742): StubObject->__call('get', Array)
 * 14) 13 /home/jcreatio/public_html/includes/GlobalFunctions.php(742): StubObject->get('databaseerror', true, false)
 * 15) 14 /home/jcreatio/public_html/includes/GlobalFunctions.php(707): wfMsgGetKey('databaseerror', true, false, true)
 * 16) 15 /home/jcreatio/public_html/includes/Exception.php(75): wfMsgReal('databaseerror', Array)
 * 17) 16 /home/jcreatio/public_html/includes/db/Database.php(2731): MWException->msg('databaseerror', 'Database error')
 * 18) 17 /home/jcreatio/public_html/includes/Exception.php(209): DBQueryError->getPageTitle
 * 19) 18 /home/jcreatio/public_html/includes/Exception.php(172): MWException->htmlHeader
 * 20) 19 /home/jcreatio/public_html/includes/Exception.php(191): MWException->reportHTML
 * 21) 20 /home/jcreatio/public_html/includes/Exception.php(289): MWException->report
 * 22) 21 /home/jcreatio/public_html/includes/Exception.php(348): wfReportException(Object(DBQueryError))
 * 23) 22 [internal function]: wfExceptionHandler(Object(DBQueryError))
 * 24) 23 {main}