title: Error 1067: Invalid default value for created_at
body: <p>Im trying to import my sql file backup to my new server, but i receive error:</p>
  
  <p>Error 1067: Invalid default value for created_at</p>
  
  <p>this is my SQL file header:</p>
  
  <pre><code>-- phpMyAdmin SQL Dump
  -- version 4.8.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Generation Time: Nov 07, 2018 at 07:43 AM
  -- Server version: 5.7.24
  -- PHP Version: 7.2.7
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `.....
  </code></pre>
  
  <p>Error:</p>
  
  <p><img src="https://i.gyazo.com/8ba2cf83259f826ef61c661df0ba66e6.png" alt="error"></p>
  
  <p>i added sql_mode line inside the conf file at:
  /etc/mysql/my.cnf</p>
  
  <p><img src="https://i.gyazo.com/f516aed26e36185782264678df18c2f0.png" alt="ddl"></p>
  
  <p>restart mysql and apache2, but still not resolved</p>
  
  <p>any idea please?</p>