# XF 2.2Update XF 2.2: Member register not working

#### trangchongcheng

##### Member
After upgrade to XF 2.2, Member register feature not working when i register new member, below is error log, how can fix it?
• XF\Db\Exception: MySQL query error [1364]: Field 'brms_limit_cache' doesn't have a default value
• src/XF/Db/AbstractStatement.php:228

Code:
``````INSERT  INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `last_summary_email_date`, `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`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1364, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1364, 'HY000')
#5 src/XF/Mvc/Entity/Entity.php(1242): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Service/User/Registration.php(298): XF\Mvc\Entity\Entity->save()
#7 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#8 src/XF/Pub/Controller/Register.php(422): XF\Service\User\Registration->save()
#9 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#14 src/XF.php(464): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}``````

Solution
It's related to whichever add-on has added the `brms_limit_cache` field to the database.

Re-enable the add-on or set a default value for that field.

Ultimately you will need to get support from the author.

#### Brogan

##### XenForo moderator
Staff member
It's related to whichever add-on has added the `brms_limit_cache` field to the database.

Re-enable the add-on or set a default value for that field.

Ultimately you will need to get support from the author.

#### trangchongcheng

##### Member
It's related to whichever add-on has added the `brms_limit_cache` field to the database.

Re-enable the add-on or set a default value for that field.

Ultimately you will need to get support from the author.
Yeah, i got it.[BR] Modern Statistics addon is the cause of the error.I disabled and working.
Thank support

Replies
2
Views
93
Replies
1
Views
261
Replies
3
Views
87
Replies
3
Views
218
Replies
1
Views
75