1. TBolley

    TBolley - Dec 28, 2012 New Member

    Credit
    Point
    on create user via acp

    Code:
    Mysqli statement execute error : Incorrect integer value: '' for column 'advanced_rules' at row 1
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591
    XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
    XenForo_DataWriter->save() in XenForo/ControllerAdmin/User.php at line 481
    XenForo_ControllerAdmin_User->actionSave() in XenForo/FrontController.php at line 310
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    XenForo_FrontController->run() in /var/www/xenforo-clear/admin.php at line 13
     
    Loading...
  2. TBolley

    TBolley - Dec 28, 2012 New Member

    Credit
    Point
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect integer value: '' for column 'advanced_rules' at row 1 -library/Zend/Db/Statement/Mysqli.php:214

    Code:
    #0 /var/www/xenforo-clear/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/xenforo-clear/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/xenforo-clear/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /var/www/xenforo-clear/library/XenForo/DataWriter.php(1591): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
    #4 /var/www/xenforo-clear/library/XenForo/DataWriter.php(1580): XenForo_DataWriter->_insert()
    #5 /var/www/xenforo-clear/library/XenForo/DataWriter.php(1381): XenForo_DataWriter->_save()
    #6 /var/www/xenforo-clear/library/XenForo/ControllerAdmin/User.php(481): XenForo_DataWriter->save()
    #7 /var/www/xenforo-clear/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_User->actionSave()
    #8 /var/www/xenforo-clear/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/xenforo-clear/admin.php(13): XenForo_FrontController->run()
    #10 {main}
    Code:
    array(3) {
      ["url"] => string(57) "http://domain.com/xenforo-clear/admin.php?users/0/save"
      ["_GET"] => array(1) {
        ["users/0/save"] => string(0) ""
      }
      ["_POST"] => array(43) {
        ["username"] => string(5) "test1"
        ["email"] => string(0) ""
        ["password"] => string(5) "test1"
        ["user_group_id"] => string(1) "2"
        ["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(8) {
          ["aim"] => string(0) ""
          ["msn"] => string(0) ""
          ["icq"] => string(0) ""
          ["yahoo"] => string(0) ""
          ["skype"] => string(0) ""
          ["gtalk"] => string(0) ""
          ["facebook"] => string(0) ""
          ["twitter"] => string(0) ""
        }
        ["custom_fields_shown"] => array(8) {
          [0] => string(3) "aim"
          [1] => string(3) "msn"
          [2] => string(3) "icq"
          [3] => string(5) "yahoo"
          [4] => string(5) "skype"
          [5] => string(5) "gtalk"
          [6] => string(8) "facebook"
          [7] => string(7) "twitter"
        }
        ["style_id"] => string(1) "0"
        ["language_id"] => string(1) "1"
        ["timezone"] => string(13) "Europe/London"
        ["enable_rte"] => string(1) "1"
        ["content_show_signature"] => string(1) "1"
        ["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(53) "1,1356644783,43baf913d1b45a8b09c58a785fa7018c3d927514"
        ["_xfRequestUri"] => string(34) "/xenforo-clear/admin.php?users/add"
        ["_xfNoRedirect"] => string(1) "1"
        ["_xfResponseType"] => string(4) "json"
      }
    }
     
    #2
  3. TBolley

    TBolley - Dec 28, 2012 New Member

    Credit
    Point
    any fix for this ?
     
    #3
  4. Brivium

    Brivium - Dec 28, 2012 XenForo Services Staff Member

    Credit
    Point
    Please wait few minutes. We will fix that asap
     
    #4
  5. Brivium

    Brivium - Jan 2, 2013 XenForo Services Staff Member

    Credit
    Point
    I think this bug fixed on 1.0.1 version. Please try again
     
    #5
  6. TBolley

    TBolley - Jan 2, 2013 New Member

    Credit
    Point
    whats about friendly urls ? also need some fix
     
    #6