restore a backup I'm getting this error;
Code:
Error at the line 138465: INSERT INTO `setting` (`varname`,`grouptitle`,`value`,`defaultvalue`,`optioncode`,`displayorder`,`advanced`,`volatile`,`datatype`,`product`,`validationcode`,`blacklist`) VALUES ('videodirectory_retrievekeywords','videodirectorytags','1','1','yesno','5','0','1','','videodirectory','','0');
Query: INSERT INTO `setting` (`varname`,`grouptitle`,`value`,`defaultvalue`,`optioncode`,`displayorder`,`advanced`,`volatile`,`datatype`,`product`,`validationcode`,`blacklist`) VALUES ('videodirectory_retrievekeywords','videodirectorytags','1','1','yesno','5','0','1','','videodirectory','','0');
MySQL: Data truncated for column 'datatype' at row 1