26 Jul
2012
26 Jul
'12
9:12 a.m.
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