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

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Sadiq6210

Licensed
Licensed
User Moods Manager
Required Custom Fields On Upgrade
Change Type Resource
Joined
Aug 26, 2019
Messages
61
Reaction score
26
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)

1567460030521.png

Code:
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

Administrator
Staff member
Administrator
Moderator
Licensed
Joined
Jul 8, 2019
Messages
664
Reaction score
279
Hello,

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

Regards, CRUEL-MODZ
 

Sadiq6210

Licensed
Licensed
User Moods Manager
Required Custom Fields On Upgrade
Change Type Resource
Joined
Aug 26, 2019
Messages
61
Reaction score
26
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

Administrator
Staff member
Administrator
Moderator
Licensed
Joined
Jul 8, 2019
Messages
664
Reaction score
279
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
 
Last edited:

Sadiq6210

Licensed
Licensed
User Moods Manager
Required Custom Fields On Upgrade
Change Type Resource
Joined
Aug 26, 2019
Messages
61
Reaction score
26
I reinstalled and the error fixed :) Thanks

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

1567461689021.png

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

CRUEL-MODZ

Administrator
Staff member
Administrator
Moderator
Licensed
Joined
Jul 8, 2019
Messages
664
Reaction score
279
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

Licensed
Licensed
User Moods Manager
Required Custom Fields On Upgrade
Change Type Resource
Joined
Aug 26, 2019
Messages
61
Reaction score
26
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
 
Top Bottom