Previous Thread
Next Thread
Print Thread
Hop To
Search feature encountering an Error message #263318 11/20/2019 12:06 AM
Joined: Mar 2013
Posts: 51
jorb Offline OP
Journeyman
OP Offline
Journeyman
Joined: Mar 2013
Posts: 51
Search feature encountering an Error message.

Below is how it use to work.

Here is a Easy way to find your or my post that has uploaded photos or attachments on Stovebolt forums.

I upload a photo or photos in the full editor using the Attachment Manager.
Then at the end of the Post or Reply text, I type xxx

When I'm looking for all my post that has a attachment, I click on the Search button next to the Active Threads button on top of the forum pages. At the Search page I select All forums then enter xxx in the Keyword Search Terms box.
I then enter my user name jorb in the By Display Name box and then click on Search Forums.

The search picks up all my post that have xxx in the text which also has my uploaded Attachments.

Now this is what happens.

I cannot do this anymore.

I use to be able to search for MY attachments using xxx under my user name jorb.

Now I get some kind of message telling me the below.
We Encountered A Problem
There are no results for your query. Please try a broader range of search criteria.


I hate to have to go back and change xxx to some other search query on all my attachments.
That would be a PITA.

Did something change with the new version or what would make the search feature show the above error ?


Truth Seeker
Re: Search feature encountering an Error message [Re: jorb] #263319 11/20/2019 12:57 AM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
This could be due to one or both if the following:

Control Panel > Features > Search: Minimum Searchable Word Length
Confirm that the setting is the smallest word size you are willing to let your users search for when using the "UBB.threads internal" search engine.

AND/OR, if using the "MySQL Full-Text" search engine:
Your database server could have recently been updated or had its defaults set.

Check this page in the documentation -- basically you set ft_min_word_len=3, restart the server, and rebuild your FULLTEXT indexes.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html

• You can use this query in Control Panel > Database Tools > SQL Command or the MySQL prompt to show the state of ft_min_word_len: "SHOW VARIABLES LIKE 'ft_min_word_len';"

• ft_min_word_len deafults to a value of '4' and is not by default listed in "my.cnf". To change it's default value, add: "ft_min_word_len = 3" to my.cnf under the [mysqld] section. my.conf is most likely located in /etc/, then restart MySQL or MariaDB. You don't need to restart the server.

• After changing the value of ft_min_word_len, any indexes you have must be rebuilt. To do the re-index just run this REPAIR TABLE table_name.

• A fast way to rebuild an index is to use this query: "REPAIR TABLE table_name QUICK;"
Note: You're using the name of the table only, not the name of any indexes. If you have more than one index against the 'table_name' table, all of them will be re-built.

Last edited by isaac; 11/20/2019 2:46 AM.

Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Search feature encountering an Error message [Re: isaac] #263324 11/20/2019 8:39 PM
Joined: Mar 2013
Posts: 51
jorb Offline OP
Journeyman
OP Offline
Journeyman
Joined: Mar 2013
Posts: 51
Thanks for the help!!

I will pass it along.

Something must of changed after the last upgrade.



Truth Seeker
Re: Search feature encountering an Error message [Re: jorb] #263325 11/20/2019 8:44 PM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
If the server upgraded from php5 to php7, the webhost could probably have updated other server resources as well. As stated above, the default min search word length is 4 letters.


Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Search feature encountering an Error message [Re: isaac] #263326 11/20/2019 8:50 PM
Joined: Mar 2013
Posts: 51
jorb Offline OP
Journeyman
OP Offline
Journeyman
Joined: Mar 2013
Posts: 51
I wish UBB Threads software had a feature were as when your in the full editor, you could access all your past attachments and paste them into your new reply.

If default min search word length is 4 letters that would explain the problem.
Was default min search word 4 letters on previous version?



Truth Seeker
Re: Search feature encountering an Error message [Re: jorb] #263327 11/20/2019 9:01 PM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
I dont know what your server was running. Look at your backups or contact your webhost. My previous post gives you the information needed for checking and configuring that current setting of your server.

The setting is not something UBB.threads has changed.


Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Search feature encountering an Error message [Re: jorb] #263328 11/20/2019 9:21 PM
Joined: Mar 2013
Posts: 51
jorb Offline OP
Journeyman
OP Offline
Journeyman
Joined: Mar 2013
Posts: 51
Ok, Will do.

Thanks


Truth Seeker
Re: Search feature encountering an Error message [Re: jorb] #263330 11/22/2019 12:52 AM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
Originally Posted by Baldeagle
I added the value of ft_min_word_len = 3" to my.cnf, restarted mysql and repaired all the indexes using this command: mysqlcheck --repair --databases mydb. Then I ran the search. It still does not work.

Apparently, jorb has been added "xxx" to any post he makes that includes an attachment. Then, when he wanted to find them, he would use the ubb search to search for xxx and put his Display Name in that field. He claims it worked before. It does not work now.

I can run this search on Google "jorb xxx site:stovebolt.com" and his images show up.

This is the first time I've ever heard of this trick, so I can't vouch that it worked before, but I don't doubt that jorb is telling the truth.

Vitals for our setup are in my sig. I have root access to the server, and yes, I upgraded recently to php7.


To show the state of ft_min_word_len, you can use this query in
Control Panel > Database Tools > SQL Command
Code
SHOW VARIABLES LIKE 'ft_min_word_len';


Attached screenshot is the query result as returned on UBBCentral -

Attached Files 20191121_21-51-17.PNG

Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Search feature encountering an Error message [Re: jorb] #263331 11/22/2019 1:25 AM
Joined: Oct 2007
Posts: 267
Baldeagle Offline
Enthusiast
Offline
Enthusiast
Joined: Oct 2007
Posts: 267
As the admin for the site, jorb alerted me to this thread. I recently upgraded php from 5 to 7, and it was using the default setting. I added a my.cnf file with the length statement, restarted the server and rebuilt the indexes using mysqlcheck --repair --databases ourdb. That fixed the problem.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

UBBThreads 7.7.3
Web Server Apache/2.4.37
PHP Version 7.2.19
MySQL Version 5.6.38
Database Size 2.23 GB
Re: Search feature encountering an Error message [Re: Baldeagle] #263332 11/22/2019 1:27 AM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
Originally Posted by Baldeagle
As the admin for the site, jorb alerted me to this thread. I recently upgraded php from 5 to 7, and it was using the default setting. I added a my.cnf file with the length statement, restarted the server and rebuilt the indexes using mysqlcheck --repair --databases ourdb. That fixed the problem.


This is good news - Thanks for your speedy reply thumbsup


Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Search feature encountering an Error message [Re: jorb] #263333 11/22/2019 11:29 AM
Joined: Mar 2013
Posts: 51
jorb Offline OP
Journeyman
OP Offline
Journeyman
Joined: Mar 2013
Posts: 51
Baldeagle is correct, after the changes he has made, the search feature is now working like did before.

Thanks for the help,

jorb




Truth Seeker

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Who's Online Now
0 registered members (), 88 guests, and 401 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)