SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(creationDate, 30) > NOW() as isNew FROM Arfooo_ADB_sites INNER JOIN Arfooo_ADB_categoryparents ON Arfooo_ADB_categoryparents.childId = Arfooo_ADB_sites.categoryId WHERE status = 'validated' AND EXISTS(SELECT * FROM Arfooo_ADB_categories WHERE Arfooo_ADB_categories.categoryId=Arfooo_ADB_sites.categoryId AND forbidden='0') AND ((MATCH (siteTitle, description) AGAINST ('+hsbc +mobile' IN BOOLEAN MODE) OR LOCATE( 'hsbc mobile', url ) > 0 )) AND Arfooo_ADB_categoryparents.parentId = '0' ORDER BY Arfooo_ADB_sites.priority DESC, creationDate LIMIT 20 OFFSET 0/tag-hsbc-mobile-t10-p1.html
(1024) Błąd SQL Can't find FULLTEXT index matching the column list (1191) Database.php line 235 6-12-24 3:05 |
FrontController->dispatch() # line 18, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/index.php call_user_func_array(Array[2], Array[3]) # line 220, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/core/FrontController.php SiteController->tagAction("10", "hsbc-mobile", "1") # line 0, file: unknown SiteSearcherModel->searchValidated(Array[1], "1") # line 436, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/controllers/SiteController.php SiteModel->selectWithNewFlag(Object:Criteria) # line 118, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/models/SiteSearcherModel.php Model->findAll(Object:Criteria, "*, categoryId, packageId, ADDDATE(creationDate, 30) > NOW() as i...", true) # line 23, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/models/SiteModel.php Database->sqlGetAll("SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(cre...") # line 140, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/core/Model.php Database->sqlQuery("SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(cre...") # line 360, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/core/Database.php trigger_error("...") # line 235, file: /homepages/19/d143251601/htdocs/ANNUAIRE-DES-BANQUES-NET/core/Database.php |