Previous Thread
Next Thread
Print Thread
Hop To
#264101 08/14/2020 9:13 PM
Joined: May 2008
Posts: 739
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 739
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: 1,733
Likes: 70
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,733
Likes: 70
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 // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Bad Frog #264103 08/14/2020 9:51 PM
Joined: May 2008
Posts: 739
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 739
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 Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
[FIXED for 7.7.5] Broken CP Link
by JAISP - 09/17/2020 3:22 PM
Empty Replies and Quotes...
by Metamatic - 09/16/2020 9:36 AM
Ignore thread option?
by Morgan - 09/09/2020 2:37 PM
Forum help page
by Morgan - 09/09/2020 2:41 AM
php & mysql version needed
by DennyP - 09/01/2020 9:47 PM
Who's Online Now
1 members (JAISP), 83 guests, and 50 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.5
(Snapshot build 20200903)