SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(creationDate, 30) > NOW() as isNew FROM Arfooo_sites INNER JOIN Arfooo_categoryparents ON Arfooo_categoryparents.childId = Arfooo_sites.categoryId WHERE status = 'validated' AND EXISTS(SELECT * FROM Arfooo_categories WHERE Arfooo_categories.categoryId=Arfooo_sites.categoryId AND forbidden='0') AND ((MATCH (siteTitle, description) AGAINST ('+Chitosan +et +nopal, +le +régime +amaigrissant +et +naturel' IN BOOLEAN MODE) AND siteTitle LIKE '%et%' AND description LIKE '%et%' AND siteTitle LIKE '%le%' AND description LIKE '%le%' AND siteTitle LIKE '%et%' AND description LIKE '%et%' OR LOCATE( 'Chitosan et nopal, le régime amaigrissant et naturel', url ) > 0 )) AND Arfooo_categoryparents.parentId = '0' ORDER BY Arfooo_sites.priority DESC, creationDate LIMIT 20 OFFSET 0/tag-chitosan-et-nopal-le-regime-amaigrissant-et-naturel-t4-p1.html
http://www.superone.fr/tag-chitosan-et-nopal-le-regime-amaigrissant-et-naturel-t4-p1.html
(1024) Bad SQL Can't find FULLTEXT index matching the column list (1191) Database.php line 224 20-4-24 11:58 |
FrontController->dispatch() # line 8, file: /home/superone/public_html/index.php SiteController->tagAction("4", "chitosan-et-nopal-le-regime-amaigrissant-et-naturel", "1") # line 185, file: /home/superone/public_html/core/FrontController.php SiteSearcherModel->searchValidated(Array[2], "1") # line 408, file: /home/superone/public_html/controllers/SiteController.php SiteModel->selectWithNewFlag(Object:Criteria) # line 101, file: /home/superone/public_html/models/SiteSearcherModel.php Model->findAll(Object:Criteria, "*, categoryId, packageId, ADDDATE(creationDate, 30) > NOW() as i...", true) # line 10, file: /home/superone/public_html/models/SiteModel.php Database->sqlGetAll("SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(cre...") # line 140, file: /home/superone/public_html/core/Model.php Database->sqlQuery("SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(cre...") # line 361, file: /home/superone/public_html/core/Database.php trigger_error("Bad SQL Can't find FULLTEXT index matching the column list (1191...") # line 224, file: /home/superone/public_html/core/Database.php |