title: database error invalid values
body: <p>i am getting error in my database. i am encountering invalid default value for <code>timestamp</code>. how can i fix this. </p>
  
  <p>here's my database:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `thread` (
  `id` int(11) NOT NULL,
    `title` varchar(100) NOT NULL,
    `dateCreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `userId` int(11) NOT NULL,
    `timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `categoryId` int(11) NOT NULL,
    `view` int(11) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user`
  --
  
  CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL,
    `fullname` varchar(100) NOT NULL,
    `email` varchar(100) NOT NULL,
    `username` varchar(60) NOT NULL,
    `password` varchar(60) NOT NULL,
    `timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `profileUrl` varchar(200) NOT NULL DEFAULT 'https://mymonas.com/forum/img/nophoto.png',
    `profileBg` varchar(200) NOT NULL,
    `dateCreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `aboutMe` varchar(500) NOT NULL,
    `isModerator` tinyint(4) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
  </code></pre>