Other Resources My Cup of Joe » USAT Registration: Rss Feed  
Moderators: k9car363, the bear, DerekL, alicefoeller Reply
2006-02-12 3:39 PM

User image

Champion
5183
5000100252525
Wisconsin
Subject: USAT Registration:

GRRR. I decided to become a USAT member.  Great. more $$ spent on this sport, but it has become an impt part of my life, so I was ready to pony up and contribute.  I go through all of the online registration, and get this message:

"We're sorry!

We could not complete your transation at this time.Your credit card ending in xxxx has been processed. Unfortunately we could not update your Member record information due to an error with the data. Please contact USA Triathlon and notify them.

Detailed Message: The conversion of the nvarchar value 'xxxxxxxxxxx' overflowed an int column. Maximum integer value exceeded."

 

OK, so they process my credit card regardless of whether they can register me? How nuts is that?

 



2006-02-12 3:48 PM
in reply to: #344134

User image

Master
2033
200025
Subject: RE: USAT Registration:
Tell them just for that you will be racing shirtless at your next race!
2006-02-12 3:53 PM
in reply to: #344134

User image

Champion
5183
5000100252525
Wisconsin
Subject: RE: USAT Registration:
HA!  they will be paying ME to keep the gut covered, it's not a pretty sight!
2006-02-12 3:55 PM
in reply to: #344134

User image

Champion
8936
50002000100050010010010010025
Subject: RE: USAT Registration:
For some reason the numbers from your credit card got replaced by x's.  You can just PM me the real numbers, and I'll take care of it for you. 
2006-02-12 4:27 PM
in reply to: #344134

User image

Giver
18427
5000500050002000100010010010010025
Subject: RE: USAT Registration:

Yeah, that's dumb but something a phone call should fix.

Annoying, though... 

2006-02-12 5:24 PM
in reply to: #344134

User image

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: USAT Registration:
Actually, that looks like it is a problem with the way their database is built.  The column that should hold your credit card number wasn't made large enough to hold the value of the credit card number.  Bad bad planning on their part.


2006-02-12 9:40 PM
in reply to: #344134

User image

Master
2946
200050010010010010025
Centennial, CO
Subject: RE: USAT Registration:
Actually last weekend I got the opposite email that my credit card didn't process so I had to renew. I actually called them and they were really good about fixing things up.
2006-02-13 5:06 AM
in reply to: #344203

User image

Champion
11641
50005000100050010025
Fairport, NY
Subject: RE: USAT Registration:

Artemis - 2006-02-12 6:24 PM Actually, that looks like it is a problem with the way their database is built. The column that should hold your credit card number wasn't made large enough to hold the value of the credit card number. Bad bad planning on their part.

Or, more likely, bad planning on the part of whoever USAT hired to create the app.

And as a semi-nerdy point, it's usually a stored procedure that was coded with too-small datatype in these instances rather than a table.

2006-02-13 7:45 AM
in reply to: #344422

User image

Giver
18427
5000500050002000100010010010010025
Subject: RE: USAT Registration:
marmadaddy - 2006-02-13 6:06 AM

And as a semi-nerdy point, it's usually a stored procedure that was coded with too-small datatype in these instances rather than a table.

If I were a gay man I'd be swooning about now.

2006-02-13 7:58 AM
in reply to: #344134

User image

Wife, Mother, Friend.
2457
20001001001001002525
South
Subject: RE: USAT Registration:

maybe they use the same folks who set up the St A's registration. 

2006-02-13 8:58 AM
in reply to: #344422

User image

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: USAT Registration:
marmadaddy - 2006-02-13 6:06 AM

Or, more likely, bad planning on the part of whoever USAT hired to create the app.

And as a semi-nerdy point, it's usually a stored procedure that was coded with too-small datatype in these instances rather than a table.

That's what happens when I look at error messages while trying to do my database homework.  Everything looks like table errors.   



New Thread
Other Resources My Cup of Joe » USAT Registration: Rss Feed