Showing Error while insertion of data in database, Drupal 7
Looks like the issue is related to your mysql table member structure. The member table field x1 doesn't have a default value that means you need to serve a value on every insert,  you can solve this in three ways,


Pass the value in the field array Ex: 'x1' =&gt; "&lt;value here&gt;",
Add a default value / NULL (based on your requirement) through altering your table 



  (ALTER TABLE member CHANGE x1 x1 NOT NULL DEFAULT '') OR (ALTER TABLE member CHANGE x1 x1 NULL)


3.Check your table mode, if the table mode is STRICT change it to SET GLOBAL sql_mode=''; REFERENCE : SQL Mode