Previous Thread
Next Thread
Print Thread
Hop To
#264101 08/14/2020 9:13 PM
Joined: May 2008
Posts: 755
Likes: 1
Old Hand
Old Hand
Joined: May 2008
Posts: 755
Likes: 1
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"
Bad Frog #264102 08/14/2020 9:27 PM
Joined: Apr 2004
Posts: 2,033
Likes: 177
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 2,033
Likes: 177
My guess is that because your issue just began happening out of nowhere in June, is that your search method setting was changed.

Control Panel > Features > Search > Search Method To Use
select: "UBB.threads Internal"

It is possible that some shared host server configurations do not support "SQL Full-Text"


current developer of UBB.threads php forum software
current release: UBB.threads 8.0.1 // wip: UBB.threads 8.1.0
isaac @ id242.com // my forum @ CelicaHobby.com
Bad Frog #264103 08/14/2020 9:51 PM
Joined: May 2008
Posts: 755
Likes: 1
Old Hand
Old Hand
Joined: May 2008
Posts: 755
Likes: 1
Thank you!
I have no idea how that got changed, I've never messed with that.
Seems to be working!


"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"
1 member likes this: isaac

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Selling a Forum?
by ECNet - 10/10/2026 10:54 AM
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Who's Online Now
1 members (1 invisible), 457 guests, and 221 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)