Hello Juha,
it looks like column order a bit changed in my system after using alter table during migrations. That is prefix col is not it its place. Thus this data: (1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,'11#',1,NULL,NULL); should be fixed as: (1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,NULL,'11#',1,NULL);
Antanas NTT
On 2012.07.26 12:12, Juha Heinanen wrote:
Antanas Masevicius writes:
Here is my DB excerpt which i use to reproduce the problem: INSERT INTO `lcr_rule` VALUES (2617960,90,'118','.*',1,1,'.*'); INSERT INTO `lcr_rule_target` VALUES (7771454,90,2617960,1424,0,100); INSERT INTO `lcr_gw` VALUES (1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,'11#',1,NULL,NULL);
when i try the above, last insert gives:
INSERT INTO `lcr_gw` VALUES -> (1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,'11#',1,NULL,NULL); ERROR 1048 (23000): Column 'flags' cannot be null
looks like you have made some mistake in above, because according to the schema, flags column cannot be null.
-- juha
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users