What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Bug Fixed Registration Not Working Now

Cameron Taylor

New Member
Purchased this and installed, now users are unable to register on forum. Says server error when I try to make a test account, whether making it in the ACP or making it as a guest. This is the error in the server error log:

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

    Generated by: Unknown account Feb 28, 2022 at 5:22 AM

Stack trace

INSERT  INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `last_summary_email_date`, `xfa_cui_forced`, `xfa_cui_noanim`, `xfa_cui_params`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `username_date`, `username_date_visible`, `style_id`, `permission_combination_id`, `message_count`, `question_solution_count`, `alerts_unviewed`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `security_lock`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `vote_score`, `custom_title`, `warning_points`, `siropu_rs_referrer_id`, `siropu_rs_referral_count`, `siropu_rs_referral_rewards`, `siropu_rs_referrer_credit`, `xfa_fss_paypal`, `xfa_fss_sales`, `xfa_fss_sales_total`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#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/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1514): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1246): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Service/User/Registration.php(301): XF\Mvc\Entity\Entity->save()
#8 src/XF/Service/ValidateAndSavableTrait.php(42): XF\Service\User\Registration->_save()
#9 src/XF/Pub/Controller/Register.php(423): XF\Service\User\Registration->save()
#10 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#13 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2351): XF\Mvc\Dispatcher->run()
#15 src/XF.php(517): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}

Cameron Taylor

New Member
I unistalled the add-on and was now able to make a test account, so it's something involving this add-on. I also have Liam's global name styling installed, perhaps it's conflicting with it?


New Member
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xfa_cui_forced' in 'field list' src/XF/Db/AbstractStatement.php:230

you're having a database issue, If you see in bold text. there is a missing column.

Cameron Taylor

New Member
This was a fresh install ?

It's a brand new forum. Installed U.IX, then installed XenPorta, Chat, Referral System, etc. I also purchased your Forum Sales add-on, and it's working flawlessly. Everything else is working correctly at the moment. This is the only add-on even creating server errors in the logs. How can I create the "xfa_cui_forced" column? Given that I purchased this add-on too, I'd like to figure out how to get this one functioning. Thanks.
Last edited:


Freaky Coder
Staff member
Oh right I know why...
Do you have data or uninstall/reinstalling will be envisionable ?



Freaky Coder
Staff member
I mean is it ok if I ask you to uninstall and reinstall the version once I have posted a fixed one ?