Workbench Compilation Problem

[Vuluts]

Greetings,

Would you mind guys help me with my ERRORS, I'm practicing to create a server but when I'm trying to execute my MAIN.SQL and LOGS.SQL in workbench I'm having this errors.

for MAIN.SQL I have this error lines,

15:12:21    CREATE TABLE IF NOT EXISTS `charlog` (   `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',   `char_msg` VARCHAR(255) NOT NULL DEFAULT 'char select',   `account_id` INT(11) NOT NULL DEFAULT '0',   `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `char_num` TINYINT(4) NOT NULL DEFAULT '0',   `name` VARCHAR(23) NOT NULL DEFAULT '',   `str` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `agi` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `vit` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `INT` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `dex` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `luk` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `hair` TINYINT(4) NOT NULL DEFAULT '0',   `hair_color` INT(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM    Error Code: 1067. Invalid default value for 'time'    0.000 sec
 
and for LOGS.SQL
 
15:16:03    CREATE TABLE IF NOT EXISTS `atcommandlog` (   `atcommand_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,   `atcommand_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',   `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',   `char_name` VARCHAR(25) NOT NULL DEFAULT '',   `map` VARCHAR(11) NOT NULL DEFAULT '',   `command` VARCHAR(255) NOT NULL DEFAULT '',   PRIMARY KEY (`atcommand_id`),   INDEX (`account_id`),   INDEX (`char_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1    Error Code: 1067. Invalid default value for 'atcommand_date'    0.016 sec
 

I'm referring with the guide topic posted by Patskie ~ http://herc.ws/board/topic/968-guide-how-to-setup-hercules/

Hoping that someone could help me with my errors

Thank you so much!

 

[bWolfie]

@Vuluts Wondering how you fixed this? I'm trying to install a fresh copy of Hercules on my desktop (installed no problem on my laptop ~6 months ago) and I'm getting these exact errors.

 

[Dastgir]

@Vuluts Wondering how you fixed this? I'm trying to install a fresh copy of Hercules on my desktop (installed no problem on my laptop ~6 months ago) and I'm getting these exact errors.

This might help: http://herc.ws/board/topic/12796-need-help-on-sql/?hl=%2Bstrict+%2Bmode#entry74093