• user warning: 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 'DISTINCT(node.nid), node_data_field_dl_titre.field_dl_titre_value AS node_dat' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_data_field_dl_titre.field_dl_titre_value AS node_data_field_dl_titre_field_dl_titre_value, node_data_field_dl_titre.nid AS node_data_field_dl_titre_nid, node.type AS node_type, node_data_field_dl_titre.field_dl_categorie_value AS node_data_field_dl_titre_field_dl_categorie_value, node_data_field_dl_titre.field_dl_description_value AS node_data_field_dl_titre_field_dl_description_value, node_data_field_dl_titre.field_dl_description_format AS node_data_field_dl_titre_field_dl_description_format, node_data_field_dl_fichier.field_dl_fichier_fid AS node_data_field_dl_fichier_field_dl_fichier_fid, node_data_field_dl_fichier.field_dl_fichier_list AS node_data_field_dl_fichier_field_dl_fichier_list, node_data_field_dl_fichier.field_dl_fichier_data AS node_data_field_dl_fichier_field_dl_fichier_data, node_data_field_dl_fichier.nid AS node_data_field_dl_fichier_nid, node_data_field_dl_fichier.delta AS node_data_field_dl_fichier_delta FROM node node LEFT JOIN content_type_dl node_data_field_dl_titre ON node.vid = node_data_field_dl_titre.vid LEFT JOIN content_field_dl_fichier node_data_field_dl_fichier ON node.vid = node_data_field_dl_fichier.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'image_gallery_access'))) AND ( node.type in ('dl') )) count_alias in /homepages/4/d239555385/htdocs/drupal-6.4/sites/all/modules/views/includes/view.inc on line 699.
  • user warning: 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 'DISTINCT(node.nid), node_data_field_dl_titre.field_dl_titre_value AS node_dat' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_data_field_dl_titre.field_dl_titre_value AS node_data_field_dl_titre_field_dl_titre_value, node_data_field_dl_titre.nid AS node_data_field_dl_titre_nid, node.type AS node_type, node_data_field_dl_titre.field_dl_categorie_value AS node_data_field_dl_titre_field_dl_categorie_value, node_data_field_dl_titre.field_dl_description_value AS node_data_field_dl_titre_field_dl_description_value, node_data_field_dl_titre.field_dl_description_format AS node_data_field_dl_titre_field_dl_description_format, node_data_field_dl_fichier.field_dl_fichier_fid AS node_data_field_dl_fichier_field_dl_fichier_fid, node_data_field_dl_fichier.field_dl_fichier_list AS node_data_field_dl_fichier_field_dl_fichier_list, node_data_field_dl_fichier.field_dl_fichier_data AS node_data_field_dl_fichier_field_dl_fichier_data, node_data_field_dl_fichier.nid AS node_data_field_dl_fichier_nid, node_data_field_dl_fichier.delta AS node_data_field_dl_fichier_delta FROM node node LEFT JOIN content_type_dl node_data_field_dl_titre ON node.vid = node_data_field_dl_titre.vid LEFT JOIN content_field_dl_fichier node_data_field_dl_fichier ON node.vid = node_data_field_dl_fichier.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'image_gallery_access'))) AND ( node.type in ('dl') ) LIMIT 0, 10 in /homepages/4/d239555385/htdocs/drupal-6.4/sites/all/modules/views/includes/view.inc on line 725.