Previous Thread
Next Thread
Print Thread
Hop To
Joined: Mar 2013
Posts: 51
J
Journeyman
Journeyman
J Offline
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
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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 3:46 AM.

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
Joined: Mar 2013
Posts: 51
J
Journeyman
Journeyman
J Offline
Joined: Mar 2013
Posts: 51
Thanks for the help!!

I will pass it along.

Something must of changed after the last upgrade.



Truth Seeker
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Mar 2013
Posts: 51
J
Journeyman
Journeyman
J Offline
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
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Mar 2013
Posts: 51
J
Journeyman
Journeyman
J Offline
Joined: Mar 2013
Posts: 51
Ok, Will do.

Thanks


Truth Seeker
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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 -
Attachments
20191121_21-51-17.PNG


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
Joined: Oct 2007
Posts: 354
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 354
Likes: 8
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

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
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
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Mar 2013
Posts: 51
J
Journeyman
Journeyman
J Offline
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
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
Forum Privacy Policy
by ECNet - 02/26/2024 11:58 AM
Who's Online Now
2 members (Nightcrawler, Ruben), 322 guests, and 160 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)