• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 phpBB import error

Akela

Active member
#1
I keep getting this error when attempting a phpBB import:
Server Error
Mysqli statement execute error :
Error on rename of './database_name/#sql-868_e1c86' to './database_name/xf_import_log' (errno: -1)

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in XenForo/Model/Import.php at line 213 XenForo_Model_Import->resetImportLog() in XenForo/ControllerAdmin/Import.php at line 76 XenForo_ControllerAdmin_Import->actionConfig() in XenForo/FrontController.php at line 310 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132 XenForo_FrontController->run() in /home/username/public_html/folder_name/admin.php at line 13
I am very confused :(
 

Jake Bunce

XenForo moderator
Staff member
#2
I remember you went with MyISAM tables because your server doesn't support InnoDB. You will need to change it here as well:

library/XenForo/Model/Import.php

Code:
	public function resetImportLog()
	{
		$this->_getDb()->query('
			TRUNCATE TABLE xf_import_log
		');
		$this->_getDb()->query('ALTER TABLE xf_import_log ENGINE = InnoDB');
	}
That should fix the error.