SELECT article.*, (select GROUP_CONCAT(categorie.titre SEPARATOR ", ") from article_categorie JOIN categorie on categorie.id = categorie_id WHERE article_id = article.id ORDER BY categorie.titre ) categoriesLibelle, (select COUNT(id) FROM commentaire WHERE article_id = article.id and valide = 1) nbCommentaires from article_categorie JOIN article on article.id = article_categorie.article_id WHERE article_categorie.categorie_id IN (select id from categorie where titre NOT LIKE "CD%") AND publicationDatetime <= "2019-03-22 07:39:31" GROUP BY article.id ORDER BY publicationDatetime DESC
array(3) {
  [0]=>
  string(5) "HY000"
  [1]=>
  int(1)
  [2]=>
  string(62) "Can't create/write to file '/tmp/#sql_2f4_0.MYD' (Errcode: 17)"
}
SELECT article.*, (select GROUP_CONCAT(categorie.titre SEPARATOR ", ") from article_categorie JOIN categorie on categorie.id = categorie_id WHERE article_id = article.id ORDER BY categorie.titre ) categoriesLibelle, (select COUNT(id) FROM commentaire WHERE article_id = article.id and valide = 1) nbCommentaires from article_categorie JOIN article on article.id = article_categorie.article_id WHERE article_categorie.categorie_id IN (select id from categorie where titre NOT LIKE "CD%") AND publicationDatetime <= "2019-03-22 07:39:31" AND footer = 1 GROUP BY article.id ORDER BY publicationDatetime DESC LIMIT 5
array(3) {
  [0]=>
  string(5) "HY000"
  [1]=>
  int(1)
  [2]=>
  string(62) "Can't create/write to file '/tmp/#sql_2f4_0.MYD' (Errcode: 17)"
}
Actualité

Warning: require_once(/var/www/vhosts/gradisca.fr/httpdocs/src/views/web/page/actualite.tpl) [function.require-once]: failed to open stream: Trop de fichiers ouverts dans le système in /var/www/vhosts/gradisca.fr/httpdocs/app/class/TemplateClass.php on line 80

Fatal error: require_once() [function.require]: Failed opening required '/var/www/vhosts/gradisca.fr/httpdocs/src/views/web/page/actualite.tpl' (include_path='.:') in /var/www/vhosts/gradisca.fr/httpdocs/app/class/TemplateClass.php on line 80