Solved Error: Cannot change display location to (Required to upgrade)

[Sadiq6210]

Hello,

I upgraded the addon from 2.0.1 to 2.0.2
Now I am facing this error if I try to change the (display location) for any exist custom field to (Required to upgrade). Also, I cannot create new fields with display location (Required to upgrade)

XF\Db\Exception: MySQL query error [1265]: Data truncated for column 'display_group' at row 1 src/XF/Db/AbstractStatement.php:217
Generated by: UOB 3 Sep 2019 at 12:34 AM
Stack trace
INSERT  INTO `xf_user_field` (`display_group`, `display_order`, `field_type`, `field_choices`, `max_length`, `required`, `moderator_editable`, `display_template`, `field_id`, `match_type`, `user_editable`, `match_params`, `xs_rcfou_required`, `show_registration`, `viewable_profile`, `viewable_message`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1265, '01000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1265, '01000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(221): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_user_field', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Mvc/FormAction.php(69): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Mvc/FormAction.php(187): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction))
#8 src/XF/Admin/Controller/AbstractField.php(188): XF\Mvc\FormAction->run()
#9 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\AbstractField->actionSave(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:UserField', 'Save', Object(XF\Mvc\RouteMatch), Object(XwhQihCFPSNPkwLNBTbVZHUAnYc5iRYaWz9em9XyJgwVosLWYX7URUBcField), NULL)
#11 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XwhQihCFPSNPkwLNBTbVZHUAnYc5iRYaWz9em9XyJgwVosLWYX7URUBcField), NULL)
#12 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#14 src/XF.php(390): XF\App->run()
#15 admin.php(13): XF::runApp('XF\\Admin\\App')
#16 {main}
Request state
array(4) {
  ["url"] => string(40) "/forum/admin.php?custom-user-fields/save"
  ["referrer"] => string(56) "/forum/admin.php?custom-user-fields/add"
  ["_GET"] => array(1) {
    ["custom-user-fields/save"] => string(0) ""
  }
  ["_POST"] => array(18) {
    ["field_id"] => string(5) "testt"
    ["title"] => string(7) "rrrrrrr"
    ["description"] => string(7) "bgdfhgf"
    ["display_group"] => string(15) "requiredupgrade"
    ["display_order"] => string(1) "1"
    ["field_type"] => string(7) "textbox"
    ["match_type"] => string(4) "none"
    ["max_length"] => string(1) "0"
    ["field_choice"] => array(1) {
      [0] => string(0) ""
    }
    ["field_choice_text"] => array(1) {
      [0] => string(0) ""
    }
    ["user_editable"] => string(3) "yes"
    ["moderator_editable"] => string(1) "1"
    ["viewable_profile"] => string(1) "1"
    ["display_template"] => string(0) ""
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(39) "/forum/admin.php?custom-user-fields/add"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[CRUEL-MODZ]

Hello,

He must have had an error, could you uninstall it and then reinstall it please ?

Regards, CRUEL-MODZ

 

[Sadiq6210]

Hello,
he must have had an error could uninstall it and then reinstall it please?

It was mentioned I must uninstall it if I upgraded from 2.0.0 only, while I already have 2.0.1 so I did direct upgrade

OK I will try to uninstall it and let you know Thanks

 

[CRUEL-MODZ]

It was mentioned I must uninstall it if I upgraded from 2.0.0 only, while I already have 2.0.1 so I did direct upgrade

OK I will try to uninstall it and let you know Thanks

Hello,

Yes it's all your normal thing it's the duration of the installation that must have had an error, for time I tested the installation (and upgrade on all !) several times

Regards, CRUEL-MODZ

 

[Sadiq6210]

I reinstalled and the error fixed Thanks

Another question, why there are 2 options to select (Required to upgrade)?



I noticed that I must select both of them or the addon will not work.

 

[CRUEL-MODZ]

Hello,

Yes there are two options because when you buy something it asks you for a ta of fields, but all it is not necessarily mandatory it is for this reason that there are two fields, the Admins can propose a field without making it mandatory

Regards, CRUEL-MODZ

 

[Sadiq6210]

Hello,

Yes there are two options because when you buy something it asks you for a ta of fields, but all it is not necessarily mandatory it is for this reason that there are two fields, the Admins can propose a field without making it mandatory

Regards, CRUEL-MODZ

I see, it makes sense Thanks for the great update