Products » Support Forums 

Support Forums

HomeHomeDotNetNuke Modu...DotNetNuke Modu...Inline Link Mas...Inline Link Mas...SQL2K Incompatibility?SQL2K Incompatibility?
Previous
 
Next
New Post
7/24/2009 8:05 PM
 

Hi Guys,

 

I just purchased and installed the latest version and I get errors related to sys.objects when installing. Isn't this a SQL2005+ way to check for the existence of db objects? Is this module intended for SQL2k5 and up only?

 

Thanks,

Ken

 
New Post
7/25/2009 1:13 AM
 

Hi Ken

I don't think there is anything sql 2005 specific in the code (apart from the exists statements).  I'll review it with an eye to making it sql 2k compatible, and repost here when I have done this.

-Bruce


Chief Software Hacker
 
New Post
7/25/2009 5:26 PM
 

Bruce,

 

The new version installs just fine now. Thanks a lot!

 

-Ken


 
New Post
7/25/2009 5:32 PM
 

Bruce,

 

Unfortunately now when I try to add a new replacement I get this:

UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.7) Gecko/2009021910 Firefox/3.0.7
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 5aa10ca1-01ae-4262-a496-accae9f2b05b
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:

 
New Post
7/26/2009 1:55 AM
 

Good to see it installed OK, bad to see you struck further problems.

Can you tell me what version DNN you have it installed on?  I'll need to see if I can recreate this error.


Chief Software Hacker
 
Previous
 
Next
HomeHomeDotNetNuke Modu...DotNetNuke Modu...Inline Link Mas...Inline Link Mas...SQL2K Incompatibility?SQL2K Incompatibility?


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.