| |
Oxidy
Account closed
Registered: Mar 2003
Posts: 80 |
Irritating features...
When checking users online in the right column there's one thing I find a bit irritating.
For example, right now someone called "ready." (sans quotes) is logged in. Why can't the userlink link directly to his/her userpage instead of performing a search. A search results in nothing. If I really do want to search I could enter "ready." in the search box one inch up and get nothing there instead. ;)
Another detail. If I want to search for "Ed", that can't be done. (3 char limit.) If I do an advanced search for Ed as scener I get 96 hits which isn't that strange either. Is it possible to get direct hits listed first and %contains% hits after that?
|
|
| |
Perff
Administrator
Posts: 1679 |
I think we have the case of the general misunderstanding here at CSDb.
We have a account-system which is used for you the users of CSDb so we can figure out who are loged in and who does what changes.
The only information we need for this is a login and email, and this information is not general public.
This is not a direct part of the CSDb database which is supposed to contain information about the c64 scene, and not the users of the site.
On the other hand we have the database itself where we have information on sceners etc. There are no direct connection between theese two thing so we cant make a direct link to anything.
Then the search-feature was made because it often hits the correct page.
Note that we recently made it possible from the userpage to indicate the scener-entry of one self, so that a hard-link is possible.
About the search on small things. It was hardcoded not to allow searches less than 3 chars (is now changes to less than 2).
This was because if you made a search of one char it would take a LOOONG time. (several minutes)
Dont know why, but it must be PostGreSQL's fault. :) Someone give me a hint?
About the sorting. It should work that way in simple search, but it was never applied to advanced. There are so many things that should be done to advanced, but.. time.. you know. :)
/Perff |
| |
Oxidy
Account closed
Registered: Mar 2003
Posts: 80 |
Ok...
Is it not possible to link the accounts to sceners in the database? Both accounts and sceners must have ID-tags.
Anyway, don't get me wrong. This place is great, and I appreciate all your work with csdb.
|
| |
Perff
Administrator
Posts: 1679 |
Yes you can link accounts to sceners as I said:
"Note that we recently made it possible from the userpage to indicate the scener-entry of one self, so that a hard-link is possible."
See the post:
Account/Handle connections
|
| |
Oxidy
Account closed
Registered: Mar 2003
Posts: 80 |
Ok. I misunderstood when you wrote
"we cant make a direct link to anything."
|
| |
Perff
Administrator
Posts: 1679 |
Ok. Well, i guess it is a bit wierd when i wrote "we can't made a direct link", and then later "a hard-link is possible" (hard-link = direct link)
It just because we can't make the direct link without you (the user) giving us an id to ink to.
Hope this clears out any confusion. :)
|
| |
Oxidy
Account closed
Registered: Mar 2003
Posts: 80 |
FYI, (i don't wanna create a new thread for this minor post).
When clicking on a sceners profession I get the following message:
Could not execute SQL query: "SELECT DISTINCT h.id,lower(h.handle) FROM handles h WHERE 1=1 AND h.id IN (-1,2,5,11,14,18,19,24,118,120,196,200,216,219,220,248,260,266,---thousandsofnum bers---,5798,5808,5809,5812,5814,5841,5848,5856) ORDER BY lower(h.handle)" |
| |
Perff
Administrator
Posts: 1679 |
Hmm.. It seems there are something wrong?! with the server.
I get this error-message:
"PostgreSQL said: ERROR: out of free buffers: time to abort!"
If anyone know exactly what it means please let me know.
CSDb is run for free on a comercial webserver owned by a small company I work for (freelance) so I can't really make any demands directly. Only hope that it is not our code that causes the problem, and that the problem will be solved asap.
|
| |
Oxidy
Account closed
Registered: Mar 2003
Posts: 80 |
If shared_buffers is its default setting (64) you might want to increase it... to 10000 or something. (This requires memory. If this is a problem, try 256.)
Use the -b number_of_buffers option.
|
