Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

New Users Can't Register

Discussion in 'AMS Support' started by Younes, Feb 6, 2017.

  1. Younes

    Younes New Member AMS Premium RMS Premium SC Premium UBS Premium

    Hi Bob,
    i upgrade AMS to 1.4.3 now new users can't register

    XF Version 1.5.12

    Server Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'ams_series_count' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, 8 minutes ago
    Stack Trace

    #0 /home/user/domains/domain.com/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
    #1 /home/user/domains/domain.com/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
    #2 /home/user/domains/domain.com/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
    #3 /home/user/domains/domain.com/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #4 /home/user/domains/domain.com/public_html/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
    #5 /home/user/domains/domain.com/public_html/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
    #6 /home/user/domains/domain.com/public_html/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
    #7 /home/user/domains/domain.com/public_html/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
    #8 /home/user/domains/domain.com/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
    #9 /home/user/domains/domain.com/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /home/user/domains/domain.com/public_html/index.php(13): XenForo_FrontController->run()
    #11 {main}

    Request State

    array(3) {
    ["url"] => string(47) "https://www.domain.com/register/register"
    ["_GET"] => array(1) {
    ["/register/register"] => string(0) ""
    ["_POST"] => array(13) {
    ["username"] => string(0) ""
    ["01304d1ef4e053d3aabc5fedef40b21a"] => string(13) "alireza234423"
    ["b69e5410c949dd6c5e2e920afd242a0c"] => string(18) "******@gmail.com"
    ["9aa37423e3eaf40523861072b98144cc"] => string(0) ""
    ["dob_month"] => string(1) "4"
    ["dob_day"] => string(2) "12"
    ["dob_year"] => string(4) "1980"
    ["f902f462004b7c577f594d19f1e7b749"] => string(11) "Asia/Tehran"
    ["recaptcha_challenge_field"] => string(206) "03AHJ_Vus8O_HG1JYW_tu3ac6xKQz1vIsU21UVWg1-222GnhmJGNcuulTsy3oSxyos64ddl49UssvqIHBlRBpYPX5473XbLQKo5br_PcCaJacexinxnno0qHqnd7X2wK3w9p_r-1y025vtO3wSngYt1ylPkV4q2DtT8ZgyVze4KN_2ibxQboxxkbol7HFZ8inZDhEToWdGUkIL"
    ["recaptcha_response_field"] => string(10) "Acomb FRAY"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "2980c7dcf08117a55ewegf3486ba6132cc"
  2. Bob

    Bob Developer Staff Member

    Something doesn't add up here. ams_series_count is a NEW FIELD in AMS 1.5.0. Series functionality was added to AMS 1.5.0 Beta 1, its not even part of AMS 1.4.x

    Since you are an EA license holder, you have access to AMS 1.5.0. Did you upload AMS 1.5.0 package to the server and then upgrade using the AMS 1.4.3 XML file or something?

    Its like you have AMS 1.5.0 files uploaded (which would extend the xf_user table) to an AMS 1.4.3 instance.

    Please upgrade to AMS 1.5.0 RC 1 (and follow the post upgrade steps in the install/upgrade doc in the Zip Archive).
    Younes likes this.
  3. Younes

    Younes New Member AMS Premium RMS Premium SC Premium UBS Premium

    Ops! my bad :D I haven't slept in almost two days :sleep:
    I'm sorry to have bothered you (y)
  4. Bob

    Bob Developer Staff Member

    Its never a BOTHER to ask for help. Get some sleep! :D
    Younes likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.