MySQL - 'field' doesn't have a default value
<p>Im using Laravel framework and it gives an error with the DB</p>

<p>Error message:</p>

<blockquote>
  <p>[2016-04-25 06:07:34] local.ERROR: exception 'PDOException' with
  message 'SQLSTATE[HY000]:  General error: 1364 Field 'remarks' doesn't
  have a default value' in ...</p>
</blockquote>

<p>The field 'remarks' has a default value of 'None' set in PHPMyAdmin. I dont understand why does it gives an error when it has a default value set. I believe that 'None' is a string value so it's not like a NULL value.</p>

<pre><code>$aId = DB::table('attachments')-&gt;insertGetId([ 'document_type_code'=&gt;$document_id, 'report_no'=&gt;'report '.$document_id, 
'file_attachment_link'=&gt;$filepath, 'file_attachment_upload'=&gt;$file-&gt;getClientOriginalName(), 'uploaded_at'=&gt; $now, 'uploaded_by' =&gt; 1, 
//Auth::user()-&gt;id 'version_number' =&gt; 1, ]);
</code></pre>