title: #1292 - Incorrect date value: '0000-00-00'
body: <p>I referenced many questions which have the same title as mine, but they have a different approach and different issue so this question is not a duplicate.</p>
  
  <p>I have a table in which <code>column</code> <code>fm_sctrdate</code> is a <code>date</code> type and has the default value <code>0000-00-00</code>. </p>
  
  <p><a href="https://i.stack.imgur.com/guT7F.png" rel="noreferrer"><img src="https://i.stack.imgur.com/guT7F.png" alt="enter image description here"></a></p>
  
  <p>Insertion by website is working fine but when I try to insert any value by <code>phpmyadmin</code> then I got following error.</p>
  
  <p><a href="https://i.stack.imgur.com/p4wjS.png" rel="noreferrer"><img src="https://i.stack.imgur.com/p4wjS.png" alt="enter image description here"></a></p>
  
  <p><code>Mysql</code> version is <code>5.7.11</code>. One more thing recently our server has been upgrade from <code>mysqlnd 5.0.12</code> to <code>5.7.11</code>.</p>
  
  <p>Here is the query</p>
  
  <pre><code>INSERT INTO `iavlif_fmp_clientquote` (`jm_cqid`, `fmsq_id`, `fmsg_id`, 
  `fm_sctrdate`, `fm_sctrtime`, `fm_sctbaggage_weight`,     
  `fm_sctfreight_weight`, `fm_sctpassenger`, `fm_sctinfant`, 
  `fm_sctinfant_details`, `fm_sctinfant_dob`, `fmtp_id`, `fmtpi_id`,
  `jmcnt_id`, `fm_name`, `fm_company`, `fm_email`, `fm_phone`, `fmts_id`,
  `jmts_id`, `fm_pax_nbr`, `fm_hours_nbr`, `fmqt_id`, `fmtr_id`,
  `fm_sctnotes`, `fm_locdepart`, `fm_locarrive`, `fm_sctconsignment_weight`,
  `fm_sctconsignment_dimensions`, `fm_sctconsignment_desc`, `fm_sctdangerous`,
  `fm_scturgent`, `fm_sctspecial_instructions`, `fm_sctquote_type`,
  `fm_sctwork_type`, `fm_sctreoccuring`, `fm_sctaccommodation`, `fm_sctcar`,
  `fm_recdate`, `fm_recenddate`, `fm_recfrequency`, `fm_rectime`,    
  `fm_medical`, `fm_medical_details`, `fm_user_ip`, `fm_dang_details`,
  `fm_sctsubstance`, `fm_sctpurchase_number`, `fm_role_id`, `fm_myrole_id`,
  `jm_myrole_id`, `fm_sctwork_point`, `fm_locdepartarrive`, `fm_sctnbr`, 
  `fm_dateCreated`, `fm_cc`, `fm_gl`, `fm_timeCreated`, `jm_qtid`, `jmtp_id`,
  `jmtpi_id`, `jmsg_id`, `jms_id`, `jmsq_id`, `fms_id`, `fmcq_id`) VALUES
  (NULL, '1', '1', '0000-00-00', '1', '1', '1', 'sdfasd', 'No',
  'sdafdsafdsaf', 'dsfas', 'sdfasd', 'dsafds', '0', 'asdfds', 'sdfasd',
  'sdfads', 'sdaf', 'sdaf', 'sdaf', '0', '0', '0', '1sadfasdsda', 'sdfadsf',
  'as', 'as', 'as', 'asas', 'asd', 'No', 'No', 'adsfsd', 'eqwrqew', 'qewrqew',
  'No', 'No', 'No', '0000-00-00', '0000-00-00', 'ewqr', 'qewrw', 'No', 'eqwr',
  'ewqr', 'qewr', '', '', '', '', '', '', '', '0', '0000-00-00', '', '',
  '00:00:00.000000', '', '', '', '', '', '', '', NULL)
  </code></pre>
  
  <p>We started facing this issue just after upgrade of <code>mysql</code></p>