Previous Thread
Next Thread
Print Thread
Hop To
#264101 08/14/2020 9:13 PM
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
Old Hand
Joined: May 2008
Posts: 753
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,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Bad Frog #264103 08/14/2020 9:51 PM
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
Old Hand
Joined: May 2008
Posts: 753
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
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 396 guests, and 110 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 8.0.0
(Preview build 20230217)