starting in June (I was just made aware of it)
my site search has been giving errors.

I tried updating to the newest version hoping it would fix itself, but it didn't
I don't know enough about SQL to understand all this

Code
We Encountered A Problem
Script: /var/www/virtual/v/a/vanning.com/www/threads/scripts/dosearch.inc.php
Line: 571
SQL Error: Can't find FULLTEXT index matching the column list
SQL Error: 1191

Query:
SELECT p.POST_ID
FROM ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID,
ubbt_TOPICS t
WHERE p.POST_IS_APPROVED = '1'
AND t.TOPIC_STATUS <> 'M'
AND t.FORUM_ID IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','36','37','40','46','47','48','49','50','52','53','57','58','59','60','61','62','63','65','66','67','68','69','71','72','73','74','76','77','78','79','80','81','82','83')
AND p.TOPIC_ID = t.TOPIC_ID
AND MATCH (p.POST_SUBJECT, p.POST_DEFAULT_BODY) AGAINST ('astro' IN BOOLEAN MODE)




ORDER BY p.POST_POSTED_TIME DESC
LIMIT 200

Last edited by Bad Frog; 08/14/2020 9:14 PM.
"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"