DataBase error - Can't open file: './iay/tblvillages.frm' (errno: 24 - Too many open files)
select villagecode, villages from tblvillages where isactive = 'Yes' order by villagesDataBase error - Can't open file: './iay/tblsettingvalue.frm' (errno: 24 - Too many open files)
select tblsettingvalue.settingvalue from tblsettingvalue
left join tblsetting on tblsettingvalue.settingid = tblsetting.settingid
where tblsetting.parameter = 'frontend_pagelength' DataBase error - Can't open file: './iay/tblfamily.frm' (errno: 24 - Too many open files)
Select count(*) from tblfamily where (tblfamily.villagecode = '501010010004') and tblfamily.totscore in('1','2','3','4','5','6','7','8','9','10','11','12','13') and tblfamily.socialgroup in('1','2')DataBase error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13
select familyid, familycode, fathername, headname,totalfamilymember,totscore, tblfamily.landtypeid, tblfamily.socialgroup, tblfamily.villagecode, tblsocialstatus.socialdescinenglish, tblfamilyhindi.headinhindi,tblfamilyhindi.fatherinhindi, tbllandtype.landdescinenglish, tblincome.incomeinenglish from tblfamily
left join tblfamilyhindi on tblfamilyhindi.familyhindiid = tblfamily.familyhindiid
left join tblvillages on tblvillages.villagecode = tblfamily.villagecode
left join tblsocialstatus on tblsocialstatus.socialgroup = tblfamily.socialgroup
left join tbllandtype on tbllandtype.landtypeid = tblfamily.landtypeid
left join tblincome on tblincome.incomecodeid = tblfamily.incomecodeid
where (tblfamily.villagecode = '501010010004') and tblfamily.totscore in('1','2','3','4','5','6','7','8','9','10','11','12','13') and tblfamily.socialgroup in('1','2') Limit 0,