| |
Dymo
Registered: Jun 2016
Posts: 120 |
Problems searching stuff
Hi,
I have problems searching csdb... if I type in (for example):
Xenon + <- xenon with trainers... I only get "no results" now.. have worked earlier?
Searching without + works however
Dymo/G*P |
|
| |
hedning
Registered: Mar 2009
Posts: 4595 |
Yup. Same here. Strange! Will poke Perff. |
| |
Mr.Ammo
Account closed
Registered: Oct 2002
Posts: 228 |
Use advanced search and all is well! ;-) |
| |
Fred
Registered: Feb 2003
Posts: 284 |
Another issue with search but then within entering "credits"/"released by" is special characters.
When I try to search for:
"Jörg Schäfers"
or just "Jörg" or just "Schäfers"
it will find nothing. I have to type in "rg Sch" and then select his name from the list. It doesn't like the ö and ä.
The normal search features in CSDb is not affected. It's only the credit search and group/scener search.
Also try to search for group "Funkentstört" in the group search of an entry and you will find nothing while it is found when you search for "Funkentst". |
| |
Compyx
Registered: Jan 2005
Posts: 631 |
Using 'Schaefers' works, but only for SIDs. My guess would be that the PHP code was never properly set up to handle non-latin1 codepages. |
| |
chatGPZ
Registered: Dec 2001
Posts: 11108 |
it also fails on dots, try searching for "l.a.style" which gives no result. while "la style" does, and finds "l.a.style" =) |
| |
hedning
Registered: Mar 2009
Posts: 4595 |
Quote: it also fails on dots, try searching for "l.a.style" which gives no result. while "la style" does, and finds "l.a.style" =)
Stalker! :O |
| |
chatGPZ
Registered: Dec 2001
Posts: 11108 |
"hedning" has no dots, so that works fine =) |
| |
Fred
Registered: Feb 2003
Posts: 284 |
Quote: Using 'Schaefers' works, but only for SIDs. My guess would be that the PHP code was never properly set up to handle non-latin1 codepages.
I know for sure that those searches worked before for special characters. The display of the search results was recently changed so it could be that it is broken since then. |
| |
Count Zero
Registered: Jan 2003
Posts: 1821 |
I assume the server move brought a new postgres version maybe? |
| |
Perff
Administrator
Posts: 1665 |
Hi.
I'll take a look at it. :)
And yes, a lot have changed on this new server.
Both the encoding which is used is now UTF8, and a new version og both PHP and the database software.
Edit:
Think I fixed the problem now. The new database works a bit different than the old. ;)
Let me know if there are any other odd things.
Edit2:
About the problems in 'add <whatever>' I got it under control also. But I have to run through all of them to check, so it might take a little while. :) |
| |
iAN CooG
Registered: May 2002
Posts: 3132 |
Also searching sids with full HVSC path now work again, thanks. |
| |
Perff
Administrator
Posts: 1665 |
Went through all the 'add <whatever>' stuff, and fixed quite a lot actually.
There could be a few places with problems after my tampering, so be sure to let me know. ;) |
| |
Dymo
Registered: Jun 2016
Posts: 120 |
Yeah, searching for items with symbols and so on seems to be working again at least the tests I’ve done.. good job :) |
| |
zenda
Registered: Nov 2006
Posts: 22 |
I just found this:
Search for "dragons lair" and it will find 7 matches.
Search for "Dragon's lair" (with the ') and it will find much more - but will only show the first 25 matches.
Then choosing to show all 61 matching releases will fail because the search box will insert another ' - so the search string will be "Dragon''s lair" and cannot find anything. |
| |
iAN CooG
Registered: May 2002
Posts: 3132 |
confirmed, happens also searching Hunter's Moon and such with an ' in the name, you have to edit manually the resulting url removing the extra ' yourself |
| |
TheRyk
Registered: Mar 2009
Posts: 2062 |
Quote: Using 'Schaefers' works, but only for SIDs. My guess would be that the PHP code was never properly set up to handle non-latin1 codepages.
Seems to work again but only if there is a handle resp HVSC folder with real name. If you enter Kimmel, you get nothing but SID paths and do not get to Red anymore, if you enter Ouwehand, you get Reyn Ouwehand
I thought impossible search for real name was due to DSGVO nonsene and killed intentionally together with all real info (birthdate, place, avatar etc) |
| |
chatGPZ
Registered: Dec 2001
Posts: 11108 |
avatar was killed? thats extreme! |
| |
TheRyk
Registered: Mar 2009
Posts: 2062 |
smart ass :P |
| |
iAN CooG
Registered: May 2002
Posts: 3132 |
Quote: Seems to work again but only if there is a handle resp HVSC folder with real name. If you enter Kimmel, you get nothing but SID paths and do not get to Red anymore, if you enter Ouwehand, you get Reyn Ouwehand
I thought impossible search for real name was due to DSGVO nonsene and killed intentionally together with all real info (birthdate, place, avatar etc)
That's an unfortunate side effect indeed, for normal users but not for mods apparently as I see his scener entry from the search, and quite useless to hide it because it's anyway visible in the sids entry. All this BS about real names not visible is only creating more troubles to legit users than anything. |
| |
Impetigo
Registered: Jun 2004
Posts: 30 |
Quote: I just found this:
Search for "dragons lair" and it will find 7 matches.
Search for "Dragon's lair" (with the ') and it will find much more - but will only show the first 25 matches.
Then choosing to show all 61 matching releases will fail because the search box will insert another ' - so the search string will be "Dragon''s lair" and cannot find anything.
Reported the same bug a while ago (post#35):
CSDb moved to a new server |
| |
hedning
Registered: Mar 2009
Posts: 4595 |
Search is no longer triggered by the entry AKA fields. I am almost 100% sure that worked with the old server. |
| |
Perff
Administrator
Posts: 1665 |
An example where it dosn't search in the aka field? |
| |
hedning
Registered: Mar 2009
Posts: 4595 |
Quote: An example where it dosn't search in the aka field?
Searching for "ian", "ia" or "ic" kills the universe.. Dunno why... And no.. Don't try it. It hangs. |
| |
Perff
Administrator
Posts: 1665 |
Fixed! :) |
