I have an issue--as reported by users which I can duplicate. There's not a basic issues thread so I opened it under bugs (albeit this could be specific to me)...
If i search for 'wise' vs. title - i get two results back on the site search. If I search for 'wise' in the db vs. title - i get back more. I can access and see these covers in showgallery/showphoto. Not sure why these wouldn't be coming back?
I can't see a difference in the db that would make a difference?
I'll print out the query--i can't see a reason those wouldn't be returned... it's really quite odd. I don't know that this wasn't an issue before the upgrade either--people are just being more picky since it changed heh
Ok, i printed the query that's getting executed (this is on my search field I added, I'll do another with the default /search in a moment):
SELECT p.id,p.cat FROM photopost_photos p LEFT JOIN photopost_photoextras e ON (e.photo=p.id)WHERE p.approved=1 AND p.storecat=0 AND ((p.title LIKE "%wise") OR (p.title LIKE "wise%")) ORDER BY p.date DESC LIMIT 500
- interesting that it's not looking for %wise% - rather two separate conditions to look for ending or starting with wise? but it wouldn't find, the wise one?
Not sure how you are doing it but you but something is off and not a good idea to modify code if your trying to report a bug.
If you are typing multiple words on the search line remember on the main search you must click contains one word not all words if you want to return results on each keyword you enter otherwise it is going to return only results that contain all words you type.
Again I have edited ads to contain various names based on what your saying to do.
I entered a test string on search and make sure to contains at least one word
I get all results I specified. Not one single time here and as shown in any of my examples am I not returning results that should be there. That setting on search that says contains at least one word tells the search to do a search one every single word entered there. If you leave the default at contains all words then it assume you are searching for a direct result string where the entries returned have to contain every single word you type which if course would limit results.
Ah, no --i think i might have confused my instructions for testing... try this:
> create 3 entries with the following titles:
1. first title
2. second title here
3. title number three
Then search just for 'title'.
In my scenario, the problem I was seeing --with searching for 'title' it would only return #1 and #3 - because the sql query was doing '%$key' or '$key%'
The second result did not return, because it doesnt match the sql query - it would have to have '%$key%' to find it (or '%title%' )
--i wasnt paying attention to the contains all words, because I'm only searching for one word in the titles.
Hope that makes more sense? i checked your gallery, and it seems like maybe I didn't explain the steps to reproduce well enough.
Also, after looking at your search results, you also have "keyword rest of title" --not sure if photopost is supposed to parse bbcode, but I changed it in search to do <i>keyword</i> --so it actually italicizes ?
I swapped yours in--looks good. I take it that did the same thing on yours and im not crazy?
I have one other issue relating to the characterset---i have latin1 set in the config, works great. However, when I try to upload something with a special character, it chokes. I need to test it a bit more--but that looks like its a problem (dunno if its just me or if anyone else has seen it)
its vb4.2--not 3.8, but I migrate from 3.8 (actually, i came from 2 something originally). I guess I could just switch the character set in vbulletin over to utf8 as well--I just fear I'd make it worse.
so, what i mean by 'choke' - after testing some more this morning...
If I upload a file (filename doesnt seem to matter) - however, the title is changed (the 'foreign' characters are removed altogether).
During the upload process I name the photo like the above, it comes out 'new_'
If I rename it using 'edit photo' after its uploaded, it's completely blank.
Understood--the photopost db is utf-8, is it the setting in the config @latin1 that is now hosing the title change? They currently display right (special characters already in the db), and the photpost_ tables are all utf-8.