Search

SELECT *, (MATCH(title, source, introduction, overlay, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM che_articles AS articles WHERE ((articles.active='Y') AND NOT ((publish_date is NULL) OR (publish_date <= '0000-00-00')) AND (publish_date < '2019-09-18 15:33:50') AND ((expiry_date is NULL) OR (expiry_date <= '0000-00-00 00:00:00') OR (expiry_date > '2019-09-18 15:33:50'))) AND ((MATCH(title, source, introduction, overlay, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, source, introduction, overlay, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) ORDER BY score DESC LIMIT 20
1191: Can't find FULLTEXT index matching the column list

SELECT sections.*, (MATCH(title, introduction, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM che_sections AS sections WHERE ((MATCH(title, introduction, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, introduction, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) AND ((sections.active='Y') AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2019-09-18 15:33:50'))) ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

SELECT *, (MATCH(title, introduction, description, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM che_categories AS categories WHERE ((MATCH(title, introduction, description, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, introduction, description, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) AND (categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2019-09-18 15:33:50')) ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

SELECT *, (MATCH(title, source, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM che_files AS files WHERE ((MATCH(title, source, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, source, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) AND (active='Y') ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

SELECT *, (MATCH(nick_name, full_name, introduction, description) AGAINST('+**' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), login_date)))) AS score FROM che_users AS users WHERE ((MATCH(nick_name, full_name, introduction, description) AGAINST('+**' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), login_date)))) < 1) AND ((MATCH(nick_name, full_name, introduction, description) AGAINST('+**' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), login_date)))) > 0.0) AND (users.active='Y') AND (users.capability IN ('S', 'M', 'A')) ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

You are searching for
Type one or several words.
Search in
Look in all or only one section.

No page has been found. This will happen with very short words (less than 4 letters), that are not fully indexed. This can happen as well if more than half of pages contain the searched words. Try to use most restrictive words and to suppress "noise" words.