MG 2.0 Error on install of Gallery & Resources

[LenKaiser]

I'm trying to install on XF 2.0.10

I'm getting the following errors on installing the Media Gallery 2.0.4:

XF\Db\Exception: MySQL query error [1813]: Tablespace for table '`mydatabase`.`xf_mg_transcode_queue`' exists. Please DISCARD the tablespace before IMPORT. in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 151
XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 164
XF\Db\SchemaManager->createTable() in src/addons/XFMG/Setup.php at line 26
XFMG\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
XFMG\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
XFMG\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 393
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
XF\App->run() in src/XF.php at line 329
XF::runApp() in admin.php at line 13

I get this error on trying to install the Resources Add-On 2.0.3:

XF\Db\Exception: MySQL query error [1813]: Tablespace for table '`mydatabase`.`xf_rm_category_prefix`' exists. Please DISCARD the tablespace before IMPORT. in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 151
XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 164
XF\Db\SchemaManager->createTable() in src/addons/XFRM/Setup.php at line 26
XFRM\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
XFRM\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
XFRM\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 393
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
XF\App->run() in src/XF.php at line 329
XF::runApp() in admin.php at line 13

 

[Chris D]

Those errors would suggest some level of database corruption, such as a previous installation where those tables existed and then weren't cleaned up properly as the tablespace still exists.

The recommendation would be to contact your host in the first instance.

 

[LenKaiser]

Er this is a fresh install I'm putting together a dev area for testing. The database is a fresh one I just created and has not been reused or over written to my knowledge.

 

[Paul B]

Your license doesn't have the Media Gallery add-on so we are unable to provide support.