I Cant Install Add-ons

[tracefm]

Hi everyone

I recently upgraded to XenForo version 2.1.9، Now I want to install Add-ons, I will encounter the following error

How to fix this error?

XF\Db\Exception: xf_thread: MySQL query error [1265]: Data truncated for column 'prefix_id' at row 335 in src/XF/Db/AbstractStatement.php at line 228
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 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
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 149
XF\Db\SchemaManager->alterTable() in src/addons/SV/MultiPrefix/Setup.php at line 35
SV\MultiPrefix\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
SV\MultiPrefix\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
SV\MultiPrefix\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 398
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
XF\App->run() in src/XF.php at line 391
XF::runApp() in admin.php at line 13

Also before installation, it was said to use the following command

php cmd.php xf-addon:install SV/MultiPrefix

How can I use this command?

 

[Warfare]

Hi everyone

I recently upgraded to XenForo version 2.1.9، Now I want to install Add-ons, I will encounter the following error

How to fix this error?

XF\Db\Exception: xf_thread: MySQL query error [1265]: Data truncated for column 'prefix_id' at row 335 in src/XF/Db/AbstractStatement.php at line 228
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 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
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 149
XF\Db\SchemaManager->alterTable() in src/addons/SV/MultiPrefix/Setup.php at line 35
SV\MultiPrefix\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
SV\MultiPrefix\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
SV\MultiPrefix\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 398
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
XF\App->run() in src/XF.php at line 391
XF::runApp() in admin.php at line 13

Also before installation, it was said to use the following command

php cmd.php xf-addon:install SV/MultiPrefix

How can I use this command?

tracefm
Are you trying to install the ADD-On by the "archive" option?

 

[tracefm]

no i'm installing from root XenForo directory

 

[Warfare]

so the steps you have done so far are: uploaded the "add-on" folder that was in the upload of the .zip archive to /src/addons/ correct?

 

[tracefm]

Exactly

 

[Warfare]

@tracefm the next step is to import the "xml" file that comes with it. This would all be easier if you navigate to your hosting space, went to /src/config.php and added this: --> $config['enableAddOnArchiveInstaller'] = true; <--- that way you can just one click install addons by the zip file themselves instead of these steps. but for this add on where you are stuck, you need to import the XML file of that add on

 

[tracefm]

@lucius thanks but where can i find xml file and And how do I do that?

 

[Warfare]

@tracefm sorry for the confusion. Addons dont have an xml that is styles. I apologize on that one. so, if you already transferred the addon to the src/addon/ then you need to go back to your acp=>addons and hit install

 

[Warfare]

sorry about the xml, I was in two folders at once