Owirtifo
commented
1 day ago The table looks like this:
findmefollow | CREATE TABLE `findmefollow` (
`grpnum` varchar(20) NOT NULL,
`strategy` varchar(50) NOT NULL,
`grptime` smallint(6) NOT NULL,
`grppre` varchar(100) DEFAULT NULL,
`grplist` varchar(255) NOT NULL,
`annmsg_id` int(11) DEFAULT NULL,
`postdest` varchar(255) DEFAULT NULL,
`dring` varchar(255) DEFAULT NULL,
`rvolume` varchar(2) DEFAULT NULL,
`remotealert_id` int(11) DEFAULT NULL,
`needsconf` varchar(10) DEFAULT NULL,
`toolate_id` int(11) DEFAULT NULL,
`pre_ring` smallint(6) NOT NULL DEFAULT 0,
`ringing` varchar(80) DEFAULT NULL,
`calendar_enable` tinyint(1) DEFAULT 0,
`calendar_id` varchar(80) DEFAULT '',
`calendar_group_id` varchar(80) DEFAULT '',
`calendar_match` varchar(4) DEFAULT 'yes',
PRIMARY KEY (`grpnum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ciWhen I try to change any of the specified parameters (Ring Strategy, Ring First For etc), the following queries are sent to the database:
INSERT INTO findmefollow (grpnum,strategy) VALUES ('2251','ringall') ON DUPLICATE KEY UPDATE strategy = 'ringall';
INSERT INTO findmefollow (grpnum,pre_ring) VALUES ('2251','1') ON DUPLICATE KEY UPDATE pre_ring = '1';but since the grptime, strategy and grplist fields must have values and the default value is not set for them, and these fields are not specified in the request, the SQLSTATE error[HY000]: General error: 1364 occurs.
A temporary solution can be found in this article: https://database.guide/5-ways-to-fix-error-1364-field-doesnt-have-a-default-value-in-mysql/
I hope the developers will fix this bug in the next versions.
kguptasangoma
FreePBX Version
FreePBX 16
Issue Description
Errors occur when changing the Follow Me settings in the UCP panel:
FreePBX 16.0.40.8
When I try to change any of the specified parameters, an error occurs: There was an error. See the console log for more details
I checked in the database, the default values are for these parameters. Advanced Settings:
Operating Environment
Relevant log output