SQL Error: main.sql invalid default value for 'time'
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 N
not that file i guess, remove back what you add, and add at /etc/mysql/mysql.conf.d/mysqld.cnf
add at last line
