Products » Support Forums 

Support Forums

HomeHomeDotNetNuke Modu...DotNetNuke Modu...Inline Link Mas...Inline Link Mas...Cannot add ReplacementCannot add Replacement
Previous
 
Next
New Post
7/15/2009 12:34 PM
 

I receive the following error when I click on 'Add Replacement':

A critical error has occurred.
Arithmetic overflow error converting expression to data type int. The statement has been terminated.

Details from the event log:

AssemblyVersion: 5.1.0
PortalID: 0
PortalName: City of Wilmington - Official Website
UserID: 67
UserName: alex
ActiveTabID: 591
ActiveTabName: Inline Links
RawURL: /Admin/InlineLinks/tabid/591/ctl/Edit/mid/3410/rkey/0b508ba0-a9c8-41b6-b43b-527385162af7/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://public2008/Admin/InlineLinks/tabid/591/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1) Gecko/20090624 Firefox/3.5 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: ffd71af9-d936-489e-af92-46d333d0ed3c
InnerException: Arithmetic overflow error converting expression to data type int. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Arithmetic overflow error converting expression to data type int. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type int. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at iFinity.DNN.Modules.InlineLinkMaster.Data.SqlDataProvider.GetTabs(String search, Int32 page, Int32 startRec, Int32 endRec, Int32 portalId, Boolean& moreRecords) at iFinity.DNN.Modules.InlineLinkMaster.TabControllerEx.GetTabs(String search, Int32 page, Int32 startRec, Int32 endRec, Int32 portalId, Boolean& moreRecords) at iFinity.DNN.Modules.Common.UI.Controls.TabSelect.TabsToScreen() at iFinity.DNN.Modules.Common.UI.Controls.TabSelect.ShowTabs(TabSelectType selectionType, Boolean showAdmin, Boolean showHidden, Int32 portalId, List`1 selectedTabs, String localResourceFile) at iFinity.DNN.Modules.InlineLinkMaster.UI.Controls.EditInlineLink.ReplacementToScreen(Int32 portalId) at iFinity.DNN.Modules.InlineLinkMaster.UI.Controls.EditInlineLink.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name:---------

 

Any thoughts?

Thanks!

Alex Shiplett

 

 
New Post
7/15/2009 12:38 PM
 

Some more detail on this one:

It adds a row, but does not allow me to edit it - so all that I end up seeing is 'Delete' and 'Edit' - when I click 'Edit', I get the same error as above, and delete deletes the module.

Thanks!

Alex

 
New Post
7/17/2009 3:25 PM
 

So, I went into the database and entered in values for the replacement that was created with an error - i.e., blank replacement mentioned above.

Once the data is in there, I can successfully edit it.

However, when it displays in the list, it displays the value of the replacement field as both find and replace.

And, it doesn't actually replace anything, that I could see - which is a potentially big issue.

Thanks,

Alex

 

 
New Post
7/17/2009 8:24 PM
 

Hi Alex

I'm working on recreating your error.  If you added the record manually, it's possible that something may not have been setup right for the replacement to work.  I'll come back to you as soon as possible.

-Bruce

 
New Post
7/18/2009 11:29 AM
 

Bruce,

Originally, I clicked on the button to create the record, which is when I initially received that error.  Later, when I realized that the record existed, but was empty, I went into the database and added information that way, to see if that would address the problem, but it didn't.

Alex

 

 
Previous
 
Next
HomeHomeDotNetNuke Modu...DotNetNuke Modu...Inline Link Mas...Inline Link Mas...Cannot add ReplacementCannot add Replacement


Support Guidelines.. Please read before posting

To get support on iFinity products and services, please search the forums for the the answer to the problem you are seeking. If you cannot find a solution, post a question in the relevant forum.   Ensure that you specify the relevant versions of the problem, and the actual error message or a detailed description of the problem.    You will need to register with this site to post on the forum.  If you have a Microsoft Live (Hotmail/Passport) account you can use that.  If you have a Open Id account you can use that.  If you neither of these, you will need to register a user Id and password.