SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(creationDate, 30) > NOW() as isNew FROM lingerie_sites INNER JOIN lingerie_categoryparents ON lingerie_categoryparents.childId = lingerie_sites.categoryId WHERE status = 'validated' AND EXISTS(SELECT * FROM lingerie_categories WHERE lingerie_categories.categoryId=lingerie_sites.categoryId AND forbidden='0') AND ((MATCH (siteTitle, description) AGAINST ('+marque +de +lingerie' IN BOOLEAN MODE) AND siteTitle LIKE '%de%' AND description LIKE '%de%' OR LOCATE( 'marque de lingerie', url ) > 0 )) AND lingerie_categoryparents.parentId = '0' ORDER BY lingerie_sites.priority DESC, siteTitle LIMIT 20 OFFSET 0/tag-marque-de-lingerie-t560-p1.html
(1024) Błąd SQL The used table type doesn't support FULLTEXT indexes (1214) Database.php line 235 22-2-19 4:44 |
FrontController->dispatch() # line 18, file: /public_html/annuairedelalingerie/index.php call_user_func_array(Array[2], Array[3]) # line 220, file: /public_html/annuairedelalingerie/core/FrontController.php SiteController->tagAction("560", "marque-de-lingerie", "1") # line 0, file: unknown SiteSearcherModel->searchValidated(Array[1], "1") # line 470, file: /public_html/annuairedelalingerie/controllers/SiteController.php SiteModel->selectWithNewFlag(Object:Criteria) # line 118, file: /public_html/annuairedelalingerie/models/SiteSearcherModel.php Model->findAll(Object:Criteria, "*, categoryId, packageId, ADDDATE(creationDate, 30) > NOW() as i...", true) # line 23, file: /public_html/annuairedelalingerie/models/SiteModel.php Database->sqlGetAll("SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(cre...") # line 140, file: /public_html/annuairedelalingerie/core/Model.php Database->sqlQuery("SELECT SQL_CALC_FOUND_ROWS *, categoryId, packageId, ADDDATE(cre...") # line 360, file: /public_html/annuairedelalingerie/core/Database.php trigger_error("...") # line 235, file: /public_html/annuairedelalingerie/core/Database.php |