Soit vous n'êtes pas connecté à la base,
soit requête non valide : select SQL_SMALL_RESULT id, typedoc from correspondance a left join corversions c on a.id=c.idChild, corcor b where a.id=b.idfils and (a.id=c.idParent or c.idChild is null) and b.idpere='Cor_accueil' and (if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', SUBSTRING_INDEX(fic, '.', -1)))) ,lib) like 'Les%pôles' or if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', SUBSTRING_INDEX(fic, '.', -1)))) ,lib) like 'Les%pôles' or if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', if(shownAsPdf is null, SUBSTRING_INDEX(fic, '.', -1), 'pdf') ))) ,lib) like 'Les%pôles' or if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', if(shownAsPdf is null, SUBSTRING_INDEX(fic, '.', -1), 'pdf') ))) ,lib) like 'Les%pôles') order by char_length(lib) asc
Table 'wwwPortail.corcor' doesn't exist (n°1146)
<textarea style="width:100%;height:95%">Parse error: Expected ")" on line 1
select SQL_SMALL_RESULT id, typedoc from correspondance a left join corversions c on a.id=c.idChild, corcor b where a.id=b.idfils and (a.id=c.idParent or c.idChild is null) and b.idpere='Cor_accueil' and (if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', SUBSTRING_INDEX(fic, '.', -1)))) ,lib) like 'Les%pôles' or if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', SUBSTRING_INDEX(fic, '.', -1)))) ,lib) like 'Les%pôles' or if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', if(shownAsPdf is null, SUBSTRING_INDEX(fic, '.', -1), 'pdf') ))) ,lib) like 'Les%pôles' or if(nom='.', if((SUBSTRING_INDEX(fic, '.', -1) = fic) or (SUBSTRING_INDEX(fic, '.', -1) = 'php'), lib, concat(lib, concat('.', if(shownAsPdf is null, SUBSTRING_INDEX(fic, '.', -1), 'pdf') ))) ,lib) like 'Les%pôles') order by char_length(lib) asc (Sql_Parser.class.php 346)
^ found: "if"
</textarea>