title: What does the database error "Field X doesn't have a default value" mean?
body: <p>Below is my form and table that I have created for my signup newsletter. When I try to enter a new person into the form I get this message. What do I have to do to fix this problem? </p>
  
  <blockquote>
    <p>**Field 'ip_address' doesn't have a default value
    INSERT INTO <code>member</code> SET join_date = NOW() , <code>first_name</code> = 'John', <code>last_name</code> = 'D',
    <code>email</code> = 'jd@aol.com'</p>
    
    <p>Field 'unsubscribe_date' doesn't have a default value
    INSERT INTO
    <code>member</code> SET join_date = NOW() , <code>first_name</code> = 'John', <code>last_name</code> =
    'D', <code>email</code> = 'jd@aol.com'</p>
    
    <p>Field 'unsubscribe_send_id' doesn't have a default value
    INSERT INTO
    <code>member</code> SET join_date = NOW() , <code>first_name</code> = 'John', <code>last_name</code> =
    'D', <code>email</code> = 'jd@aol.com'**</p>
  </blockquote>
  
  <p>Here's my form:</p>
  
  <p>       </p>
  
  <pre><code>    &lt;table cellpadding="3" width="100%"&gt;
      &lt;tbody&gt;
          &lt;tr&gt;
              &lt;td&gt;Email &lt;span class="required"&gt;*&lt;/span&gt;&lt;/td&gt;
              &lt;td&gt;&lt;input type="text" class="text_input" name="email" value=""&gt;&lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td&gt;First Name &lt;span class="required"&gt;*&lt;/span&gt;&lt;/td&gt;
              &lt;td&gt;&lt;input type="text" class="text_input" name="first_name" value=""&gt;&lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td&gt;Last Name&lt;/td&gt;
              &lt;td&gt;&lt;input type="text" class="text_input" name="last_name" value=""&gt;&lt;/td&gt;
          &lt;/tr&gt;
                      &lt;tr&gt;
              &lt;td&gt;
              Subscribed Communication
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;table&gt;
                                                  &lt;tr&gt;
                              &lt;td&gt;&lt;input type="checkbox" name="group_id[]" value="2" checked&gt;&lt;/td&gt;
                              &lt;td&gt;RaceO'Clock Members&lt;/td&gt;
                          &lt;/tr&gt;
                                                                  &lt;/table&gt;
              &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td colspan="2" align="center"&gt;
                  &lt;input type="submit" name="submit" value="Subscribe!"&gt; &lt;br/&gt;
                  &lt;em&gt;* required fields&lt;/em&gt;
              &lt;/td&gt;
          &lt;/tr&gt;
      &lt;/tbody&gt;
      &lt;/table&gt;
  
  
      &lt;/form&gt;
  </code></pre>
  
  <p>This is my table:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `member` (
    `member_id` int(11) NOT NULL auto_increment,
    `first_name` varchar(255) NOT NULL,
    `last_name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `join_date` date NOT NULL,
    `ip_address` varchar(15) NOT NULL,
    `unsubscribe_date` date NOT NULL,
    `unsubscribe_send_id` int(11) NOT NULL,
    PRIMARY KEY  (`member_id`)
  )  DEFAULT CHARSET=utf8;
  </code></pre>