Unable to Upload Photos to Race Report (SQL error)

Forum guidelines BT super discount
Site Issues Training Log & Site Support » Unable to Upload Photos to Race Report (SQL error) Rss Feed  
Moderators: k9car363, alicefoeller Reply
2014-11-29 3:55 PM

User image

Master
9705
500020002000500100100
Raleigh, NC area
Subject: Unable to Upload Photos to Race Report (SQL error)

Server Error in '/' Application.

String or binary data would be truncated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.

Source Error: 

Line 169:                InternalPathThumbnail = fullInternalPathThumbnailLine 170:            };Line 171:        rldh.SaveRacePhoto(photo);Line 172:        Line 173:        if (photo.PhotoId <= 0)


Source File: c:\HostingSpaces\beginnertri\beginnertriathlete.com\wwwroot\Services\RacesService.ashx    Line: 171 

Stack Trace: 

[SqlException (0x80131904): String or binary data would be truncated.]   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +322   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +230   System.Data.SqlClient.SqlDataReader.Read() +34   System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +42   System.Data.SqlClient.SqlCommand.ExecuteScalar() +160   BT.DataHelpers.BTDataHelpers.RaceLogDataHelper.SaveRacePhoto(RacePhoto saveEntity) in c:\inetpub\staging\BTNew\Projects\BTDataHelpers\RaceLogDataHelper.cs:2959   AlbumsService.SaveRacePhoto(HttpContext context, SecurityContext sc, HttpPostedFile postedFile, String basePath, Int32 raceId, Int32 slotNumber) in c:\HostingSpaces\beginnertri\beginnertriathlete.com\wwwroot\Services\RacesService.ashx:171   AlbumsService.UploadPhoto(HttpContext context, SecurityContext sc) in c:\HostingSpaces\beginnertri\beginnertriathlete.com\wwwroot\Services\RacesService.ashx:139   AlbumsService.ProcessRequest(HttpContext context) in c:\HostingSpaces\beginnertri\beginnertriathlete.com\wwwroot\Services\RacesService.ashx:34   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69

 

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34237

2014-12-01 7:46 AM
in reply to: jmkizer

User image

Champion
13323
5000500020001000100100100
Gold member
Subject: RE: Unable to Upload Photos to Race Report (SQL error)

This should be fixed.  We extended the allowable characters for photo names.

New Thread
Site Issues Training Log & Site Support » Unable to Upload Photos to Race Report (SQL error) Rss Feed  
RELATED POSTS

Problems uploading photos to race report

Started by jmkizer
Views: 804 Posts: 3

2013-08-07 5:32 PM csharp1171

HELP - uploading photos on my race report

Started by The Nat
Views: 909 Posts: 2

2009-08-18 3:44 PM marmadaddy

SQL Server error

Started by CptnJackSparrow
Views: 1822 Posts: 6

2007-07-30 1:21 PM Ron

race report error?

Started by DrLeah
Views: 749 Posts: 4

2006-03-14 10:23 PM DrLeah

Race report error

Started by Pulch
Views: 1275 Posts: 7

2005-04-01 11:16 AM Pulch
RELATED ARTICLES
Rev3 Cedar Point 2010; First iron distance tri
date : June 27, 2011
author : alicefoeller
comments : 8
A middle-of-the-pack triathlete takes on the iron distance for the first time at Rev3's inaugural full distance race
 
VIDEO: Ironman Wisconsin BT Mini-Camp
date : July 14, 2008
author : Birkierunner
comments : 2
Watch the highlights and tips of this years IMWI BT mini-camp put on by Birkierunner.
Upload Your Workout Data to BT's Training Log
date : June 18, 2008
author : Team BT
comments : 3
Easily transfer your workout data from your Garmin, Polar, Timex and more directly into your BT training log. Eliminate the manual entries. Save time!
 
Musselman 2007 Full Race Video, Race Reports and Pictures
date : July 23, 2007
author : Ron
comments : 2
See the Musselman, Mini-Mussel, the ITU Race and the Mussel Kids race video feeds, race reports and pictures.
Mooseman 2007 Full Race Video, Race Reports and Pictures
date : June 6, 2007
author : Ron
comments : 4
Coverage of the entire Mooseman Triathlon Festival with race video feeds, race reports and pictures.
 
My Very First Race Report-Muskoka Sprint Distance, June 17 2006
date : July 2, 2006
author : susietri
comments : 6
Race report for my first sprint triathlon in which I tell the tale of panic and redemption.
I TRI'd - An Unusual Race Report
date : November 27, 2005
author : Team BT
comments : 0
The toll of fate strikes as those with orange swim caps are beckoned to begin the journey. Ahhh, nothing like the feel of ice cold water seeping in your wetsuit to wake you up. GO!
 
Your Races: Triathlon and Multisport Race Report Log
date : April 21, 2005
author : Ron
comments : 1
How to use our detailed online race log to track your season and progress.