Drupal responses "the website encountered an unexpected error.Please try again later" after running db_update statement in my custom module. I always do this without any error. Any suggestion pls!
function mobile_user_form_submit($form, $form_state){
$deposit=$form_state['values']['deposit'];
$status =$form_state['values']['status'];
$id = $form_state['values']['hid'];
drupal_set_message(t($id ." / ". $deposit." / ".$status));
if($id != ""){
db_update('mobile_users')
->fields(array('deposit' => $deposit, 'status' => $status, "updated" => date('Y-m-d H:i:s')))
->condition('id', $id)
->execute();
drupal_set_message(t('successfully saved.'));
}
}
After comment db_update() statement, it is ok no error message show.
Thank you,
------ Solved -------
And I try to update manually that record in mysql, in the field "deposit" I got an error message "Please select a value not more than 127". I found myself I set wrong datatype in deposit field, I was willing to set Integer datatype but I was not awared what I had set I set tinyint. After chaning tinyint to integer, "the website encountered an unexpected error.Please try again later" also removed.
Thanks