Question Errors with new update

fixer

fixer

Member
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'secondary_group_ids' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: fixer, A moment ago
Stack Trace
#0 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_team...')
#1 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_team...')
#2 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_team...')
#3 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_team...', Array)
#4 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/DataWriter.php(1654): Zend_Db_Adapter_Abstract->update('xf_team_member_...', Array, 'member_role_id ...')
#5 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/DataWriter.php(1623): XenForo_DataWriter->_update()
#6 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /hsphere/local/home/iiiers/mymilitia.com/library/Nobita/Teams/ControllerAdmin/MemberRole.php(98): XenForo_DataWriter->save()
#8 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(351): Nobita_Teams_ControllerAdmin_MemberRole->actionSave()
#9 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /hsphere/local/home/iiiers/mymilitia.com/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(63) "http://www.mymilitia.com/admin.php?team-member-roles/admin/save"
["_GET"] => array(1) {
["team-member-roles/admin/save"] => string(0) ""
}
["_POST"] => array(10) {
["member_role_id"] => string(5) "admin"
["member_role_title"] => string(7) "Captain"
["secondary_group_ids"] => array(1) {
[0] => string(1) "7"
}
["roles"] => array(3) {
["general"] => array(2) {
["bypassPosting"] => string(1) "1"
["invitePeople"] => string(1) "1"
}
["moderator"] => array(16) {
["removeMember"] => string(1) "1"
["promoteMember"] => string(1) "1"
["acceptDenyMember"] => string(1) "1"
["banMember"] => string(1) "1"
["approveUnapprovePost"] => string(1) "1"
["stickUnstickPost"] => string(1) "1"
["editPostAny"] => string(1) "1"
["deletePostAny"] => string(1) "1"
["editCommentAny"] => string(1) "1"
["deleteCommentAny"] => string(1) "1"
["editEventAny"] => string(1) "1"
["deleteEventAny"] => string(1) "1"
["manageLogo"] => string(1) "1"
["manageCover"] => string(1) "1"
["massAlert"] => string(1) "1"
["updateRules"] => string(1) "1"
}
["forum"] => array(10) {
["editThreadAny"] => string(1) "1"
["deleteThreadAny"] => string(1) "1"
["stickUnstickThread"] => string(1) "1"
["lockUnlockThread"] => string(1) "1"
["approveUnapproveThread"] => string(1) "1"
["undeleteThread"] => string(1) "1"
["editPostAny"] => string(1) "1"
["deletePostAny"] => string(1) "1"
["viewDeletedThread"] => string(1) "1"
["viewModeratedThread"] => string(1) "1"
}
}
["is_staff"] => string(1) "1"
["display_order"] => string(2) "10"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(39) "/admin.php?team-member-roles/admin/edit"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}



-------------


ErrorException: Undefined index: secondary_group_ids - library/Nobita/Teams/ControllerAdmin/MemberRole.php:37
Generated By: fixer, 1 minute ago
Stack Trace
#0 /hsphere/local/home/iiiers/mymilitia.com/library/Nobita/Teams/ControllerAdmin/MemberRole.php(37): XenForo_Application::handlePhpError(8, 'Undefined index...', '/hsphere/local/...', 37, Array)
#1 /hsphere/local/home/iiiers/mymilitia.com/library/Nobita/Teams/ControllerAdmin/MemberRole.php(52): Nobita_Teams_ControllerAdmin_MemberRole->_getAddOrEditResponse(Array)
#2 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(351): Nobita_Teams_ControllerAdmin_MemberRole->actionEdit()
#3 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /hsphere/local/home/iiiers/mymilitia.com/admin.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
["url"] => string(63) "http://www.mymilitia.com/admin.php?team-member-roles/admin/edit"
["_GET"] => array(1) {
["team-member-roles/admin/edit"] => string(0) ""
}
["_POST"] => array(0) {
}
}


---------------
 
I think it happens when i try to set member roles , i started a new user group called , Group Captains and then set my "group leaders" to this user group, but it won't go and keeps erring out...
 
Look like upgrade add-on failed. Just try to re-import XML to fix it.
 
I used the new add on hot fix xml and upgraded twice and i still get the same error when trying to set user group.
 
Error Info
ErrorException: Undefined index: secondary_group_ids - library/Nobita/Teams/ControllerAdmin/MemberRole.php:37
Generated By: fixer, 1 minute ago
Stack Trace
#0 /hsphere/local/home/iiiers/mymilitia.com/library/Nobita/Teams/ControllerAdmin/MemberRole.php(37): XenForo_Application::handlePhpError(8, 'Undefined index...', '/hsphere/local/...', 37, Array)
#1 /hsphere/local/home/iiiers/mymilitia.com/library/Nobita/Teams/ControllerAdmin/MemberRole.php(52): Nobita_Teams_ControllerAdmin_MemberRole->_getAddOrEditResponse(Array)
#2 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(351): Nobita_Teams_ControllerAdmin_MemberRole->actionEdit()
#3 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /hsphere/local/home/iiiers/mymilitia.com/admin.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
["url"] => string(63) "http://www.mymilitia.com/admin.php?team-member-roles/admin/edit"
["_GET"] => array(1) {
["team-member-roles/admin/edit"] => string(0) ""
}
["_POST"] => array(0) {
}
}




-------------

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'secondary_group_ids' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: fixer, 1 minute ago
Stack Trace
#0 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_team...')
#1 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_team...')
#2 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_team...')
#3 /hsphere/local/home/iiiers/mymilitia.com/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_team...', Array)
#4 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/DataWriter.php(1654): Zend_Db_Adapter_Abstract->update('xf_team_member_...', Array, 'member_role_id ...')
#5 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/DataWriter.php(1623): XenForo_DataWriter->_update()
#6 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /hsphere/local/home/iiiers/mymilitia.com/library/Nobita/Teams/ControllerAdmin/MemberRole.php(98): XenForo_DataWriter->save()
#8 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(351): Nobita_Teams_ControllerAdmin_MemberRole->actionSave()
#9 /hsphere/local/home/iiiers/mymilitia.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /hsphere/local/home/iiiers/mymilitia.com/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(63) "http://www.mymilitia.com/admin.php?team-member-roles/admin/save"
["_GET"] => array(1) {
["team-member-roles/admin/save"] => string(0) ""
}
["_POST"] => array(10) {
["member_role_id"] => string(5) "admin"
["member_role_title"] => string(7) "Captain"
["secondary_group_ids"] => array(1) {
[0] => string(1) "7"
}
["roles"] => array(3) {
["general"] => array(2) {
["bypassPosting"] => string(1) "1"
["invitePeople"] => string(1) "1"
}
["moderator"] => array(16) {
["removeMember"] => string(1) "1"
["promoteMember"] => string(1) "1"
["acceptDenyMember"] => string(1) "1"
["banMember"] => string(1) "1"
["approveUnapprovePost"] => string(1) "1"
["stickUnstickPost"] => string(1) "1"
["editPostAny"] => string(1) "1"
["deletePostAny"] => string(1) "1"
["editCommentAny"] => string(1) "1"
["deleteCommentAny"] => string(1) "1"
["editEventAny"] => string(1) "1"
["deleteEventAny"] => string(1) "1"
["manageLogo"] => string(1) "1"
["manageCover"] => string(1) "1"
["massAlert"] => string(1) "1"
["updateRules"] => string(1) "1"
}
["forum"] => array(10) {
["editThreadAny"] => string(1) "1"
["deleteThreadAny"] => string(1) "1"
["stickUnstickThread"] => string(1) "1"
["lockUnlockThread"] => string(1) "1"
["approveUnapproveThread"] => string(1) "1"
["undeleteThread"] => string(1) "1"
["editPostAny"] => string(1) "1"
["deletePostAny"] => string(1) "1"
["viewDeletedThread"] => string(1) "1"
["viewModeratedThread"] => string(1) "1"
}
}
["is_staff"] => string(1) "1"
["display_order"] => string(2) "10"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(39) "/admin.php?team-member-roles/admin/edit"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 
In this case you must manual run the query upgrade.
Code: 
ALTER TABLE xf_team_member_role ADD COLUMN secondary_group_ids varchar(255) default null
 
You must log in or register to reply here.
Back
Top