[SOLVED][Drupal Errors] User warning: Field doesn't have a default value (PDOException: SQLSTATE[HY000]: General error: 1364)

By webmaster | 18th December 2012 | 1 min read

Many Drupal programmers, Drupal site admins and Drupal site users have encountered errors similar to "PDOException: SQLSTATE[HY000]: General error: 1364 Field 'users' doesn't have a default value: INSERT INTO {node} (vid, type, language, title, uid, status, created, changed, promote, sticky) VALUES ..." in their Drupal site. If you are facing the same situation in your Drupal site then read on to find out the solution.

Check out the solution.

  • The easiest solution would be to use a tool like phpMyAdmin to assign a default value to the field in question.

Hope that helps.

The easiest way to solve a Drupal issue is to hand it to the Drupal experts. We can provide a wide range of Drupal services to help you maintain and manage your Drupal websites. Get in touch with us to know more.