Search error in the DB
Printed From: Progarchives.com
Category: Site News, Newbies, Help and Improvements
Forum Name: Report bugs here
Forum Description: Help us improve the site from a tech standpoint
URL: http://www.progarchives.com/forum/forum_posts.asp?TID=72691
Printed Date: July 19 2025 at 02:35
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com
Topic: Search error in the DB
Posted By: harmonium.ro
Subject: Search error in the DB
Date Posted: October 28 2010 at 12:10
When I do a search after "Dan Berglund's Tonbruket" (which has a band entry exactly like that), I think the search engine doesn't understand the ' sign, because this is what it shows:Dan Berglund''s Tonbruket discography search resultsFrom Progarchives.com, the ultimate progressive rock music websiteAnd bellow it doesn't find the band page, just two threads from the forum.If I search for "Dan Berglund''s Tonbruket" (with two ' ) it does find me the band page, but the ' sign looks really weird: Dan Berglund''''s Tonbruket discography search resultsFrom Progarchives.com, the ultimate progressive rock music website../artist.asp?id=5351 - DAN BERGLUND“S TONBRUKET music, discography, MP3, videos and reviews DAN BERGLUND“S TONBRUKET is a Jazz Rock/Fusion / Progressive Rock artist from Sweden. This page includes DAN BERGLUND“S TONBRUKET's : biography, ...www.progarchives.com/artist.asp?id=5351 Really weird.  I wouldn't have thought that a tiny sign like ' can create such trouble.  |
Replies:
Posted By: Dean
Date Posted: October 28 2010 at 12:32
|
1 - I just tried it and found 3 results, no errors, but it did show the band name with a double apostrophe.
2 - did the same with Pavlov's Dog - it says: Pavlov''s Dog discography search results, with the double apostrophe, but it found 10+pages of hits though.
3 - I've just tried the search using google.co.uk (site:www.progarchives.com) and it puts the double apostrophe in too, therefore it must be a Google bug.
Z - why are you using all those words and punctuation to search? surely "Berglund" and/or "Tonbrucket" is unique enough to find what you're looking for.
------------- What? |
Posted By: harmonium.ro
Date Posted: October 28 2010 at 12:36
I didn't type all that band name, I just copied it from somewhere else. When I type, I only type a keyword, indeed. 
|
Posted By: Dean
Date Posted: October 28 2010 at 12:44
^ I know, I was pulling your leg, hence the "Z."  ------------- What? |
Posted By: Marty McFly
Date Posted: October 28 2010 at 13:00
|
^ Which part of leg ? Thighs or knees ?
------------- There's a point where "avant-garde" and "experimental" becomes "terrible" and "pointless," -Andyman1125 on Lulu  Even my |
Posted By: Dean
Date Posted: October 28 2010 at 13:10
|
^ the middle one Marty. ------------- What? |
Posted By: BaldJean
Date Posted: November 02 2010 at 03:43
|
the "Search" function generally does not seem to work properly. you may get a lot of results, but once you click on a post to open it you get a message like this: Server Error in Forum Application WARNING: SQL Injection attack detected. Please contact the forum administrator. Support Error Code:- err_SQLServer_SqlInjectionTest() File Name:- functions_common.asp Error details:- this appears to be so only for search of more recent posts. looking for a quite old one (more than half a yedar ago) worked fine -------------  A shot of me as High Priestess of Gaia during our fall festival. Ceterum censeo principiis obsta |
Posted By: Dean
Date Posted: November 02 2010 at 03:49
|
can you post the exact URL that causes that for you Jean, not seeing a problem from my PC. ------------- What? |
Posted By: BaldJean
Date Posted: November 02 2010 at 03:54
|
this for example: http://www.progarchives.com/forum/forum_posts.asp?TID=72801&KW=keyboard&PID=3924536#3924536 I did a search for "keyboard" and clicked on the first result ------------- A shot of me as High Priestess of Gaia during our fall festival. Ceterum censeo principiis obsta |
Posted By: BaldJean
Date Posted: November 02 2010 at 03:55
|
this for example: http://www.progarchives.com/forum/forum_posts.asp?TID=72801&KW=keyboard&PID=3924536#3924536 I did a search for "keyboard" and clicked on the first result ------------- A shot of me as High Priestess of Gaia during our fall festival. Ceterum censeo principiis obsta |
Posted By: Dean
Date Posted: November 02 2010 at 04:15
|
Thanks Jean, that certainly generates a repeatable error - I'll pass it on to M@X ------------- What? |
Posted By: Dean
Date Posted: November 02 2010 at 04:23
|
The error is created by the word "key" - search for "board" and it doesn't fail - very strange. ------------- What? |
Posted By: NotAProghead
Date Posted: November 02 2010 at 05:59
|
Search does not work properly. Try, for example, find "Reviews discussion" thread. ------------- Who are you and who am I to say we know the reason why... (D. Gilmour) |
Posted By: M@X
Date Posted: November 02 2010 at 06:11
|
I will give more details later but some keywoard are blocked to prevent SQL INJECTION command in the database. This explain why... stay tuned ------------- Prog On ! |
Posted By: Dean
Date Posted: November 02 2010 at 06:12
|
That's just plain bizarre!  ------------- What? |
NotAProghead wrote:Posted By: M@X
Date Posted: November 02 2010 at 06:15
|
Fixed The use of the word : key was blocked, but I removed that filter for now. Thanks for reporting ------------- Prog On ! |
Posted By: Snow Dog
Date Posted: November 02 2010 at 06:17
|
Cylons and Cybermen rule here it seems. ------------- http://www.last.fm/user/Snow_Dog" rel="nofollow"> 
|
Posted By: M@X
Date Posted: November 02 2010 at 06:20
^ PA is rules by BOTs  ------------- Prog On ! |
Posted By: Snow Dog
Date Posted: November 02 2010 at 06:24
Frak it!  ------------- http://www.last.fm/user/Snow_Dog" rel="nofollow">
|
Posted By: M@X
Date Posted: November 02 2010 at 06:25
------------- Prog On ! |
Posted By: NotAProghead
Date Posted: November 02 2010 at 06:57
Seems not fixed yet,I typed Reviews discussion (Search options: Match All Words, Any Date, Posts). Result:
------------- Who are you and who am I to say we know the reason why... (D. Gilmour) |
Posted By: M@X
Date Posted: November 02 2010 at 07:08
|
Ok, please try again ------------- Prog On ! |
Posted By: NotAProghead
Date Posted: November 02 2010 at 07:37
|
^ The same error, M@X. ------------- Who are you and who am I to say we know the reason why... (D. Gilmour) |
Posted By: Angelo
Date Posted: November 02 2010 at 18:48
|
What time frame did you use? Try 'Any date'... reviews discussion is a quite old thread and the search looks for topics.
------------- http://www.iskcrocks.com" rel="nofollow - ISKC Rock Radio I stopped blogging and reviewing - so won't be handling requests. Promo's for ariplay can be sent to [email protected] |
Posted By: NotAProghead
Date Posted: November 03 2010 at 01:03
|
I already wrote: Reviews discussion (Search options: Match All Words, Any Date, Posts). The same error is in case of search for Topics. ------------- Who are you and who am I to say we know the reason why... (D. Gilmour) |