[Help please] Getting Error codes when Registering new members

Status
Not open for further replies.
DavidMcCl

DavidMcCl

Registered
Joined
7 year 6 month 30 day
Messages
38
Reaction score
2
Points
8
Age
35
hello im having a issue with this registering members to my site and creating them myself

Error Code​
Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'aupp_completed_tasks' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: DavidMcCl, 6 minutes ago
Before Removing Add-ons​
Code: 
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'aupp_completed_tasks' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: DavidMcCl, 21 minutes ago
Stack Trace

#0 /home/davidmccl2/public_html/site/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/davidmccl2/public_html/site/library/XenForo/ControllerAdmin/User.php(514): XenForo_DataWriter->save()
#7 /home/davidmccl2/public_html/site/library/Brivium/Credits/ControllerAdmin/User.php(7): XenForo_ControllerAdmin_User->actionSave()
#8 /home/davidmccl2/public_html/site/library/Brivium/ReferralCreditSystem/ControllerAdmin/User.php(16): Brivium_Credits_ControllerAdmin_User->actionSave()
#9 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(351): Brivium_ReferralCreditSystem_ControllerAdmin_User->actionSave()
#10 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/davidmccl2/public_html/site/admin.php(13): XenForo_FrontController->run()
#12 {main}

Request State

array(3) {
  ["url"] => string(49) "http://moddinginc.com/site/admin.php?users/0/save"
  ["_GET"] => array(1) {
    ["users/0/save"] => string(0) ""
  }
  ["_POST"] => array(52) {
    ["username"] => string(9) "SmithModz"
    ["email"] => string(14) "[email protected]"
    ["password"] => string(8) "********"
    ["change_password"] => string(8) "********"
    ["user_group_id"] => string(1) "3"
    ["secondary_group_ids"] => array(2) {
      [0] => string(1) "3"
      [1] => string(1) "5"
    }
    ["user_state"] => string(5) "valid"
    ["gender"] => string(0) ""
    ["dob_month"] => string(0) ""
    ["dob_day"] => string(0) ""
    ["dob_year"] => string(0) ""
    ["location"] => string(0) ""
    ["occupation"] => string(0) ""
    ["homepage"] => string(0) ""
    ["about"] => string(0) ""
    ["custom_title"] => string(0) ""
    ["signature"] => string(0) ""
    ["message_count"] => string(1) "0"
    ["like_count"] => string(1) "0"
    ["trophy_points"] => string(1) "0"
    ["referral_remain"] => string(1) "0"
    ["custom_fields"] => array(6) {
      ["aim"] => string(0) ""
      ["icq"] => string(0) ""
      ["yahoo"] => string(0) ""
      ["skype"] => string(0) ""
      ["facebook"] => string(0) ""
      ["twitter"] => string(0) ""
    }
    ["custom_fields_shown"] => array(6) {
      [0] => string(3) "aim"
      [1] => string(3) "icq"
      [2] => string(5) "yahoo"
      [3] => string(5) "skype"
      [4] => string(8) "facebook"
      [5] => string(7) "twitter"
    }
    ["style_id"] => string(1) "0"
    ["language_id"] => string(1) "1"
    ["timezone"] => string(13) "Europe/London"
    ["enable_rte"] => string(1) "1"
    ["enable_flash_uploader"] => string(1) "1"
    ["content_show_signature"] => string(1) "1"
    ["email_on_conversation"] => string(1) "1"
    ["default_watch_state"] => string(11) "watch_email"
    ["visible"] => string(1) "1"
    ["activity_visible"] => string(1) "1"
    ["receive_admin_email"] => string(1) "1"
    ["show_dob_date"] => string(1) "1"
    ["show_dob_year"] => string(1) "1"
    ["allow_view_profile_enable"] => string(1) "1"
    ["allow_view_profile"] => string(8) "everyone"
    ["allow_post_profile_enable"] => string(1) "1"
    ["allow_post_profile"] => string(7) "members"
    ["allow_receive_news_feed_enable"] => string(1) "1"
    ["allow_receive_news_feed"] => string(8) "everyone"
    ["allow_send_personal_conversation_enable"] => string(1) "1"
    ["allow_send_personal_conversation"] => string(7) "members"
    ["allow_view_identities_enable"] => string(1) "1"
    ["allow_view_identities"] => string(8) "everyone"
    ["credits"] => string(1) "0"
    ["brc_points"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(25) "/site/admin.php?users/add"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

After Removing All Addons​
Code: 
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'aupp_completed_tasks' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: DavidMcCl, 17 minutes ago
Stack Trace
#0 /home/davidmccl2/public_html/site/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/davidmccl2/public_html/site/library/XenForo/ControllerAdmin/User.php(514): XenForo_DataWriter->save()
#7 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_User->actionSave()
#8 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/davidmccl2/public_html/site/admin.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(49) "http://moddinginc.com/site/admin.php?users/0/save"
["_GET"] => array(1) {
["users/0/save"] => string(0) ""
}
["_POST"] => array(49) {
["username"] => string(9) "SmithModz"
["email"] => string(14) "[email protected]"
["password"] => string(8) "********"
["change_password"] => string(8) "********"
["user_group_id"] => string(1) "3"
["secondary_group_ids"] => array(2) {
[0] => string(1) "3"
[1] => string(1) "5"
}
["user_state"] => string(5) "valid"
["gender"] => string(0) ""
["dob_month"] => string(0) ""
["dob_day"] => string(0) ""
["dob_year"] => string(0) ""
["location"] => string(0) ""
["occupation"] => string(0) ""
["homepage"] => string(0) ""
["about"] => string(0) ""
["custom_title"] => string(0) ""
["signature"] => string(0) ""
["message_count"] => string(1) "0"
["like_count"] => string(1) "0"
["trophy_points"] => string(1) "0"
["custom_fields"] => array(6) {
["aim"] => string(0) ""
["icq"] => string(0) ""
["yahoo"] => string(0) ""
["skype"] => string(0) ""
["facebook"] => string(0) ""
["twitter"] => string(0) ""
}
["custom_fields_shown"] => array(6) {
[0] => string(3) "aim"
[1] => string(3) "icq"
[2] => string(5) "yahoo"
[3] => string(5) "skype"
[4] => string(8) "facebook"
[5] => string(7) "twitter"
}
["style_id"] => string(1) "0"
["language_id"] => string(1) "1"
["timezone"] => string(13) "Europe/London"
["enable_rte"] => string(1) "1"
["enable_flash_uploader"] => string(1) "1"
["content_show_signature"] => string(1) "1"
["email_on_conversation"] => string(1) "1"
["default_watch_state"] => string(11) "watch_email"
["visible"] => string(1) "1"
["activity_visible"] => string(1) "1"
["receive_admin_email"] => string(1) "1"
["show_dob_date"] => string(1) "1"
["show_dob_year"] => string(1) "1"
["allow_view_profile_enable"] => string(1) "1"
["allow_view_profile"] => string(8) "everyone"
["allow_post_profile_enable"] => string(1) "1"
["allow_post_profile"] => string(7) "members"
["allow_receive_news_feed_enable"] => string(1) "1"
["allow_receive_news_feed"] => string(8) "everyone"
["allow_send_personal_conversation_enable"] => string(1) "1"
["allow_send_personal_conversation"] => string(7) "members"
["allow_view_identities_enable"] => string(1) "1"
["allow_view_identities"] => string(8) "everyone"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(25) "/site/admin.php?users/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

Line 214 of the Mysqli file its saying is wrong
http://prnt.sc/cwwgal

@MiRacLE
@AnimeHaxor
 
M

MiRacLE

DavidMcCl said:
hello im having a issue with this registering members to my site and creating them myself

Error Code​
Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'aupp_completed_tasks' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: DavidMcCl, 6 minutes ago
Before Removing Add-ons​
Code: 
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'aupp_completed_tasks' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: DavidMcCl, 21 minutes ago
Stack Trace

#0 /home/davidmccl2/public_html/site/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/davidmccl2/public_html/site/library/XenForo/ControllerAdmin/User.php(514): XenForo_DataWriter->save()
#7 /home/davidmccl2/public_html/site/library/Brivium/Credits/ControllerAdmin/User.php(7): XenForo_ControllerAdmin_User->actionSave()
#8 /home/davidmccl2/public_html/site/library/Brivium/ReferralCreditSystem/ControllerAdmin/User.php(16): Brivium_Credits_ControllerAdmin_User->actionSave()
#9 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(351): Brivium_ReferralCreditSystem_ControllerAdmin_User->actionSave()
#10 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/davidmccl2/public_html/site/admin.php(13): XenForo_FrontController->run()
#12 {main}

Request State

array(3) {
  ["url"] => string(49) "http://moddinginc.com/site/admin.php?users/0/save"
  ["_GET"] => array(1) {
    ["users/0/save"] => string(0) ""
  }
  ["_POST"] => array(52) {
    ["username"] => string(9) "SmithModz"
    ["email"] => string(14) "[email protected]"
    ["password"] => string(8) "********"
    ["change_password"] => string(8) "********"
    ["user_group_id"] => string(1) "3"
    ["secondary_group_ids"] => array(2) {
      [0] => string(1) "3"
      [1] => string(1) "5"
    }
    ["user_state"] => string(5) "valid"
    ["gender"] => string(0) ""
    ["dob_month"] => string(0) ""
    ["dob_day"] => string(0) ""
    ["dob_year"] => string(0) ""
    ["location"] => string(0) ""
    ["occupation"] => string(0) ""
    ["homepage"] => string(0) ""
    ["about"] => string(0) ""
    ["custom_title"] => string(0) ""
    ["signature"] => string(0) ""
    ["message_count"] => string(1) "0"
    ["like_count"] => string(1) "0"
    ["trophy_points"] => string(1) "0"
    ["referral_remain"] => string(1) "0"
    ["custom_fields"] => array(6) {
      ["aim"] => string(0) ""
      ["icq"] => string(0) ""
      ["yahoo"] => string(0) ""
      ["skype"] => string(0) ""
      ["facebook"] => string(0) ""
      ["twitter"] => string(0) ""
    }
    ["custom_fields_shown"] => array(6) {
      [0] => string(3) "aim"
      [1] => string(3) "icq"
      [2] => string(5) "yahoo"
      [3] => string(5) "skype"
      [4] => string(8) "facebook"
      [5] => string(7) "twitter"
    }
    ["style_id"] => string(1) "0"
    ["language_id"] => string(1) "1"
    ["timezone"] => string(13) "Europe/London"
    ["enable_rte"] => string(1) "1"
    ["enable_flash_uploader"] => string(1) "1"
    ["content_show_signature"] => string(1) "1"
    ["email_on_conversation"] => string(1) "1"
    ["default_watch_state"] => string(11) "watch_email"
    ["visible"] => string(1) "1"
    ["activity_visible"] => string(1) "1"
    ["receive_admin_email"] => string(1) "1"
    ["show_dob_date"] => string(1) "1"
    ["show_dob_year"] => string(1) "1"
    ["allow_view_profile_enable"] => string(1) "1"
    ["allow_view_profile"] => string(8) "everyone"
    ["allow_post_profile_enable"] => string(1) "1"
    ["allow_post_profile"] => string(7) "members"
    ["allow_receive_news_feed_enable"] => string(1) "1"
    ["allow_receive_news_feed"] => string(8) "everyone"
    ["allow_send_personal_conversation_enable"] => string(1) "1"
    ["allow_send_personal_conversation"] => string(7) "members"
    ["allow_view_identities_enable"] => string(1) "1"
    ["allow_view_identities"] => string(8) "everyone"
    ["credits"] => string(1) "0"
    ["brc_points"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(25) "/site/admin.php?users/add"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

After Removing All Addons​
Code: 
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'aupp_completed_tasks' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: DavidMcCl, 17 minutes ago
Stack Trace
#0 /home/davidmccl2/public_html/site/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/davidmccl2/public_html/site/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home/davidmccl2/public_html/site/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/davidmccl2/public_html/site/library/XenForo/ControllerAdmin/User.php(514): XenForo_DataWriter->save()
#7 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_User->actionSave()
#8 /home/davidmccl2/public_html/site/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/davidmccl2/public_html/site/admin.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(49) "http://moddinginc.com/site/admin.php?users/0/save"
["_GET"] => array(1) {
["users/0/save"] => string(0) ""
}
["_POST"] => array(49) {
["username"] => string(9) "SmithModz"
["email"] => string(14) "[email protected]"
["password"] => string(8) "********"
["change_password"] => string(8) "********"
["user_group_id"] => string(1) "3"
["secondary_group_ids"] => array(2) {
[0] => string(1) "3"
[1] => string(1) "5"
}
["user_state"] => string(5) "valid"
["gender"] => string(0) ""
["dob_month"] => string(0) ""
["dob_day"] => string(0) ""
["dob_year"] => string(0) ""
["location"] => string(0) ""
["occupation"] => string(0) ""
["homepage"] => string(0) ""
["about"] => string(0) ""
["custom_title"] => string(0) ""
["signature"] => string(0) ""
["message_count"] => string(1) "0"
["like_count"] => string(1) "0"
["trophy_points"] => string(1) "0"
["custom_fields"] => array(6) {
["aim"] => string(0) ""
["icq"] => string(0) ""
["yahoo"] => string(0) ""
["skype"] => string(0) ""
["facebook"] => string(0) ""
["twitter"] => string(0) ""
}
["custom_fields_shown"] => array(6) {
[0] => string(3) "aim"
[1] => string(3) "icq"
[2] => string(5) "yahoo"
[3] => string(5) "skype"
[4] => string(8) "facebook"
[5] => string(7) "twitter"
}
["style_id"] => string(1) "0"
["language_id"] => string(1) "1"
["timezone"] => string(13) "Europe/London"
["enable_rte"] => string(1) "1"
["enable_flash_uploader"] => string(1) "1"
["content_show_signature"] => string(1) "1"
["email_on_conversation"] => string(1) "1"
["default_watch_state"] => string(11) "watch_email"
["visible"] => string(1) "1"
["activity_visible"] => string(1) "1"
["receive_admin_email"] => string(1) "1"
["show_dob_date"] => string(1) "1"
["show_dob_year"] => string(1) "1"
["allow_view_profile_enable"] => string(1) "1"
["allow_view_profile"] => string(8) "everyone"
["allow_post_profile_enable"] => string(1) "1"
["allow_post_profile"] => string(7) "members"
["allow_receive_news_feed_enable"] => string(1) "1"
["allow_receive_news_feed"] => string(8) "everyone"
["allow_send_personal_conversation_enable"] => string(1) "1"
["allow_send_personal_conversation"] => string(7) "members"
["allow_view_identities_enable"] => string(1) "1"
["allow_view_identities"] => string(8) "everyone"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(25) "/site/admin.php?users/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

Line 214 of the Mysqli file its saying is wrong
http://prnt.sc/cwwgal

@MiRacLE
@AnimeHaxor
Click to expand...
The problem is that you are using apantic plugins if I recall correctly and the plugins of them are buggy + gives errors with user registration and else , you can read this directly on xenforo.com so remove them completely
 
DavidMcCl

DavidMcCl

Registered
Joined
7 year 6 month 30 day
Messages
38
Reaction score
2
Points
8
Age
35
So what do I gotta do to fix the issue?
 
M

MiRacLE

Just uninstall the apantic plugins completely from xenforo and clear the server error logs if they come back again let us know.
 
DavidMcCl

DavidMcCl

Registered
Joined
7 year 6 month 30 day
Messages
38
Reaction score
2
Points
8
Age
35
I removed referral just now was that a apantic plugin?
 

Attachments

  • Screenshot_20161020-224205.png
    Screenshot_20161020-224205.png
    320.6 KB · Views: 31
DavidMcCl

DavidMcCl

Registered
Joined
7 year 6 month 30 day
Messages
38
Reaction score
2
Points
8
Age
35
Thank you again your a life saver I did upload the files to help server but never got to installing the profile progress that's probly my issue
 
DavidMcCl

DavidMcCl

Registered
Joined
7 year 6 month 30 day
Messages
38
Reaction score
2
Points
8
Age
35
Thanks Guys for the help
i removed all the Add-ons and it still gave me the error im now going to try the 1.5.10a install hope that works better

@AnimeHaxor
@MiRacLE
 
Status
Not open for further replies.