XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'sv_persistent_alert' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: Unknown account Oct 25, 2019 at 8:39 PM
Stack trace
INSERT INTO `xf_user_option` (`content_show_signature`, `show_dob_year`, `show_dob_date`, `receive_admin_email`, `email_on_conversation`, `push_on_conversation`, `creation_watch_state`, `interaction_watch_state`, `sv_persistent_alert`, `sv_persistent_alert_always`, `user_id`, `is_discouraged`, `alert_optout`, `push_optout`, `use_tfa`, `prefixess_ignored_prefix_ids`, `sv_default_deleted`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------
#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(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_user_option', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Mvc/Entity/Entity.php(1202): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Service/User/Registration.php(279): XF\Mvc\Entity\Entity->save()
#9 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#10 src/XF/Pub/Controller/Register.php(307): XF\Service\User\Registration->save()
#11 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Register->actionConnectedAccountRegister(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'ConnectedAccoun...', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#13 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#14 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#16 src/XF.php(390): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}
Request state
array(4) {
["url"] => string(46) "/register/connected-accounts/facebook/register"
["referrer"] => string(58) "https://domain/register/connected-accounts/facebook/"
["_GET"] => array(1) {
["/register/connected-accounts/facebook/register"] => string(0) ""
}
["_POST"] => array(9) {
["username"] => string(10) "user"
["email"] => string(20) "email@gmail.com"
["accept"] => string(1) "1"
["_xfRedirect"] => string(1) "/"
["timezone"] => string(14) "Asia/Hong_Kong"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(38) "/register/connected-accounts/facebook/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}