Downloading Brand JSON.....Done!
Downloading Brand Package...Done!
Checking MD5sum of Package....Done!
Extracting Tarball........Done!
Appears to be a valid Provisioner.net JSON file.....Continuing
Creating Directory Structure for Brand 'Yealink V70' and Moving Files ................................................................. Done!
Updating Yealink V70 brand data..........
Updating Family Lines.................
FATAL SQL ERROR! ::::: INSERT INTO endpointman_product_list (`id`, `brand`, `short_name`, `long_name`, `cfg_dir`, `cfg_ver`, `config_files`, `hidden`) VALUES ('211', '21', 'Yealink V70 T2X Models: ', 'Yealink V70 T2X Models: [T20, T22, T26, T28]', 't2x', '','y0000000000$suffix.cfg,$mac.cfg,$mac.xml', '0') [nativecode=1364 ** Field 'firmware_vers' doesn't have a default value]SQL -
array(7) {
[0]=>
array(7) {
["file"]=>
string(72) "/var/www/html/admin/modules/endpointman/includes/abstraction/freepbx.inc"
["line"]=>
int(31)
["function"]=>
string(9) "sql_error"
["class"]=>
string(20) "epm_data_abstraction"
["object"]=>
object(epm_data_abstraction)#10 (3) {
["db"]=>
object(freepbx_DB_mysql)#2 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(39) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(12) "asteriskuser"
["password"]=>
string(6) "amp109"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(8) "asterisk"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(8) "asterisk"
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(283) "INSERT INTO endpointman_product_list (`id`, `brand`, `short_name`, `long_name`, `cfg_dir`, `cfg_ver`, `config_files`, `hidden`) VALUES ('211', '21', 'Yealink V70 T2X Models: ', 'Yealink V70 T2X Models: [T20, T22, T26, T28]', 't2x', '','y0000000000$suffix.cfg,$mac.cfg,$mac.xml', '0')"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["amp_conf"]=>
NULL
["global_cfg"]=>
array(25) {
["srvip"]=>
string(14) "110.170.29.103"
["tz"]=>
string(12) "Asia/Bangkok"
["gmtoff"]=>
string(0) ""
["gmthr"]=>
string(0) ""
["config_location"]=>
string(10) "/tftpboot/"
["update_server"]=>
string(41) "http://mirror.freepbx.org/provisioner/v3/"
["version"]=>
string(6) "2.11.7"
["enable_ari"]=>
string(1) "0"
["debug"]=>
string(1) "0"
["arp_location"]=>
string(13) "/usr/sbin/arp"
["nmap_location"]=>
string(4) "nmap"
["asterisk_location"]=>
string(18) "/usr/sbin/asterisk"
["language"]=>
string(0) ""
["check_updates"]=>
string(1) "0"
["disable_htaccess"]=>
string(0) ""
["endpoint_vers"]=>
string(10) "1407058336"
["disable_help"]=>
string(1) "0"
["show_all_registrations"]=>
string(1) "0"
["ntp"]=>
string(0) ""
["server_type"]=>
string(4) "file"
["allow_hdfiles"]=>
string(1) "0"
["tftp_check"]=>
string(1) "0"
["nmap_search"]=>
string(0) ""
["backup_check"]=>
string(1) "0"
["use_repo"]=>
string(1) "0"
}
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
object(DB_Error)#15 (8) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-1)
["message"]=>
string(23) "DB Error: unknown error"
["userinfo"]=>
string(355) "INSERT INTO endpointman_product_list (`id`, `brand`, `short_name`, `long_name`, `cfg_dir`, `cfg_ver`, `config_files`, `hidden`) VALUES ('211', '21', 'Yealink V70 T2X Models: ', 'Yealink V70 T2X Models: [T20, T22, T26, T28]', 't2x', '','y0000000000$suffix.cfg,$mac.cfg,$mac.xml', '0') [nativecode=1364 ** Field 'firmware_vers' doesn't have a default value]"
["backtrace"]=>
array(13) {
[0]=>
array(6) {
["file"]=>
string(22) "/usr/share/pear/DB.php"
["line"]=>
int(966)
["function"]=>
string(10) "PEAR_Error"
["class"]=>
string(10) "PEAR_Error"
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
string(23) "DB Error: unknown error"
[1]=>
int(-1)
[2]=>
int(1)
[3]=>
int(1024)
[4]=>
string(355) "INSERT INTO endpointman_product_list (`id`, `brand`, `short_name`, `long_name`, `cfg_dir`, `cfg_ver`, `config_files`, `hidden`) VALUES ('211', '21', 'Yealink V70 T2X Models: ', 'Yealink V70 T2X Models: [T20, T22, T26, T28]', 't2x', '','y0000000000$suffix.cfg,$mac.cfg,$mac.xml', '0') [nativecode=1364 ** Field 'firmware_vers' doesn't have a default value]"
}
}
[1]=>
array(7) {
["file"]=>
string(24) "/usr/share/pear/PEAR.php"
["line"]=>
int(531)
["function"]=>
string(8) "DB_Error"
["class"]=>
string(8) "DB_Error"
["object"]=>
*RECURSION*
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
int(-1)
[1]=>
int(1)
[2]=>
int(1024)
[3]=>
string(355) "INSERT INTO endpointman_product_list (`id`, `brand`, `short_name`, `long_name`, `cfg_dir`, `cfg_ver`, `config_files`, `hidden`) VALUES ('211', '21', 'Yealink V70 T2X Models: ', 'Yealink V70 T2X Models: [T20, T22, T26, T28]', 't2x', '','y0000000000$suffix.cfg,$mac.cfg,$mac.xml', '0') [nativecode=1364 ** Field 'firmware_vers' doesn't have a default value]"
}
}
[2]=>
array(7) {
["file"]=>
string(29) "/usr/share/pear/DB/common.php"
["line"]=>
int(1908)
["function"]=>
string(10) "raiseError"
["class"]=>
string(4) "PEAR"
["object"]=>
object(freepbx_DB_mysql)#2 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(39) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(12) "asteriskuser"
["password"]=>
string(6) "amp109"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(8) "asterisk"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(8) "asterisk"
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(283) "INSERT INTO endpointman_product_list (`id`, `brand`, `short_name`, `long_name`, `cfg_dir`, `cfg_ver`, `config_files`, `hidden`) VALUES ('211', '21', 'Yealink V70 T2X Models: ', 'Yealink V70 T2X Models: [T20, T22, T26, T28]', 't2x', '','y0000000000$suffix.cfg,$mac.cfg,$mac.xml', '0')"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["type"]=>
string(2) "->"
["args"]=>
array(7) {
[0]=>
NULL
[1]=>
int(-1)
[2]=>
NULL
[3]=>
NULL
[4]=>
string(355) "INSERT INTO endpointman_product_list (`id`, `brand`, `short_name`, `long_name`, `cfg_dir`, `cfg_ver`, `config_files`, `hidden`) VALUES ('211', '21', 'Yealink V70 T2X Models: ', 'Yealink V70 T2X Models: [T20, T22, T26, T28]', 't2x', '','y0000000000$suffix.cfg,$mac.cfg,$mac.xml', '0') [nativecode=1364 ** Field 'firmware_vers' doesn't have a default value]"
[5]=>
string(8) "DB_Error"
[6]=>
Anyone can help me on this MYSQL error pleaseā¦
I am guessing:
Field 'firmware_vers' doesn't have a default value
You have to define firmware_vers