Project

General

Profile

vicidial_manager auto increment on mysql server 5.6

Added by said said almost 8 years ago

Hi,

on mysql 5.6 we cannot set an empty string '' as an autoincrement field. all calls to vicidial_manager (vdc_db_query.php, ... ) have this form to insert :

$stmt="INSERT INTO vicidial_manager values('','','$NOW_TIME','NEW','N','$server_ip','','Hangup','ULGH3459$StarTtime','Channel: $agent_channel','','','','','','','','','');";

it should be :

$stmt="INSERT INTO vicidial_manager(`uniqueid` ,`entry_date` ,`status` ,`response` ,`server_ip`,`channel` ,`action` ,`callerid`,`cmd_line_b` ,`cmd_line_c` ,`cmd_line_d` ,`cmd_line_e` ,`cmd_line_f` , `cmd_line_g` ,`cmd_line_h` , `cmd_line_i` ,`cmdj` , `cmd_line_k`) values('','$NOW_TIME','NEW','N','$server_ip','','Hangup','ULGH3459$StarTtime','Channel: $agent_channel','','','','','','','','','');";

please check

i have tried to set :

set SQL_MODE = ''; but seems not working


Go to top