/individuals/00001276 returned error in code block Individual::viewEntry(). Query : SELECT s.*, s.id AS screeningid, IF(s.variants_found = 1 AND COUNT(s2v.variantid) = 0, -1, COUNT(DISTINCT vog.id)) AS variants_found_, GROUP_CONCAT(DISTINCT s2g.geneid SEPARATOR ", ") AS genes, i.statusid, uo.name AS owned_by_, CONCAT_WS(";", uo.id, uo.name, uo.email, uo.institute, uo.department, IFNULL(uo.countryid, "")) AS _owner FROM lovd_screenings AS s LEFT OUTER JOIN lovd_screenings2variants AS s2v ON (s.id = s2v.screeningid) LEFT OUTER JOIN lovd_variants AS vog ON (s2v.variantid = vog.id AND (vog.statusid >= 7)) LEFT OUTER JOIN lovd_screenings2genes AS s2g ON (s.id = s2g.screeningid) LEFT OUTER JOIN lovd_individuals AS i ON (s.individualid = i.id) LEFT OUTER JOIN lovd_users AS uo ON (s.owned_by = uo.id) WHERE (i.statusid >= 7) AND (s.individualid LIKE ?) GROUP BY s.id ORDER BY s.id ASC Error : Error in PDOStatement::execute() while executing prepared query: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine |