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!

Bug Fixed Registration Not Working Now

Cameron Taylor

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:

Code: 
    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}
 
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?
 
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.
 
Clement said:
This was a fresh install ?
Click to expand...

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:
Oh right I know why...
Do you have data or uninstall/reinstalling will be envisionable ?

Clément
 
I mean is it ok if I ask you to uninstall and reinstall the version once I have posted a fixed one ?
 
You must log in or register to reply here.
Top