How to fix this ...???
CREATE TABLE IF NOT EXISTS `E-Inquiry` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`Sender_ID` int(11) unsigned NOT NULL default '0',
`Sender_Name` varchar(30) NOT NULL default '',
`Title` text,
`Message` text,
`Status` tinyint(2) NOT NULL default '0',
`Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply` text,
`Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply_Name` varchar(30) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM
MySQL said:
#1067 - Invalid default value for 'Inquiry_Time'
--------------------------------------------------------------------------------------------------------------
SOLVED
by disabling sql strict mode (NO_ZERO_DATE.)