Log inRegister an accountBrowse CSDbHelp & documentationFacts & StatisticsThe forumsAvailable RSS-feeds on CSDbSupport CSDb Commodore 64 Scene Database
You are not logged in - nap
CSDb User Forums


Forums > CSDb Bug Reports > Problems searching stuff
2018-05-28 20:09
Dymo

Registered: Jun 2016
Posts: 121
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
2018-05-28 20:15
hedning

Registered: Mar 2009
Posts: 4813
Yup. Same here. Strange! Will poke Perff.
2018-05-28 20:25
Mr.Ammo
Account closed

Registered: Oct 2002
Posts: 228
Use advanced search and all is well! ;-)
2018-05-28 20:41
Fred

Registered: Feb 2003
Posts: 299
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".
2018-05-28 20:54
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.
2018-05-28 22:35
chatGPZ

Registered: Dec 2001
Posts: 11523
it also fails on dots, try searching for "l.a.style" which gives no result. while "la style" does, and finds "l.a.style" =)
2018-05-28 22:40
hedning

Registered: Mar 2009
Posts: 4813
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
2018-05-28 22:56
chatGPZ

Registered: Dec 2001
Posts: 11523
"hedning" has no dots, so that works fine =)
2018-05-29 07:20
Fred

Registered: Feb 2003
Posts: 299
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.
2018-05-29 08:31
Count Zero

Registered: Jan 2003
Posts: 2013
I assume the server move brought a new postgres version maybe?
2018-05-29 09:14
Perff
Administrator

Posts: 1686
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. :)
2018-05-29 10:12
iAN CooG

Registered: May 2002
Posts: 3239
Also searching sids with full HVSC path now work again, thanks.
2018-05-29 12:22
Perff
Administrator

Posts: 1686
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. ;)
2018-05-29 17:37
Dymo

Registered: Jun 2016
Posts: 121
Yeah, searching for items with symbols and so on seems to be working again at least the tests I’ve done.. good job :)
2018-08-10 23:09
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.
2018-08-11 02:05
iAN CooG

Registered: May 2002
Posts: 3239
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
2018-08-11 10:44
TheRyk

Registered: Mar 2009
Posts: 2486
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)
2018-08-11 11:02
chatGPZ

Registered: Dec 2001
Posts: 11523
avatar was killed? thats extreme!
2018-08-11 11:19
TheRyk

Registered: Mar 2009
Posts: 2486
smart ass :P
2018-08-11 12:07
iAN CooG

Registered: May 2002
Posts: 3239
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.
2018-08-11 22:25
Impetigo

Registered: Jun 2004
Posts: 34
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
2018-08-13 17:39
hedning

Registered: Mar 2009
Posts: 4813
Search is no longer triggered by the entry AKA fields. I am almost 100% sure that worked with the old server.
2018-08-13 20:17
Perff
Administrator

Posts: 1686
An example where it dosn't search in the aka field?
2018-09-20 23:02
hedning

Registered: Mar 2009
Posts: 4813
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.
2018-09-21 13:23
Perff
Administrator

Posts: 1686
Fixed! :)
RefreshSubscribe to this thread:

You need to be logged in to post in the forum.

Search the forum:
Search   for   in  
All times are CET.
Search CSDb
Advanced
Users Online
Spiderman/X-Factor
Icon/TRIAD
Raf/Vulture Design
Guests online: 868
Top Demos
1 Next Level  (9.7)
2 13:37  (9.7)
3 Codeboys & Endians  (9.7)
4 Mojo  (9.6)
5 Coma Light 13  (9.6)
6 Edge of Disgrace  (9.6)
7 Signal Carnival  (9.6)
8 Wonderland XIV  (9.5)
9 Uncensored  (9.5)
10 Comaland 100%  (9.5)
Top onefile Demos
1 Nine  (9.8)
2 Layers  (9.6)
3 Cubic Dream  (9.6)
4 Party Elk 2  (9.6)
5 Copper Booze  (9.5)
6 Scan and Spin  (9.5)
7 Onscreen 5k  (9.5)
8 Grey  (9.5)
9 Dawnfall V1.1  (9.5)
10 Rainbow Connection  (9.5)
Top Groups
1 Artline Designs  (9.3)
2 Booze Design  (9.3)
3 Performers  (9.3)
4 Oxyron  (9.3)
5 Censor Design  (9.3)
Top Graphicians
1 Mirage  (9.7)
2 Archmage  (9.7)
3 Sulevi  (9.6)
4 Pal  (9.6)
5 Hein  (9.6)

Home - Disclaimer
Copyright © No Name 2001-2025
Page generated in: 1.749 sec.