tjr
-
Total Posts:
136
- Joined: 5/23/2003
- Location: Louisville, KY
|
Forum Search by Member feature busted?
Tue, 02/14/06 3:37 PM
( permalink)
I get an SQL error when I try to search for posts by a member name.
Sorry if this is the wrong place to post this question.
|
|
|
|
UncleVic
-
Total Posts:
6020
- Joined: 10/14/2003
- Location: West Palm Beach, FL
- Roadfood Insider
|
RE: Forum Search by Member feature busted?
Tue, 02/14/06 4:26 PM
( permalink)
Site seems to have been running slow at times the last few days... I've received the same time out errors also.. Could be time to Defrag the roadfood hard drive...
|
|
|
|
Jimeats
-
Total Posts:
3175
- Joined: 8/15/2005
- Location: Ipswich Ma
|
RE: Forum Search by Member feature busted?
Tue, 02/14/06 6:09 PM
( permalink)
And I thought it was my box, so I did the defrag thing yesterday. Chow Jim
|
|
|
|
DLnWPBrown
-
Total Posts:
832
- Joined: 2/16/2004
- Location: Cary, NC
|
RE: Forum Search by Member feature busted?
Tue, 02/14/06 6:48 PM
( permalink)
.......... hmmmmm, could be from where all the Northerns have been home, online after all the snow.............  Dennis in Cary ( South y'all )
|
|
|
|
roossy90
-
Total Posts:
6694
- Joined: 8/15/2005
- Location: columbus, oh
|
RE: Forum Search by Member feature busted?
Tue, 02/14/06 7:09 PM
( permalink)
quote:Originally posted by Jimeats
And I thought it was my box, so I did the defrag thing yesterday. Chow Jim
Me too... I feel like I am back on dial up waiting the last couple days...
|
|
|
|
Jimeats
-
Total Posts:
3175
- Joined: 8/15/2005
- Location: Ipswich Ma
|
RE: Forum Search by Member feature busted?
Tue, 02/14/06 7:56 PM
( permalink)
quote:Originally posted by roossy90 quote:Originally posted by Jimeats
And I thought it was my box, so I did the defrag thing yesterday. Chow Jim
Me too... I feel like I am back on dial up waiting the last couple days... Dial up what the hell is that? I'm on FIOS sit in front of this stupid thing and have to put a seat belt on the speed is incredible love it. It's an option I would have to think about before moving. Chow Jim
|
|
|
|
Ort. Carlton.
-
Total Posts:
3555
- Joined: 4/9/2003
- Location: Athens, GA
|
RE: Forum Search by Member feature busted?
Tue, 02/14/06 11:29 PM
( permalink)
Dearfolk,
I've been wondering what was going on. Although I've been mighty busy of late, every time I've come by to post, I've been unable to do so... this has been going on for several days and through something like 17 attempts..
Well, today -- so far, so good. Now if I could only remember what I wanted to post about in the first place....
Absently-With-Leave, Ort. Carlton in Warmer-Than-Yesterday Athens, Georgia.
|
|
|
|
UncleVic
-
Total Posts:
6020
- Joined: 10/14/2003
- Location: West Palm Beach, FL
- Roadfood Insider
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 1:11 AM
( permalink)
quote:Originally posted by pdxyyz quote:Originally posted by tjr
I get an SQL error when I try to search for posts by a member name.
Sorry if this is the wrong place to post this question.
Line 1: Incorrect syntax near ')'. /Forums/search.asp, line 447 This error indicates a problem with the SQL query itself and defragging won't resolve the issue. Has anyone changed the query related to the search lately? If not this could also be an issue with some bad data. What ever it is the query is violating the rules of SQL. Without seeing the actual query being run that's as far as I can get with this. Another Report to add.. I keep getting booted.. Have to re-enter my username and password everytime I return to the site to post... Was going to make some tech comments, but keep getting booted... ARGHH There has been a problem! Invalid Password or User Name Go back to correct the problem.
|
|
|
|
roossy90
-
Total Posts:
6694
- Joined: 8/15/2005
- Location: columbus, oh
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 1:56 AM
( permalink)
I think I have been kicked back to 2002 when I was still on dial up..
Site is still running very slow, or my $1300 laptop that is 5 months old and my broadband/cable connection is crapping out...
|
|
|
|
UncleVic
-
Total Posts:
6020
- Joined: 10/14/2003
- Location: West Palm Beach, FL
- Roadfood Insider
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 2:29 AM
( permalink)
quote:Originally posted by roossy90
I think I have been kicked back to 2002 when I was still on dial up..
Site is still running very slow, or my $1300 laptop that is 5 months old and my broadband/cable connection is crapping out...
Ya, there's a minor burp going on... But the site has been tons faster then 3 days ago when crawl was an overstatement.. dont toss that overpriced laptop out yet, it should keep up with the 500 dollar model within a day or two! :)
|
|
|
|
UncleVic
-
Total Posts:
6020
- Joined: 10/14/2003
- Location: West Palm Beach, FL
- Roadfood Insider
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 2:32 AM
( permalink)
quote:Originally posted by pdxyyz quote:Originally posted by tjr
I get an SQL error when I try to search for posts by a member name.
Sorry if this is the wrong place to post this question.
Line 1: Incorrect syntax near ')'. /Forums/search.asp, line 447 This error indicates a problem with the SQL query itself and defragging won't resolve the issue. Has anyone changed the query related to the search lately? If not this could also be an issue with some bad data. What ever it is the query is violating the rules of SQL. Without seeing the actual query being run that's as far as I can get with this. I think it has to do with the seek times on the drive.. Could be wrong here, but thats why I suggested Defrag (to reorganize the databases)... Was just one mans opinion here...
|
|
|
|
mayor al
-
Total Posts:
14007
- Joined: 8/20/2002
- Location: Louisville area, Southern Indiana
- Roadfood Insider
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 10:48 AM
( permalink)
Consider my situation.... I am still on dial-up with the best speed I ever see in the 45,000 kbs range. It makes policing the boards an exercise in futility. But what the hell, beats watching the Soaps everyday! 
|
|
|
|
roossy90
-
Total Posts:
6694
- Joined: 8/15/2005
- Location: columbus, oh
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 7:37 PM
( permalink)
quote:Originally posted by Jimeats quote:Originally posted by roossy90 quote:Originally posted by Jimeats
And I thought it was my box, so I did the defrag thing yesterday. Chow Jim
Me too... I feel like I am back on dial up waiting the last couple days... Dial up what the hell is that? I'm on FIOS sit in front of this stupid thing and have to put a seat belt on the speed is incredible love it. It's an option I would have to think about before moving. Chow Jim I have cable/broadband for 3 years now. Wouldnt think of using dial up... It just seemed like I was on dial up waiting for the page to load. But it seems this site is fixed now..
|
|
|
|
roossy90
-
Total Posts:
6694
- Joined: 8/15/2005
- Location: columbus, oh
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 7:39 PM
( permalink)
quote:Originally posted by UncleVic quote:Originally posted by roossy90
I think I have been kicked back to 2002 when I was still on dial up..
Site is still running very slow, or my $1300 laptop that is 5 months old and my broadband/cable connection is crapping out...
Ya, there's a minor burp going on... But the site has been tons faster then 3 days ago when crawl was an overstatement.. dont toss that overpriced laptop out yet, it should keep up with the 500 dollar model within a day or two! :) Ain't that the truth!...LOL
|
|
|
|
roossy90
-
Total Posts:
6694
- Joined: 8/15/2005
- Location: columbus, oh
|
RE: Forum Search by Member feature busted?
Wed, 02/15/06 9:11 PM
( permalink)
Can you repeat the above in English, please?
LOLOLOL
|
|
|
|
UncleVic
-
Total Posts:
6020
- Joined: 10/14/2003
- Location: West Palm Beach, FL
- Roadfood Insider
|
RE: Forum Search by Member feature busted?
Thu, 02/16/06 3:24 AM
( permalink)
quote:Originally posted by pdxyyz quote:Originally posted by UncleVic quote:Originally posted by pdxyyz quote:Originally posted by tjr
I get an SQL error when I try to search for posts by a member name.
Sorry if this is the wrong place to post this question.
Line 1: Incorrect syntax near ')'. /Forums/search.asp, line 447 This error indicates a problem with the SQL query itself and defragging won't resolve the issue. Has anyone changed the query related to the search lately? If not this could also be an issue with some bad data. What ever it is the query is violating the rules of SQL. Without seeing the actual query being run that's as far as I can get with this. I think it has to do with the seek times on the drive.. Could be wrong here, but thats why I suggested Defrag (to reorganize the databases)... Was just one mans opinion here... An SQL syntax error is returned when the SQL query is parsed by the database engine. This is before any attempt is made to retreive any data from the database, so this error is not seek time related. Now the slow file loading if being seen by everyone would be an issue with seek time. If the database itself is fragmented, a disk defrag will not help that much since defragging the file the database uses does not defrag the data held in that file. That requires a database compress. And while we're in a mood to perform preventive maintenance, lets do some table re-indexing as well. Guess who was a DBA in a former life.  You're Hired... Free Fries on break there... 
|
|
|
|
roossy90
-
Total Posts:
6694
- Joined: 8/15/2005
- Location: columbus, oh
|
RE: Forum Search by Member feature busted?
Thu, 02/16/06 1:06 PM
( permalink)
quote:Originally posted by pdxyyz quote:Originally posted by roossy90
Can you repeat the above in English, please?
LOLOLOL
Sh*t happens and ya gotta fix it.  Now, that I can understand!
|
|
|
|
1bbqboy
-
Total Posts:
4022
- Joined: 11/20/2000
- Location: Rogue Valley
|
RE: Forum Search by Member feature busted?
Thu, 02/16/06 3:14 PM
( permalink)
quote:Originally posted by UncleVic quote:Originally posted by pdxyyz quote:Originally posted by UncleVic quote:Originally posted by pdxyyz quote:Originally posted by tjr
I get an SQL error when I try to search for posts by a member name.
Sorry if this is the wrong place to post this question.
Line 1: Incorrect syntax near ')'. /Forums/search.asp, line 447 This error indicates a problem with the SQL query itself and defragging won't resolve the issue. Has anyone changed the query related to the search lately? If not this could also be an issue with some bad data. What ever it is the query is violating the rules of SQL. Without seeing the actual query being run that's as far as I can get with this. I think it has to do with the seek times on the drive.. Could be wrong here, but thats why I suggested Defrag (to reorganize the databases)... Was just one mans opinion here... An SQL syntax error is returned when the SQL query is parsed by the database engine. This is before any attempt is made to retreive any data from the database, so this error is not seek time related. Now the slow file loading if being seen by everyone would be an issue with seek time. If the database itself is fragmented, a disk defrag will not help that much since defragging the file the database uses does not defrag the data held in that file. That requires a database compress. And while we're in a mood to perform preventive maintenance, lets do some table re-indexing as well. Guess who was a DBA in a former life. You're Hired... Free Fries on break there... Fresh or Frozen?
|
|
|
|
tjr
-
Total Posts:
136
- Joined: 5/23/2003
- Location: Louisville, KY
|
RE: Forum Search by Member feature busted?
Fri, 02/17/06 2:55 PM
( permalink)
Nope, same error. I searched for member wallyum (TJ Jackson said he posted something about a BBQ place in Carrollton).
|
|
|
|
TJ Jackson
-
Total Posts:
4040
- Joined: 7/26/2003
- Location: Cincinnati, OH
|
RE: Forum Search by Member feature busted?
Fri, 02/17/06 3:05 PM
( permalink)
|
|
|
|
UncleVic
-
Total Posts:
6020
- Joined: 10/14/2003
- Location: West Palm Beach, FL
- Roadfood Insider
|
RE: Forum Search by Member feature busted?
Fri, 02/17/06 4:03 PM
( permalink)
quote:Originally posted by bill voss quote:Originally posted by UncleVic quote:Originally posted by pdxyyz quote:Originally posted by UncleVic quote:Originally posted by pdxyyz quote:Originally posted by tjr
I get an SQL error when I try to search for posts by a member name.
Sorry if this is the wrong place to post this question.
Line 1: Incorrect syntax near ')'. /Forums/search.asp, line 447 This error indicates a problem with the SQL query itself and defragging won't resolve the issue. Has anyone changed the query related to the search lately? If not this could also be an issue with some bad data. What ever it is the query is violating the rules of SQL. Without seeing the actual query being run that's as far as I can get with this. I think it has to do with the seek times on the drive.. Could be wrong here, but thats why I suggested Defrag (to reorganize the databases)... Was just one mans opinion here... An SQL syntax error is returned when the SQL query is parsed by the database engine. This is before any attempt is made to retreive any data from the database, so this error is not seek time related. Now the slow file loading if being seen by everyone would be an issue with seek time. If the database itself is fragmented, a disk defrag will not help that much since defragging the file the database uses does not defrag the data held in that file. That requires a database compress. And while we're in a mood to perform preventive maintenance, lets do some table re-indexing as well. Guess who was a DBA in a former life. You're Hired... Free Fries on break there... Fresh or Frozen? Sorry, due to budget restrictions, only the microwave version will be made available...
|
|
|
|
tjr
-
Total Posts:
136
- Joined: 5/23/2003
- Location: Louisville, KY
|
RE: Forum Search by Member feature busted?
Sat, 02/18/06 12:12 AM
( permalink)
Thank you very much, TJ, it's perfectly on topic to me!
|
|
|
|
tjr
-
Total Posts:
136
- Joined: 5/23/2003
- Location: Louisville, KY
|
RE: Forum Search by Member feature busted?
Sat, 02/18/06 2:33 AM
( permalink)
Nope. But I left keyword blank as I wanted all posts by wallyum. That's most likely the problem, maybe it constructs the SQL with the parenthesis that would go with the AND for the keyword, even tho it doesn't need one.
I was an ASP developer in a previous life. A pretty good debugger if not the best 'splainer.
|
|
|
|
|
mr chips
|
RE: Forum Search by Member feature busted?
Sun, 02/19/06 12:17 AM
( permalink)
I don't know if this is on topic or not. When I want to read all the posts by someone, I go to their profile. There is a line there where you can access most of their posts by specific forums. Please correct if this is not a good way.
|
|
|
|
tjr
-
Total Posts:
136
- Joined: 5/23/2003
- Location: Louisville, KY
|
RE: Forum Search by Member feature busted?
Sun, 02/19/06 1:16 AM
( permalink)
You're right, missed this feature before.
|
|
|
|
tjr
-
Total Posts:
136
- Joined: 5/23/2003
- Location: Louisville, KY
|
RE: Forum Search by Member feature busted?
Mon, 02/20/06 2:13 AM
( permalink)
Yes, that would be a big improvement. Or make the keyword not required so that all posts by a user could be found, just like on the user profile.
Of course, had it given me an appropriate error message to begin with, we wouldn't have even had this discussion.
|
|
|
|
roossy90
-
Total Posts:
6694
- Joined: 8/15/2005
- Location: columbus, oh
|
RE: Forum Search by Member feature busted?
Mon, 02/20/06 12:57 PM
( permalink)
My simple little brain hurts from reading all that...LOL
|
|
|
|
