Error on creating user via admin.php

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"
  }
}

 

any fix for this ?

 

whats about friendly urls ? also need some fix