XF\Db\InvalidQueryException: Batch install error: xf_snog_forms_questions: MySQL statement prepare error [1101]: BLOB, TEXT, GEOMETRY or JSON column 'regex' can't have a default value src/XF/Db/AbstractStatement.php:230
Generated by: Nirjonmela Jan 27, 2024 at 3:28 AM
Stack trace
ALTER TABLE `xf_snog_forms_questions`
MODIFY COLUMN `regex` TEXT NOT NULL DEFAULT ''
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1101, '42000')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1101, '42000')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/Schema/AbstractDdl.php(158): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#5 src/XF/Db/SchemaManager.php(154): XF\Db\Schema\AbstractDdl->apply()
#6 src/XF/Install/InstallHelperTrait.php(677): XF\Db\SchemaManager->alterTable('xf_snog_forms_q...', Object(Closure))
#7 src/addons/Snog/Forms/Setup.php(1073): XF\AddOn\AbstractSetup->alterTable('xf_snog_forms_q...', Object(Closure))
#8 src/XF/AddOn/StepRunnerUpgradeTrait.php(124): Snog\Forms\Setup->upgrade2020172Step1(Array)
#9 src/XF/AddOn/StepRunnerUpgradeTrait.php(73): Snog\Forms\Setup->upgradeStepRunner(2020172, 1, Array, 2020173)
#10 src/XF/Job/AddOnInstallBatch.php(299): Snog\Forms\Setup->upgrade(Array)
#11 src/XF/Job/AddOnInstallBatch.php(91): XF\Job\AddOnInstallBatch->stepAction(Object(XF\Timer))
#12 src/XF/Job/Manager.php(260): XF\Job\AddOnInstallBatch->run(8)
#13 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#14 src/XF/Job/Manager.php(118): XF\Job\Manager->runJobEntry(Array, 8)
#15 src/XF/Admin/Controller/Tools.php(122): XF\Job\Manager->runByIds(Array, 8)
#16 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#17 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(NF\Discord\XF\Admin\Controller\Tools), NULL)
#18 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\Discord\XF\Admin\Controller\Tools), NULL)
#19 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#20 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#21 src/XF.php(524): XF\App->run()
#22 admin.php(13): XF::runApp('XF\\Admin\\App')
#23 {main}
Request state
array(4) {
["url"] => string(24) "/admin.php?tools/run-job"
["referrer"] => string(46) "/admin.php?tools/run-job"
["_GET"] => array(1) {
["tools/run-job"] => string(0) ""
}
["_POST"] => array(3) {
["_xfRedirect"] => string(83) "/admin.php?add-ons/install-from-archive-complete&batch_id=881"
["_xfToken"] => string(8) "********"
["only_ids"] => string(7) "3005611"
}
}