Skip to main content Help Control Panel

Login   A+   A-

Community «   Le forum «   Soupçons de bogues «  

erreur sql sur une recherche

avatarRambaud, Agnès -- on Sep. 12 2007, from le Grésivaudan (grenoble-chambéry)
YACS team - Modératrice
je cherchais des articles comportant "7.9alpha10" sur yetanother et je me suis fait bombardée de rouge !
Problem has been recorded

Issue description

Voici le message :
" SELECT articles.* FROM `yacs_articles` AS articles, `yacs_sections` AS sections WHERE ((articles.anchor_type LIKE 'section') AND (articles.anchor_id = sections.id)) AND ((articles.active='Y' OR articles.active='R' OR articles.active='N') AND ((articles.expiry_date is NULL) OR (articles.expiry_date = '0000-00-00 00:00:00') OR (articles.expiry_date > '2007-09-12 08:44:48')))MATCH(articles.title, articles.source, articles.introduction, articles.overlay, articles.description) AGAINST('7.9alpha10') ORDER BY articles.edit_date DESC LIMIT 0,31
1064: 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 'MATCH(articles.title, articles.source, articles.introduction, articles.overlay, ' at line 1
"

Comments

Bernard
avatar
from nearby-an-airport
Associate, 6674 posts

on Sep. 13 2007


Un petit bug, vite corrigé dans la 7.9alpha13 installée ce soir. Merci du tuyau...

Rate this page
Posted by Agnes on Sep. 12 2007, commented by Bernard on Sep. 13 2007, (popular)