Resource id #34: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'assurance')
AND pub_etat IN ('ENLIGNE','EDITION')
AND pub_da' at line 9
SELECT publication.*, DATE_FORMAT(pub_date,'%d/%m/%Y') pub_date, publication_data.*,
DATE_FORMAT(pub_datecrea,'%d/%m/%Y %H:%i:%s') pub_datecrea, pub_datecrea as pub_datecreatri,
DATE_FORMAT(pub_datemaj,'%d/%m/%Y %H:%i:%s') pub_datemaj, pub_datemaj as pub_datemajtri,
pub_date as pub_datetri,
DATE_FORMAT(pub_datefin,'%d/%m/%Y') pub_datefin, pub_datefin as pub_datefintri
FROM publication, publication_data
WHERE pub_ref = pubd_pubref AND pubd_lang = 'fr'
AND MATCH (pubd_titre,pubd_txtprcenligne,pubd_txtscdenligne) AGAINST ('Programme d'assurance')
AND pub_etat IN ('ENLIGNE','EDITION')
AND pub_datepubli IS NOT NULL
AND pub_pubparentref IS NULL
AND pub_type <> 'BLOC'#0 /home/htchta/www_PRD/include/util/class_db.php(359): db->verifError(false)
#1 /home/htchta/www_PRD/include/business/Publication.php(990): db->query('SELECT publica...')
#2 /home/htchta/www_PRD/comportement/search.php(28): Publication::searchPubliByText('Programme d'ass...')
#3 /home/htchta/www_PRD/contenu.php(106): include_once('/home/htchta/ww...')
#4 {main}
Recherche - Habitat & Territoires Assurances (GROUPE HTC)
Extranet