Fixed Error on install

[EazyEazy]

Getting the following error when clicking install in the admin panel.

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'category_title' in 'field list' in src/XF/Db/AbstractStatement.php at line 212

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
5. XF\Db\AbstractAdapter->query() in src/addons/XFA/Tournament/Install/Install.php at line 110
6. XFA\Tournament\Install\Install::runStep3() in src/addons/XFA/Tournament/Setup.php at line 41
7. XFA\Tournament\Setup->installStep3() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
8. XFA\Tournament\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
9. XFA\Tournament\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 390
10. XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 249
11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
14. XF\App->run() in src/XF.php at line 328
15. XF::runApp() in admin.php at line 13

Also this in the server error logs

• XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'category_title' in 'field list'
• src/XF/Db/AbstractStatement.php:212
  
  

INSERT INTO `xfa_tourn_category` (`tournament_category_id`, `category_title`, `description`, `display_order`, `breadcrumb_data`, `tournament_count`, `last_update`, `last_tournament_title`, `last_tournament_id`) VALUES
(1, 'Example Category', 'A default category added upon install', 0, '', 0, 0, '', 0)

------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/addons/XFA/Tournament/Install/Install.php(110): XF\Db\AbstractAdapter->query('\n IN...')
#5 src/addons/XFA/Tournament/Setup.php(41): XFA\Tournament\Install\Install::runStep3()
#6 src/XF/AddOn/StepRunnerInstallTrait.php(60): XFA\Tournament\Setup->installStep3(Array)
#7 src/XF/AddOn/StepRunnerInstallTrait.php(27): XFA\Tournament\Setup->installStepRunner(3, Array)
#8 src/XF/Admin/Controller/AddOn.php(390): XFA\Tournament\Setup->install(Array)
#9 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionInstall(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Install', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#11 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#13 src/XF.php(328): XF\App->run()
#14 admin.php(13): XF::runApp('XF\\Admin\\App')
#15 {main}

Request state
array(4) {
["url"] => string(51) "/community/**************?add-ons/XFA-Tournament/install"
["referrer"] => string(78) "http://abso*********************?add-ons/XFA-Tournament/install"
["_GET"] => array(1) {
["add-ons/XFA-Tournament/install"] => string(0) ""
}
["_POST"] => array(7) {
["_xfProcessing"] => string(1) "1"
["continue"] => string(1) "1"
["confirm"] => string(1) "1"
["params"] => string(2) "[]"
["count"] => string(1) "1"
["finished"] => string(1) "0"
["_xfToken"] => string(8) "********"
}
}

 

[Clement]

Open the file src/XFA/Tournament/Install/Install.php.

Search for category_title replace by title.

Clément

 

[EazyEazy]

Open the file src/XFA/Tournament/Install/Install.php.

Search for category_title replace by title.

Clément

Installed fine. Thank you for the update.