Search

SELECT *, (MATCH(title, source, introduction, overlay, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM rav_articles AS articles WHERE ((articles.active='Y') AND NOT ((publish_date is NULL) OR (publish_date <= '0000-00-00')) AND (publish_date < '2023-05-31 10:24:12') AND ((expiry_date is NULL) OR (expiry_date <= '0000-00-00 00:00:00') OR (expiry_date > '2023-05-31 10:24:12'))) 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 rav_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 > '2023-05-31 10:24:12'))) 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 rav_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 > '2023-05-31 10:24:12')) 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 rav_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 rav_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 '*'