Error Code: 1067. Invalid default value for 'time'

[Vuluts 2]

Pa help naman po may problem po ako sa pag execute ng main.sql and logs.sql

 

Base po sa topic na guide ni Patsie ~ http://herc.ws/board/topic/968-guide-how-to-setup-hercules/

 

Nasa step # 27 nako

 

Eto po ung error niya:

 

MAIN.SQL

 

14:58: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

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

 

 

Sana po may maka tulong sakin, hmmm may mali po ba akong nagawa sa previus steps?

Edited March 24, 2016 by Vuluts

[Legend 43]

ano gamit mo? phpmyadmin or mysql?