Create user upgrade error and create a user error

MasterPiece

MasterPiece

Active member
When i try to create a user upgrade i get this error

Server Error

Mysqli statement execute error : Field 'redirect' doesn't have a default value
  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
  7. XenForo_DataWriter->save() in XenForo/ControllerAdmin/UserUpgrade.php at line 130
  8. XenForo_ControllerAdmin_UserUpgrade->actionSave() in XenForo/FrontController.php at line 310
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  10. XenForo_FrontController->run() in /home/theblazi/public_html/forums/admin.php at line 13
Lately im getting other erros like when i try to create a user via admin pannel they show this
Untitled.png
 
Sort by date Sort by votes
MasterPiece said:
When i try to create a user upgrade i get this error

Server Error

Mysqli statement execute error : Field 'redirect' doesn't have a default value
  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
  7. XenForo_DataWriter->save() in XenForo/ControllerAdmin/UserUpgrade.php at line 130
  8. XenForo_ControllerAdmin_UserUpgrade->actionSave() in XenForo/FrontController.php at line 310
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  10. XenForo_FrontController->run() in /home/theblazi/public_html/forums/admin.php at line 13
Click to expand...

It appears that the xf_user_upgrade table has an additional field called "redirect". That must have been added by an addon. If an addon creates a new field that is not nullable and which has no default value then it can result in this error if you disable the addon because the extended datawriter is no longer in effect.

Figure out which addon that field is from and enable the addon in the Admin CP. That should fix the error. Or contact the author for a proper fix. Or uninstall the addon through the Admin CP if you aren't using it anymore... that should remove the offending field.

Or if you are comfortable with databases then you can remove the offending field yourself using phpmyadmin. Or use phpmyadmin to edit the definition of the field to make it nullable or give it a default value.
 
Upvote 0 Downvote
Figured out the create user. this is now fixed but after all addon disabled exept tms and responsive design which didnt want to disable for some reason i still had the user upgrade error
 
Upvote 0 Downvote
MasterPiece said:
but after all addon disabled exept tms and responsive design which didnt want to disable for some reason i still had the user upgrade error
Click to expand...

I was trying to explain that the cause may be that the associated addon is disabled. Try enabling the addon.

Do you know which addon created the "redirect" field?
 
Upvote 0 Downvote
Jake Bunce said:
I was trying to explain that the cause may be that the associated addon is disabled. Try enabling the addon.

Do you know which addon created the "redirect" field?
Click to expand...
well i will try enabling them one by one and see but maybe one of the add-on need to be completely uninstalled for the error to go away. I'll keep you posted thanks for fast support
 
Upvote 0 Downvote
Having this same error when creating new user upgrade. Disabled all addons and the problem still there.

It was caused by the addon Advanced User Upgrade which has been deleted by the author several years ago. Removing the addon did not remove those 2 fields.
 
Last edited:
Upvote 0 Downvote
Andy.N said:
Having this same error when creating new user upgrade. Disabled all addons and the problem still there.

It was caused by the addon Advanced User Upgrade which has been deleted by the author several years ago. Removing the addon did not remove those 2 fields.
Click to expand...

You can remove them manually yourself from the database.
 
Upvote 0 Downvote
Export the database using phpMyAdmin - select custom and choose structure only.

Open the saved sql file in a text editor.

Search for redirect.

That will show you all the tables which have that column in them.
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

SenseiXS
Not a bug I can't create a user group anymore
Replies
3
Views
709
Paul B
P
BigPete7978
  • Question Question
XF 2.2 Can't Create User Groups Due To Error?
Replies
12
Views
936
DreamNetworks
DreamNetworks
I
  • Question Question
XF 2.1 Can I allow a user to create an new account, and take them to a specific URL?
Replies
1
Views
527
isuttie
I
Mouth
  • Question Question
XF 2.2 Unable to create node, error = Field 'z61_character_min_enable' doesn't have a default value
Replies
2
Views
611
Mouth
Mouth
K
Fixed User Upgrade error after upgrade to 2.0.10
Replies
7
Views
1K
SyTry
SyTry
Back
Top Bottom