Bonjour sous PHP / MYSQL 5.0.45 j'obtiens l'erreur suivante:

« Execution of a query to the database failed - 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 CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT ( DISTINCT ' at line 1 »
Ce que je ne comprends pas c'est que la même requete fonctionne sous PhpMyAdmin lorsque je teste le même ordre sql.


Voici la requete:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, 
GROUP_CONCAT ( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, 
GROUP_CONCAT ( DISTINCT ntv.value SEPARATOR ", " ) 
AS tv_value 
FROM `base1`.`mdx_site_content` sc 
LEFT JOIN ( 
SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `base1`.`mdx_site_tmplvar_contentvalues` tv 
WHERE ( ((tv.value LIKE '%school%')) ) ) 
AS ntv ON sc.id = ntv.contentid 
WHERE ( sc.id IN (63,64,65,66,67,68,69,70,71,72,73,97) AND sc.published=1 AND sc.searchable=1 AND sc.deleted=0 AND sc.type='document' 
AND sc.privateweb=0 ) 
GROUP BY sc.id 
HAVING ( ( (sc.pagetitle LIKE '%school%') OR (sc.longtitle LIKE '%school%') OR (sc.description LIKE '%school%') 
OR (sc.alias LIKE '%school%') OR (sc.introtext LIKE '%school%') OR (sc.menutitle LIKE '%school%') 
OR (sc.content LIKE '%school%') OR (tv_value LIKE '%school%') ) ) 
ORDER BY sc.publishedon,sc.pagetitle
Merci pour votre aide.