HTTP ERROR 500 you have any idea how fix such error???? first time on live server and

localhost db is Europe but server is in USA

i tried import db from localhost to live and getting>>> // any hint of solution???

Error
SQL query:


--
-- Database: `yyy`
--

-- --------------------------------------------------------

--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
`id` int(11) NOT NULL,
`resource_id` int(11) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`action` varchar(255) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said: Documentation

#1067 - Invalid default value for 'created_date'