Problem with the Library

from GalCiv2 Forums

I have a upload waiting approval in the Library, that's not my problem.  What is the problem is that I've been trying to edit it and I get this message:

Server Error in '/' Application.

String or binary data would be truncated.
The statement has been terminated.

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.
The statement has been terminated.

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: 

[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +149
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
   SDNetLib.DB.NonQuery(String Sql, ArrayList Params, String ConnectString, SqlConnection& Connection, Int32 CommandTimeout) +256
   MvLib.LibDB.mod_user_update(Object ModID, Object Desc, Object Category, Object Version, Object MinVersion, Object Name, Object Size, Object ModFile, String ScreenFile, String FullScreenFile) +515
   MvLib.editmod.ProcessEdit() +3943
   MvLib.editmod.PostMod_Click(Object sender, ImageClickEventArgs e) +174
   System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
   System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

I'm assuming this is a Stardock problem and not my system doing this since I tried it now on two seperate computers using two different Internet providers.
modding
7,676 views 13 replies
Reply #1 from GalCiv2 Forums Top
Try uploading your mods at www.i-mod-productions.com/they could really use the mods plus there lack of star trek mods is limited only one mod sofar.Plus there not as strict as galciv they still follow copyright laws they just don't mind images of actors.So try the websight out you might like what you see because thats where I upload all my mods.
Reply #2 from GalCiv2 Forums Top
Try uploading your mods at they could really use the mods plus there lack of star trek mods is limited only one mod sofar.Plus there not as strict as galciv they still follow copyright laws they just don't mind images of actors.So try the websight out you might like what you see because thats where I upload all my mods.WWW Link
Elemental: Reforged
Reply #3 from GalCiv2 Forums Top
Yep, that'd be a server error. Works fine for me, but for the time being if it still acts up for you, you can just upload a new item and note in the pending mods thread to hide the old one.
Reply #4 from GalCiv2 Forums Top
Its still doing it. I don't get it. How can I have this problem with work and home computers when they are on different servers?
Reply #5 from GalCiv2 Forums Top
The error is on *our* server.
Reply #6 from GalCiv2 Forums Top
Gotcha. Well I've had this problem since Sunday Afternoon.
Reply #7 from GalCiv2 Forums Top
Ok this time I messed up. I kept trying to upload the new file and it finally went through but I forgot to change the stupid mod title. So now once again I'm trying to edit but I get that message again.

AHHHH! So close.
Reply #8 from GalCiv2 Forums Top
The error sounds like the database schema for mod submissions has a string (varchar/nvarchar, not text/ntext) field with a size limitation, and this size check was not being performed on the web tier so any user input exceeding that limit is still sent to the database, which then pukes in a fairly unkind fashion.

This would be a problem on Stardock's side (either remove the size limit or have too-long user input result in a user-friendly error message), but you could work around it by shortening any particularly long string inputs (description fields and whatnot) and seeing if it fits within the limit.

Could be the title field too, never know.
Reply #9 from GalCiv2 Forums Top
BTW, Kryo, in case y'all haven't already done this it'd be good to turn off the customError display to us end users. SQL Injection can be a terrible thing, and those error messages provide quite a bit of information to someone trying it.
Reply #10 from GalCiv2 Forums Top
okay I understood the word "pukes"

:)
Reply #11 from GalCiv2 Forums Top
lol, sorry.

Then let me try this: "you entered too much text into one of the form fields when submitting the mod"
Reply #12 from GalCiv2 Forums Top
actualy the text for the new mod title is few letters then the last one.