title: Incorrect datetime value Database Error Number: 1292
body: <p><strong>Incorrect datetime value 0000-00-00 00:00:00 +0000 Database Error Number: 1292</strong></p>
  
  <p>Hi Everyone I'm having a problem a with a server upgrade done by my hosting company and I'm trying to understand what is occurring so i can fix the problem</p>
  
  <p>My sever has recently been upgraded to Server version: 5.6.17 and I'm getting errors all over the place saying my datetime value is incorrect?</p>
  
  <p>It seem to be add +0000 to the end of the datetime but I'm not sure why. This used to work perfectly fine on 5.5 but a recent upgrade has affected how my timestamps work</p>
  
  <pre><code>Error Number: 1292
  
  Incorrect datetime value: '2014-04-02 08:49:43 +0000' for column 'created' at row 1
  
  INSERT INTO `activitylog` (`tablename`, `row`, `user_id`, `description`, `action`, `private`,`created`) VALUES ('user', '1', '1', 'People', 'Updated', 0, '2014-04-02 08:49:43 +0000')
  </code></pre>
  
  <p>If I modify this sql query without +0000 it works?</p>
  
  <p>It affects anything that is a type of DATETIME on my table.</p>
  
  <p>Has anyone else had a similar problem and now what the solution is to get this to work. At the moment I'm thing I will have to change all my PHP functions to echo the Date/Time rather than me calling NOW() on the query string</p>