Running MySQL 5.5, got the error above when I tried to import a .sql file
I've checked the SQL_MODE of my server and nothing similar to 'NO_ZERO_DATE' is found
As well, I've took out the text of 'STRICT_MODE' from my my.ini file and restarted the server, yet this error still persists
Here's the .sql file being imported
CREATE TABLE `street_segment` (
`ID` int(8) NOT NULL,
`PROVINCE_CODE` varchar(2) NOT NULL,
`POSTAL_CODE` varchar(6) NOT NULL,
`MUNICIPALITY_NAME` varchar(30) default NULL,
`STATUS` varchar(16) NOT NULL,
`LAST_UPDATED` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`DIRECTORY_AREA_NAME` varchar(30) default NULL,
`STREET_NAME` varchar(255) default NULL,
`STREET_TYPE_CODE` varchar(6) default NULL,
`STREET_DIRECTION_CODE` varchar(2) default NULL,
`ADDRESS_SEQ_CODE` int(8) default NULL,
`STREET_ADDRESS_FROM_NUMBER` varchar(6) default NULL,
`STREET_ADDRESS_TO_NUMBER` varchar(6) default NULL,
`NUMBER_SUFFIX_FROM` varchar(6) default NULL,
`NUMBER_SUFFIX_TO` varchar(6) default NULL,
`SUITE_NUMBER_FROM` varchar(6) default NULL,
`SUITE_NUMBER_TO` varchar(6) default NULL,
`STREET_NAME_ACCENT_F` int(1) default 0,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;