26 Jul
2012
26 Jul
'12
5: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