When updating to cxpanel 14.0.2:
In install.php line 417: SQLSTATE[HY000]: General error: 1364 Field 'auto_answer' doesn't have a default value
Doing a 'show create table cxpanel_users' confirms this:
CREATE TABLE `cxpanel_users` (
`cxpanel_user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
`display_name` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
`peer` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
`add_extension` int(11) NOT NULL,
`full` int(11) NOT NULL,
`add_user` int(11) NOT NULL,
`hashed_password` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
`initial_password` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
`auto_answer` int(11) NOT NULL,
`parent_user_id` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
`password_dirty` int(11) NOT NULL,
PRIMARY KEY (`cxpanel_user_id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
This may be a compatibility issue, but I can't find anything that ever said there WAS a default vaule, or, that null was allowed.
After editing install.php to add a default to auto_answer, it's also erroring on password_dirty.