I'm trying to import the sql-files, but I'm getting errors in the fields related to datetime. I'm using the latest version of rathena.
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_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;
Importing the main.sql above, I get the error: ERROR 1067 (42000) at line 271: Invalid default value for 'time'. This error occur in all files which use datetime.
Question
Johnathan
I'm trying to import the sql-files, but I'm getting errors in the fields related to datetime. I'm using the latest version of rathena.
Importing the main.sql above, I get the error: ERROR 1067 (42000) at line 271: Invalid default value for 'time'. This error occur in all files which use datetime.
Anyone can help me?
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.