@Emistry just provide the 1st solution. You have to edit main.sql and look for:
CREATE TABLE IF NOT EXISTS `party_bookings` (
`world_name` varchar(32) NOT NULL,
`account_id` int(11) unsigned NOT NULL,
`char_id` int(11) unsigned NOT NULL,
`char_name` varchar(23) NOT NULL,
`purpose` smallint(5) unsigned NOT NULL DEFAULT '0',
`assist` tinyint(3) unsigned NOT NULL DEFAULT '0',
`damagedealer` tinyint(3) unsigned NOT NULL DEFAULT '0',
`healer` tinyint(3) unsigned NOT NULL DEFAULT '0',
`tanker` tinyint(3) unsigned NOT NULL DEFAULT '0',
`minimum_level` smallint(5) unsigned NOT NULL,
`maximum_level` smallint(5) unsigned NOT NULL,
`comment` varchar(255) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`world_name`, `account_id`, `char_id`)
) ENGINE=MyISAM;
Replace CURRENT_TIMESTAMP to this:
'0000-00-00 00:00:00'
And it will be like this:
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
Solved.
Or you can use 2nd solution from @chatterboy which will be like this.
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
datetime to timestamp. Solved. Both methods are working just fine.
If you're using CentOS 7, the problem persists, and the above method will solve the issue. There is no issue with Debian for now.
