Forum Home Forum Home > Site News, Newbies, Help and Improvements > Report bugs here
  New Posts New Posts RSS Feed - Search error in the DB
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedSearch error in the DB

 Post Reply Post Reply Page  12>
Author
Message
harmonium.ro View Drop Down
Special Collaborator
Special Collaborator

Honorary Collaborator / Retired Admin

Joined: August 18 2008
Location: Anna Calvi
Status: Offline
Points: 22989
Direct Link To This Post Topic: Search error in the DB
    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 results


From Progarchives.com, the ultimate progressive rock music website

And 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 results


From Progarchives.com, the ultimate progressive rock music website

DAN BERGLUND“S TONBRUKET music, discography, MP3, videos and reviewsDAN 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. Wacko I wouldn't have thought that a tiny sign like ' can create such trouble. LOL
Back to Top
Dean View Drop Down
Special Collaborator
Special Collaborator
Avatar
Retired Admin and Amateur Layabout

Joined: May 13 2007
Location: Europe
Status: Offline
Points: 37575
Direct Link To This Post 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?
Back to Top
harmonium.ro View Drop Down
Special Collaborator
Special Collaborator

Honorary Collaborator / Retired Admin

Joined: August 18 2008
Location: Anna Calvi
Status: Offline
Points: 22989
Direct Link To This Post 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. Tongue
Back to Top
Dean View Drop Down
Special Collaborator
Special Collaborator
Avatar
Retired Admin and Amateur Layabout

Joined: May 13 2007
Location: Europe
Status: Offline
Points: 37575
Direct Link To This Post Posted: October 28 2010 at 12:44
^ I know, I was pulling your leg, hence the "Z." Wink
What?
Back to Top
Marty McFly View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: March 23 2009
Location: Czech Republic
Status: Offline
Points: 3968
Direct Link To This Post 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
Back to Top
Dean View Drop Down
Special Collaborator
Special Collaborator
Avatar
Retired Admin and Amateur Layabout

Joined: May 13 2007
Location: Europe
Status: Offline
Points: 37575
Direct Link To This Post Posted: October 28 2010 at 13:10
^ the middle one Marty.
What?
Back to Top
BaldJean View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: May 28 2005
Location: Germany
Status: Offline
Points: 10387
Direct Link To This Post 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


Edited by BaldJean - November 02 2010 at 03:51


A shot of me as High Priestess of Gaia during our fall festival. Ceterum censeo principiis obsta
Back to Top
Dean View Drop Down
Special Collaborator
Special Collaborator
Avatar
Retired Admin and Amateur Layabout

Joined: May 13 2007
Location: Europe
Status: Offline
Points: 37575
Direct Link To This Post 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?
Back to Top
BaldJean View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: May 28 2005
Location: Germany
Status: Offline
Points: 10387
Direct Link To This Post 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
Back to Top
BaldJean View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: May 28 2005
Location: Germany
Status: Offline
Points: 10387
Direct Link To This Post 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
Back to Top
Dean View Drop Down
Special Collaborator
Special Collaborator
Avatar
Retired Admin and Amateur Layabout

Joined: May 13 2007
Location: Europe
Status: Offline
Points: 37575
Direct Link To This Post Posted: November 02 2010 at 04:15
Thanks Jean, that certainly generates a repeatable error - I'll pass it on to M@X
What?
Back to Top
Dean View Drop Down
Special Collaborator
Special Collaborator
Avatar
Retired Admin and Amateur Layabout

Joined: May 13 2007
Location: Europe
Status: Offline
Points: 37575
Direct Link To This Post 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?
Back to Top
NotAProghead View Drop Down
Special Collaborator
Special Collaborator
Avatar
Errors & Omissions Team

Joined: October 22 2005
Location: Russia
Status: Offline
Points: 8077
Direct Link To This Post 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)
Back to Top
M@X View Drop Down
Forum & Site Admin Group
Forum & Site Admin Group
Avatar
Co-founder, Admin & Webmaster

Joined: January 29 2004
Location: Canada
Status: Offline
Points: 4078
Direct Link To This Post 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 !
Back to Top
Dean View Drop Down
Special Collaborator
Special Collaborator
Avatar
Retired Admin and Amateur Layabout

Joined: May 13 2007
Location: Europe
Status: Offline
Points: 37575
Direct Link To This Post Posted: November 02 2010 at 06:12

Originally posted by NotAProghead NotAProghead wrote:

Search does not work properly. 

Try, for example, find "Reviews discussion" thread. 

 

That's just plain bizarre! Wacko


Edited by Dean - November 02 2010 at 06:21
What?
Back to Top
M@X View Drop Down
Forum & Site Admin Group
Forum & Site Admin Group
Avatar
Co-founder, Admin & Webmaster

Joined: January 29 2004
Location: Canada
Status: Offline
Points: 4078
Direct Link To This Post 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 !
Back to Top
Snow Dog View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: March 23 2005
Location: Caerdydd
Status: Offline
Points: 32995
Direct Link To This Post Posted: November 02 2010 at 06:17
Cylons and Cybermen rule here it seems.
Back to Top
M@X View Drop Down
Forum & Site Admin Group
Forum & Site Admin Group
Avatar
Co-founder, Admin & Webmaster

Joined: January 29 2004
Location: Canada
Status: Offline
Points: 4078
Direct Link To This Post Posted: November 02 2010 at 06:20
^ PA is rules by BOTs Geek
Prog On !
Back to Top
Snow Dog View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: March 23 2005
Location: Caerdydd
Status: Offline
Points: 32995
Direct Link To This Post Posted: November 02 2010 at 06:24
 Frak it! Cool
Back to Top
M@X View Drop Down
Forum & Site Admin Group
Forum & Site Admin Group
Avatar
Co-founder, Admin & Webmaster

Joined: January 29 2004
Location: Canada
Status: Offline
Points: 4078
Direct Link To This Post Posted: November 02 2010 at 06:25
Wink
Prog On !
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.188 seconds.
Donate monthly and keep PA fast-loading and ad-free forever.