-
Type:
Bug
-
Status: Triage
-
Priority:
Minor
-
Resolution: Unresolved
-
Component/s: endpointman
-
Labels:None
I can no longer add phones to OSS Endpoint Manager.
I get the error:
SQLSTATE[HY000]: General error: 1364 Field 'global_custom_cfg_data' doesn't have a default value
SQL Insert statement (from PHP):
$sql = "INSERT INTO `endpointman_mac_list` (`mac`, `model`, `template_id`) VALUES ('" . $mac . "', '" . $model . "', '" . $template . "')";
Table description:
{{mysql> describe endpointman_mac_list;
-----------------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
-----------------------------------------------------------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| mac | varchar(12) | YES | UNI | NULL | |
| model | varchar(11) | NO | NULL | ||
| template_id | int(11) | NO | NULL | ||
| global_custom_cfg_data | longblob | NO | NULL | ||
| global_user_cfg_data | longblob | NO | NULL | ||
| config_files_override | text | NO | NULL | ||
| global_settings_override | longblob | YES | NULL | ||
| specific_settings | longblob | YES | NULL |
-----------------------------------------------------------------+
9 rows in set (0.00 sec)
}}
As you can see the script isn't passing the correct number of arguments to MySQL since global_custom_cfg_data, user_cfg_data, and config_files_override do not have default values but also do not allow NULL.
I don't think I made any configuration changes lately that would have caused this, but I did migrate FreePBX to a new server.