OP
I did a search on CRT and was advised that was too short of a search criteria. Can that be altered?
Please shorten allowable search parameters
- Thread starter Huntn
- Start date
We're bound by SQL not allowing it and going down the road of changing it is a thing, sorry about that. However, you can always use google like this:
site:talkedabout.com searchword
U
User.191
Guest
Bound by SQL? There's nowt stopping you doing much of anything in SQL given the will (she says as she works on Sql Server ...)
Sure, it can be done but I don't want to get into that on my server for a change like that is all.
Here's more info on it
XF 1.5 - Search, changed to "3 characters" -> no results
Hi there, I just changed my minimum length of the search items from default 4 to 3. After that I searched for a 3-letter word wich definately is in the forum and I got no results from the search. After that I rebuild the search index, which didn't help. What can I do? Did I miss another...
xenforo.com
U
User.191
Guest
Sure, it can be done but I don't want to get into that on my server for a change like that is all.
Here's more info on it
XF 1.5 - Search, changed to "3 characters" -> no results
Hi there, I just changed my minimum length of the search items from default 4 to 3. After that I searched for a 3-letter word wich definately is in the forum and I got no results from the search. After that I rebuild the search index, which didn't help. What can I do? Did I miss another...
Where's your sense of reckless fun and foolhardy adventure? I say turn the sucker alway the way up to negative 1 and see what breaks!
What, no imaginary numbers? Boo! Cowards!
Let's deploy this change straight to production. On a Friday.
And then go on vacation the following week.
U
User.191
Guest
I've worked at way too many places where that's is almost the rule... Some of these places no longer exist!
U
User.191
Guest
One of the places was where I'd spent 12 weeks working on a project for another customer that was totally out my comfort zone then got shafted by another employee because I dared ask questions about some of it.
And so I quit early one morning (like 4am) and left my laptop in my boss's office with my resignation letter inside it.
My boss didn't even notice I was gone initially but did see the spare laptop and thought it was another one he was expecting back and immediately set to work reimaging it so he could use it as a playtoy, totally ignoring the letter with his name on it.
With all my work for the customer on it.
ALL of it.
I'd like to say that was the nail that killed the company. It wasn't, although it was probably the biggest and last.
D
Deleted member 199
Guest
Just so some of us have an idea of help that could be offered - is this because you're not comfortable/experienced with the technical side of it, or because you are and have formed opinions about the impact/benefit of such a change?Sure, it can be done but I don't want to get into that on my server for a change like that is all.
Here's more info on it
XF 1.5 - Search, changed to "3 characters" -> no results
Hi there, I just changed my minimum length of the search items from default 4 to 3. After that I searched for a 3-letter word wich definately is in the forum and I got no results from the search. After that I rebuild the search index, which didn't help. What can I do? Did I miss another...
I'm not saying I disagree with the decision necessarily, I'd need to read more on the impact of shorter keyword support in mysql's full text indexes to form an opinion - just wondering if things like this would benefit from additional technical support is all.
U
User.191
Guest
It's not a recommended change and can adversely affect site performance is the crux of the issue.
I'm not a full fledged developer but can hold my own with MySql (I also used to server as a moderator over at the vBulletin dev site) but I don't like going in and messing with it anymore for the most part, I would need the right justification and for something like this it's not worth me going down that road since I haven't even gone in there yet.
D
Deleted member 199
Guest
I mean.. it'll increase the size of fulltext indexes, definitely, so _searches_ will most likely be impacted, by how much will depend on the amount of memory available, and how much content is actually in the database.
But the odd part to me is that a 4 character minimum is not the mysql default (it's 3 - and even eg. our Percona instances use the same default)
So maybe the forum setup is changing the database default minimum token (word) size from 3 to 4 characters?
But my question was mostly trying to judge Eric's view point in all of this (not even just for this, I'd wondered before what kind of ops support he has for the site)
U
User.191
Guest
I'm pretty blase myself about such changes to our FullText indexes because I prefix any change I do on them that is requested by someone with "You request it, you break it, you fix it" and it's a known truism with me that I'll brook no "but you made the change".
So I personally don't care. I look after the bloody things but the application uses them. If the app throws a wobbly as a result then - well, not. my fault (TBH).
So yeah, I tend to be vocally cavalier but in reality I would prefer to treat them with kid gloves most of the time since the app hinges upon them.
OP
It just seems I can search in something like “CRT” at MRs and not have it tell me, it‘s too short of a search parameter. I wonder if they made some changes over there in this regard?
Finally got around to adding this. SSH session through a Mac Terminal, fun stuff!
You can search for three letters now.
You can search for three letters now.
thekev
Elite Member
- Posts
- 1,063
- Reaction score
- 1,603
I would hope you have some kind of API on top of that SQL. Otherwise I may have to change my user handle.
Good old Bobby Tables.I would hope you have some kind of API on top of that SQL. Otherwise I may have to change my user handle.
Similar threads
