C3 Vette Registry - The Best Resource on the Net for C3 Vettes! C3 Vette
Forums -> Official C3 Vette Registry Support/Issues/Comments
Not Logged In! Login or Register!  Users Online: 8 / Help 
Features  Find C3 Parts on ebay in only 2 or 3 clicks!  | Add YOUR C3 to the Registry

Supporting Vendors
Bair's Corvettes
Mid America Motorworks
CorvetteClothing.com
Volunteer Vette Products
VetteBookStore.com

C3 of the Month
None Current
Enter Yours Today!
Online C3 Show
13
C3s are Registered

Vanity Plates
NO MPG
LEMONTWIST
Featured Links

Buy Now
Corvette from the Inside
Corvette from the Inside


Corvette by the Numbers
Corvette by the Numbers


The Corvette Dynasty (Hardcover)
The Corvette Dynasty (Hardcover)


Chevrolet Corvette: 1968 thru 1982, All V8 models (Haynes Manuals) (Paperback)
Chevrolet Corvette: 1968 thru 1982, All V8 models (Haynes Manuals) (Paperback)



| Hide Signatures and Profile Pics

 New Topic New Topic Post Reply Reply New Poll New Poll Search     Search Page [1]  
10/5/05 8:48pm - Original Message: 'My feelings are hurt, now'
Adams' Apple Lifetime Member
Lifetime Member
Moderator
- Send Private Message


Duncanville, TX - USA

Vette(s):
#1-1974 L-48 4spd Cp Med Red Metallic/Black deluxe int w/AC/tilt/tele./p/w-p/b/ Am-Fm/map light National/Regional/Chapter NCRS "Top Flight" #2-1985 Bright Red/Carmine Cp.L-98/auto Member: NCRS, NCRS Texas, Corvette Legends of Texas

Joined: 11/8/2003
Posts: 19459
Could somebody preeeeze help me find my way into the "Live Chat" room? I have been a member of C3VR since '03, and I have NEVER been able to join in the fun. I've had this same trouble with 3 different 'puters, so I'm pretty sure it's not that. I usually can at least get to the 'sign in' page, but no further. To-nite, tho, I get a new kick in the a#*!
If someone can "talk" me thru it, I'd really 'preciate it. I just
know you're all in there talking bad about ME!

This is what I'm getting to-nite, when I click on the "Live Chat" icon:

There was an error! It has been reported to the system administrator. It you continue to get this message for more than 1 day, please send an email to support@VR.com

Error 424: Object required


Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'Username = 'Adams' Apple';'.

/netchatter/login.asp, line 16

Adams' Apple38630.7852893519

____________________________________
Joel Adams
C3VR Lifetime Member #56    
My Link


(click for Texas-sized view!)
             NCRS

"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
 Reply Reply  Quote Reply w/Quote
 
Support C3VR!
Suport our advertisers
10/5/05 8:51pm - Reply: 'My feelings are hurt, now'
Iron82 Lifetime Member
Lifetime Member
- Send Private Message



Vette(s):
1982 Collector Edition #3413

Joined: 7/24/2003
Posts: 2150

Sounds like your pop up is blocking or your fire wall is restricted.

 



____________________________________


IRON 82
C3VR Lifetime Member #51
NCM Lifetime Member #1353


 Reply Reply  Quote Reply w/Quote
10/5/05 9:06pm - Reply: 'My feelings are hurt, now'
Adam Wartell Lifetime Member
Lifetime Member
C3VR Founder
- Send Private Message


Eagleville, PA - USA

Vette(s):
Used to own a 1979 Corvette now owned by JB79

Joined: 11/1/2001
Posts: 14715
Try now. I think I fixed it.

____________________________________
-Adam Wartell
NCM Lifetime Member #1222
Founder:
C3 Vette Registry (Join C3VR on facebook)
C4 Vette Registry, C6 Vette Registry
C7 Vette Registry
Corvettes for a Cure

My first Vette, now owned by JB79:

 Reply Reply  Quote Reply w/Quote
10/5/05 10:01pm - Reply: 'My feelings are hurt, now'
Adams' Apple Lifetime Member
Lifetime Member
Moderator
- Send Private Message


Duncanville, TX - USA

Vette(s):
#1-1974 L-48 4spd Cp Med Red Metallic/Black deluxe int w/AC/tilt/tele./p/w-p/b/ Am-Fm/map light National/Regional/Chapter NCRS "Top Flight" #2-1985 Bright Red/Carmine Cp.L-98/auto Member: NCRS, NCRS Texas, Corvette Legends of Texas

Joined: 11/8/2003
Posts: 19459
Thanx, guys!!!

____________________________________
Joel Adams
C3VR Lifetime Member #56    
My Link


(click for Texas-sized view!)
             NCRS

"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
 Reply Reply  Quote Reply w/Quote
10/5/05 10:02pm - Reply: 'My feelings are hurt, now'
Iron82 Lifetime Member
Lifetime Member
- Send Private Message



Vette(s):
1982 Collector Edition #3413

Joined: 7/24/2003
Posts: 2150
Get some sleep now....    

____________________________________


IRON 82
C3VR Lifetime Member #51
NCM Lifetime Member #1353


 Reply Reply  Quote Reply w/Quote
10/6/05 8:54pm - Reply: 'My feelings are hurt, now'
Adams' Apple Lifetime Member
Lifetime Member
Moderator
- Send Private Message


Duncanville, TX - USA

Vette(s):
#1-1974 L-48 4spd Cp Med Red Metallic/Black deluxe int w/AC/tilt/tele./p/w-p/b/ Am-Fm/map light National/Regional/Chapter NCRS "Top Flight" #2-1985 Bright Red/Carmine Cp.L-98/auto Member: NCRS, NCRS Texas, Corvette Legends of Texas

Joined: 11/8/2003
Posts: 19459
Just some info for others who might have had this same problem Adam & Mike(Iron82) helped to solve the mystery(or decided to finally let me play with the "Big Dogs" ).
It was the fact that my screen name, Adams' Apple has an apostrophy in it. Seems the software didn't recognize/accept this type of data. Only took 2years to to discover this 'glitch'!!
Just kiddin, guys!

Thanks for the help on this, Adam & Mike!!! I really enjoyed being able to join in a little last nite. (I think Mike wanted to drive me even closer to the brink, cause he would I/M me at the same time I was "chatting", causing a considerable amount of cornfusion on my part, which, in reality, ain't all that hard to do! )
btw.....who put the fat, nekkid chick on my desktop? Adams' Apple38632.7912384259

____________________________________
Joel Adams
C3VR Lifetime Member #56    
My Link


(click for Texas-sized view!)
             NCRS

"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
 Reply Reply  Quote Reply w/Quote
10/7/05 7:01am - Reply: 'My feelings are hurt, now'
Ron 78 Lifetime Member
Lifetime Member
Moderator
- Send Private Message


BINGHAMTON, NY - USA

Vette(s):


Joined: 7/19/2003
Posts: 3805
Fat,NEKKID CHICK ......?????

____________________________________

C3VR Lifetime Member #93
 
 Reply Reply  Quote Reply w/Quote
10/7/05 7:37pm - Reply: 'My feelings are hurt, now'
74-454 Lifetime Member
Lifetime Member
- Send Private Message


, - Canada

Vette(s):
Coupe 74 - 454 Drive it like you stole it!

Joined: 8/6/2004
Posts: 533
The apostrophy is a string delimiter in the SQL language (Structured Query Language).  By having one in your name, it terminates the one that was started at the beginning of your name and therefor, not including "Apple" AND making the reminder of the SQL command un-compilable. bla bla bla
 
Anyway, I could talk about it all night, but the reason I'm posting, is that I wonder how it was fixed.  Just by adding a second apostrophy to Adam's user name ? or by setting an option somewhere ?
 
If only by adding a second one; you still have a security exposure. It is called "SQL injection".  One of the oldest (and easiest) way to hack a website.  Adam, you can do some google search to familiarize yourself with this kind of threat and then ask your hosting company (and/or the maker of this forum software) if they include some kind of protection for this).  Make sure you tell them that you allow screen name with single quote.
 
In Adam's Apple case, it was a single quote problem, but Iron82 gave some good pointer if it happens to anybody else.  The "chat" might be working on a different port than your http proxy and you could have to punch a whole in your firewall/router if you have a recent and secured one or if you run any application like "Norton" or "ZoneLabs".  It could also be related to a browser that blocks pop-up (mine does : AvantBrowser).
 
Glad you can now get in after that long.
 
 Reply Reply  Quote Reply w/Quote
10/7/05 8:58pm - Reply: 'My feelings are hurt, now'
Adams' Apple Lifetime Member
Lifetime Member
Moderator
- Send Private Message


Duncanville, TX - USA

Vette(s):
#1-1974 L-48 4spd Cp Med Red Metallic/Black deluxe int w/AC/tilt/tele./p/w-p/b/ Am-Fm/map light National/Regional/Chapter NCRS "Top Flight" #2-1985 Bright Red/Carmine Cp.L-98/auto Member: NCRS, NCRS Texas, Corvette Legends of Texas

Joined: 11/8/2003
Posts: 19459
Huh? Adams' Apple38632.7922222222

____________________________________
Joel Adams
C3VR Lifetime Member #56    
My Link


(click for Texas-sized view!)
             NCRS

"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
 Reply Reply  Quote Reply w/Quote
10/7/05 10:21pm - Reply: 'My feelings are hurt, now'
Adam Wartell Lifetime Member
Lifetime Member
C3VR Founder
- Send Private Message


Eagleville, PA - USA

Vette(s):
Used to own a 1979 Corvette now owned by JB79

Joined: 11/1/2001
Posts: 14715

Stephane,

You are right about it being an issue with SQL Server.

As a programmer, I know all too well about the ' in SQL Queries causing a failier.  And when I coded the majority of the pages for this site, I made sure to account for it.  However, I did not write the code for the Chat Room. Apparently that person didn't account for ' in a user name.

The unfortunate part for Adams' Apple, was that he wasn't getting an error message that he could tell me about, and my site didn't report any errors (again, probably because I didn't write that code).

So, for Stephane and other techies... here's the fix:

strSQL = "SELECT * FROM Users WHERE UserName = '" & replace(strUserName, "'", "''") & "'"

Which causes each single ' to turn into two ' right next to each other like this: ''

That tells the database to use the '' as a single ' in the user name and not as part of the database query command.

Everyone confused now?



____________________________________
-Adam Wartell
NCM Lifetime Member #1222
Founder:
C3 Vette Registry (Join C3VR on facebook)
C4 Vette Registry, C6 Vette Registry
C7 Vette Registry
Corvettes for a Cure

My first Vette, now owned by JB79:

 Reply Reply  Quote Reply w/Quote
10/7/05 10:40pm - Reply: 'My feelings are hurt, now'
Ron 78 Lifetime Member
Lifetime Member
Moderator
- Send Private Message


BINGHAMTON, NY - USA

Vette(s):


Joined: 7/19/2003
Posts: 3805
YUP

____________________________________

C3VR Lifetime Member #93
 
 Reply Reply  Quote Reply w/Quote
10/8/05 5:01pm - Reply: 'My feelings are hurt, now'
74-454 Lifetime Member
Lifetime Member
- Send Private Message


, - Canada

Vette(s):
Coupe 74 - 454 Drive it like you stole it!

Joined: 8/6/2004
Posts: 533
Well, the important is that Joel is able to use the chat and Adam has got it under control.
 
Adam, very nice job, I didn't know you were coding it.  I was under the impression that is was a package offered by the hosting company.
 Reply Reply  Quote Reply w/Quote
10/8/05 9:16pm - Reply: 'My feelings are hurt, now'
Adams' Apple Lifetime Member
Lifetime Member
Moderator
- Send Private Message


Duncanville, TX - USA

Vette(s):
#1-1974 L-48 4spd Cp Med Red Metallic/Black deluxe int w/AC/tilt/tele./p/w-p/b/ Am-Fm/map light National/Regional/Chapter NCRS "Top Flight" #2-1985 Bright Red/Carmine Cp.L-98/auto Member: NCRS, NCRS Texas, Corvette Legends of Texas

Joined: 11/8/2003
Posts: 19459
Adam is DA MAN!!!



____________________________________
Joel Adams
C3VR Lifetime Member #56    
My Link


(click for Texas-sized view!)
             NCRS

"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
 Reply Reply  Quote Reply w/Quote
 New Topic New Topic Post Reply Reply New Poll New Poll Search     Search Page [1]  
 Forums -> Official C3 Vette Registry Support/Issues/Comments
(Moderator: Adam Wartell, Norsky, Adams' Apple)
 

 
Official C3 Vette Registry Community:
Home | Forums | Email | Who's Online | Clubs | Events | Member Stats

Other Official C3 Vette Registry Areas:
Members | Research | Shop | My Account | About C3VR
 

Corvette is a registered trademark of the General Motors Corporation(GM) & Chevrolet Motor Division. Vette Registries, LLC is responsible for all site content (except for member submitted content or where otherwise noted) and does not claim or imply that Chevrolet or GM is responsible for Official C3 Vette Registry content. Vette Registries, LLC is independent from GM and is not affiliated with, sponsored or supported by GM.  Copyright/trademark/sales mark infringements are not intended, or implied and are in fact used to support GM, Chevrolet and Corvette

Official C3 Vette Registry content is Copyright 2001-2017, Vette Registries, LLC. Content may not be reused without written consent. All Rights Reserved. NS

Corvette (Vette) Model Years on this site: 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 30