Hi,
I am a bit lost here. I have a mediawiki on our IIS. I am now trying to move this to a hosted unix server, but I find it frustrating.
I get too many errors, and I am lost.
I will try to brief:
created a dump of the current db copied all php files and directories (except images for now - too large) to the new server Installed a mysql 4.1 on the server extracted the dump updated localsetting to have the new server, db,username and password.
*I renamed the DB from pmwikidb to optitexpmwiki - however, I don't think that this is the problem, please please , if anyone can help me.
but I get errors trying to run index.php now
please find quoted: QUOTE MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `mw_objectcache` WHERE keyname='OptiTexPmWiki-mw_:messages' Function: MediaWikiBagOStuff::_doquery Error: 1146 Table 'OptiTexPmWiki.mw_objectcache' doesn't exist ( p41mysql161.secureserver.net) ' in /home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php:844 Stack trace: #0 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php(799): Database->reportQueryError('Table 'OptiTexP...', 1146, 'SELECT value,ex...', 'MediaWikiBagOSt...', false) #1 /home/content/o/p/t/optitexftp/html/PmWiki/includes/BagOStuff.php(427): Database->query('SELECT value,ex...', 'MediaWikiBagOSt...') #2 /home/content/o/p/t/optitexftp/html/PmWiki/includes/BagOStuff.php(322): MediaWikiBagOStuff->_doquery('SELECT value,ex...') #3 /home/content/o/p/t/optitexftp/html/PmWiki/includes/BagOStuff.php(243): SqlBagOStuff->_query('SELECT value,ex...', 'OptiTexPmWiki-m...') #4 /home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(214): SqlBagOStuff->get('OptiTexPmWiki-m...') #5 /home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(434): MessageCache->load() #6 [internal function]: MessageCache->get('mainpage', true, true) #7 /home/content/o/p/t/optitexftp/html/PmWiki/includes/StubObject.php(32): call_user_func_array(Array, Array) #8 /home/content/o/p/t/optitexftp/html/PmWiki/includes/StubObject.php(40): StubObject->_call('get', Array) #9 [internal function]: StubObject->__call('get', Array) #10 /home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(427): StubObject->get('mainpage', true, true) #11 /home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(396): wfMsgGetKey('mainpage', true, true, true) #12 /home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(344): wfMsgReal('mainpage', Array, true, true) #13 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Title.php(271): wfMsgForContent('mainpage') #14 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Wiki.php(84): Title::newMainPage() #15 /home/content/o/p/t/optitexftp/html/PmWiki/index.php(59): MediaWiki->checkInitialQueries(NULL, 'view', Object(StubObject), Object(WebRequest), Object(StubContLang)) #16 {main}
Exception caught inside exception handler: exception 'DBUnexpectedError' with message 'Error in fetchObject(): Table 'OptiTexPmWiki.mw_page' doesn't exist (p41mysql161.secureserver.net)' in /home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php:973 Stack trace: #0 /home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(307): Database->fetchObject(false) #1 /home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(244): MessageCache->loadFromDB() #2 /home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(434): MessageCache->load() #3 /home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(427): MessageCache->get('databaseerror', true, false) #4 /home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(396): wfMsgGetKey('databaseerror', true, false, true) #5 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(43): wfMsgReal('databaseerror', Array) #6 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php(292): MWException->msg('databaseerror', 'Database error') #7 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(148): DBQueryError->getPageTitle() #8 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(116): MWException->htmlHeader() #9 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(134): MWException->reportHTML() #10 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(213): MWException->report() #11 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(247): wfReportException(Object(DBQueryError)) #12 [internal function]: wfExceptionHandler(Object(DBQueryError)) #13 {main}
Thank you,
Saar
-------------------------------- Saar Machtinger - CIO
OptiTex Ltd. | www.optitex.com | saar.machtinger@optitex.com Tel: +972-3-904 9979 | Fax: +972-3-904 2710
* Think green before you print
Saar Machtinger wrote:
*I renamed the DB from pmwikidb to optitexpmwiki - however, I don't think
Error: 1146 Table 'OptiTexPmWiki.mw_objectcache' doesn't exist ( p41mysql161.secureserver.net)
First lesson about Unix: names are case-sensitive. "optitexpmwiki" ≠ "OptiTexPmWiki".
mediawiki-l@lists.wikimedia.org