Go Back   MP3Unsigned Forum > Start Here > Support Desk


Support Desk Post technical support queries here for the main site and forum

"
"
Reply
 
LinkBack Thread Tools Search this Thread Display Modes

 
  
Old 05-02-2013, 14:49 PM   #1 (permalink)
Unable to edit Mp3 data
TonyMiller TonyMiller is offline 05-02-2013, 14:49 PM

Me too. Tried it with Safari and Chrome. Same Sql date/time format error.
Also observed some problems with photo gallery.

 
TonyMiller's Avatar
TonyMiller
Software Librarian
Join Date: Jul 2008
Location: United Kingdom
Posts: 3,966
Views: 28
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 05-02-2013, 18:39 PM

TonyMiller's Avatar

Software Librarian
 
Join Date: Jul 2008
Location: United Kingdom
Posts: 3,966
Rep Power: 111
TonyMiller is a splendid one to beholdTonyMiller is a splendid one to beholdTonyMiller is a splendid one to beholdTonyMiller is a splendid one to beholdTonyMiller is a splendid one to beholdTonyMiller is a splendid one to beholdTonyMiller is a splendid one to behold
Default

Darth, I think you'll find we're all having the same problem. It's easy to reproduce. Just select one of your mp3s on your page, edit anything then press submit. Trying to suggest it's down to user's systems is ignoring the great shitty arsed elephant in the room.

It's an sqlDateTime error, untrapped in the code (that's naughty in itself, users should never see diagnostics on code errors).

Here's some of the error message. A .net programmer can trace the fault from this by going through the stack.

Server Error in '/' Application.

SqlDateTime overflow. Must be between 1/1/1753 1200 AM and 12/31/9999 11:59:59 PM.

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.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 1200 AM and 12/31/9999 11:59:59 PM.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 1200 AM and 12/31/9999 11:59:59 PM.]
System.Data.SqlTypes.SqlDateTime.FromTimeSpan(Time Span value) +4838875
System.Data.SqlTypes.SqlDateTime.FromDateTime(Date Time value) +200
System.Data.SqlClient.MetaType.FromDateTime(DateTi me dateTime, Byte cb) +46
System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) +4844309
System.Data.SqlClient.TdsParser.TdsExecuteRPC(_Sql RPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) +4297
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.DoExecuteNonQuery(DbCommand command) +178
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteNonQuery(DbCommand command) +71
MP3Unsigned.Data.TracksDao.UpdateTrack(JamworldTra ck updatedTrack) in TracksDao.cs:81
ArtistCP_EditTrack.Submit_Click(Object sender, EventArgs e) +1670
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.4234; ASP.NET Version:2.0.50727.4223
Reply With Quote
  #3 (permalink)  
Old 05-02-2013, 20:15 PM

Darth Raver's Avatar

Admin Group
 
Join Date: May 2010
Posts: 192
Rep Power: 100
Darth Raver is on a distinguished road
Default

Thank you for your detailed reply Tony. I'm sure it will be useful.

I'm not trying to ignore anything. I have passed on all complaints I have received to the relevant parties.
__________________
Administrator


Follow Us On:
facebook.com/mp3unsigned

twitter.com/mp3unsigned

Last edited by Darth Raver; 06-02-2013 at 01:56 AM..
Reply With Quote
Reply

Bookmarks

Tags
data, edit, mp3, unable


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +2. The time now is 11:09 AM.