|
|
|
|
 | SearchForum Home | |
| | |
| | |
| | |
 | | |
|
|
|
| Lots of errors during install |
|
|
All of the following sql errors occurred during installation. I cannot seem to add any articles. Is there a better manual that the one page description "help" that is on the site?
|
Resource Upload Logs
|
|
|
|
StartJob
|
Starting Installation
|
|
StartJob
|
Reading files
|
|
Info
|
Loading 01.00.02.SqlDataProvider
|
|
Info
|
File 01.00.02.SqlDataProvider read successfully
|
|
Info
|
Loading 01.00.03.SqlDataProvider
|
|
Info
|
File 01.00.03.SqlDataProvider read successfully
|
|
Info
|
Loading subCategory_edit.ascx
|
|
Info
|
File subCategory_edit.ascx read successfully
|
|
Info
|
Loading subCategory2_edit.ascx
|
|
Info
|
File subCategory2_edit.ascx read successfully
|
|
Info
|
Loading Icon_Edit.ascx
|
|
Info
|
File Icon_Edit.ascx read successfully
|
|
Info
|
Loading Articles_Seq.ascx
|
|
Info
|
File Articles_Seq.ascx read successfully
|
|
Info
|
Loading EventsServer.aspx
|
|
Info
|
File EventsServer.aspx read successfully
|
|
Info
|
Loading Articles_NextBack.aspx
|
|
Info
|
File Articles_NextBack.aspx read successfully
|
|
Info
|
Loading Icon.aspx
|
|
Info
|
File Icon.aspx read successfully
|
|
Info
|
Loading 01.00.05.SqlDataProvider
|
|
Info
|
File 01.00.05.SqlDataProvider read successfully
|
|
Info
|
Loading Uninstall.SqlDataProvider
|
|
Info
|
File Uninstall.SqlDataProvider read successfully
|
|
Info
|
Loading category_edit.ascx
|
|
Info
|
File category_edit.ascx read successfully
|
|
Info
|
Loading Articles_show.ascx
|
|
Info
|
File Articles_show.ascx read successfully
|
|
Info
|
Loading Display_Edit.ascx
|
|
Info
|
File Display_Edit.ascx read successfully
|
|
Info
|
Loading janet.Articles.SqlDataProvider.dll
|
|
Info
|
File janet.Articles.SqlDataProvider.dll read successfully
|
|
Info
|
Loading janet.Articles.dnn
|
|
Info
|
File janet.Articles.dnn read successfully
|
|
Info
|
Loading resources.zip
|
|
Info
|
File resources.zip read successfully
|
|
Info
|
Loading 01.00.07.SqlDataProvider
|
|
Info
|
File 01.00.07.SqlDataProvider read successfully
|
|
Info
|
Loading janet.Articles.dll
|
|
Info
|
File janet.Articles.dll read successfully
|
|
Info
|
Loading Articles_Edit.ascx
|
|
Info
|
File Articles_Edit.ascx read successfully
|
|
EndJob
|
Reading files done.
|
|
|
|
StartJob
|
Reading DNN file
|
|
Info
|
DNN file is in valid 3.0 format.
|
|
Info
|
xml loaded.
|
|
Info
|
Loading files info
|
|
Info
|
Loading Modules info
|
|
Info
|
Loading Control info for janet.Articles module
|
|
EndJob
|
Dnn load finished successfully
|
|
|
|
StartJob
|
Begin Sql execution
|
|
Info
|
Executing 01.00.02.SqlDataProvider
|
|
StartJob
|
Start Sql execution: 01.00.02.SqlDataProvider file
|
|
EndJob
|
End Sql execution: 01.00.02.SqlDataProvider file
|
|
|
|
Info
|
Executing 01.00.03.SqlDataProvider
|
|
StartJob
|
Start Sql execution: 01.00.03.SqlDataProvider file
|
|
Failure
|
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --delete original stored procedures if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_GetArticle) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_GetArticle System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_GetArticleList) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_GetArticleList System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_AddArticle) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_AddArticle System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_UpdateArticle) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_UpdateArticle System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_UpdateArticle) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_UpdateArticle System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --look at eleting new ones if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_AddSubCategory2) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_JanetArticles_AddSubCategory2 System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_DeleteSubCategory2) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_JanetArticles_DeleteSubCategory2 System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_GetSubCategory2) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_GetSubCategory2 System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_GetSubCategory2List) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_GetSubCategory2List System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_GetSubCategory2LiveList) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_JanetArticles_GetSubCategory2LiveList System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_UpdateSubCategory2) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_UpdateSubCategory2 System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --Alter table if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_Articles) and OBJECTPROPERTY(id, NIsUserTable) = 1) ALTER TABLE dbo.ham_JanetArticles_Articles ADD SubCategory2 varchar(100) System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. Invalid column name SubCategory2. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_Articles) and OBJECTPROPERTY(id, NIsUserTable) = 1) UPDATE dbo.ham_JanetArticles_Articles set SubCategory2 = ;; System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --add new table if not exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_SubCategories2) and OBJECTPROPERTY(id, NIsUserTable) = 1) CREATE TABLE dbo.ham_JanetArticles_SubCategories2 ( [ID] [int] IDENTITY (1, 1) NOT NULL , [ModuleID] [int] NOT NULL , [PortalID] [int] NOT NULL , [Name] [nvarchar] (50) , [Live] [bit] NULL , [Image] [nvarchar] (100) , [Sticky] [bit] NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Invalid column name SubCategory2. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --replace old stored procedures --noted following items missing --dbo.ham_janetArticles_Articles.RatingTotal, --dbo.ham_janetArticles_Articles.RatingCount, create procedure dbo.ham_janetArticles_GetArticle @ModuleID int, @PortalID int, @ID int, @Mode nvarchar(20), @Page int AS if @Mode = Review BEGIN if @Page < 2 BEGIN IF (SELECT NumViews FROM dbo.ham_JanetArticles_Articles WHERE id = @ID ) Is Not NULL BEGIN UPDATE dbo.ham_JanetArticles_Articles SET NumViews = ( SELECT NumViews + 1 FROM dbo.ham_JanetArticles_Articles WHERE id = @ID ) WHERE id = @ID END ELSE BEGIN UPDATE dbo.ham_JanetArticles_Articles SET NumViews = 1 WHERE id = @ID END END END SELECT dbo.ham_JanetArticles_Articles.ID, dbo.ham_JanetArticles_Articles.Title, dbo.ham_JanetArticles_Articles.URL_ext, dbo.ham_JanetArticles_Articles.URL_int, dbo.ham_JanetArticles_Articles.Category, dbo.ham_JanetArticles_Articles.SubCategory, dbo.ham_JanetArticles_Articles.SubCategory2, dbo.ham_JanetArticles_Articles.Description, dbo.ham_JanetArticles_Articles.EditRoles, dbo.ham_JanetArticles_Articles.Summary, dbo.ham_JanetArticles_Articles.MetaTitle, dbo.ham_JanetArticles_Articles.MetaDescription, dbo.ham_JanetArticles_Articles.MetaKeywords, dbo.ham_JanetArticles_Articles.Sticky, dbo.ham_JanetArticles_Articles.Live, dbo.ham_JanetArticles_Articles.StartDate, dbo.ham_JanetArticles_Articles.EndDate, dbo.ham_JanetArticles_Articles.NumViews, dbo.ham_JanetArticles_Articles.LastUpdate, dbo.ham_JanetArticles_Articles.Gallery0, dbo.ham_JanetArticles_Articles.Gallery1, dbo.ham_JanetArticles_Articles.Gallery2, dbo.ham_JanetArticles_Articles.Gallery3, dbo.ham_JanetArticles_Articles.Gallery4, dbo.ham_JanetArticles_Articles.TextGallery0, dbo.ham_JanetArticles_Articles.TextGallery1, dbo.ham_JanetArticles_Articles.TextGallery2, dbo.ham_JanetArticles_Articles.TextGallery3, dbo.ham_JanetArticles_Articles.TextGallery4, dbo.ham_JanetArticles_Articles.RatingMsgs, dbo.ham_JanetArticles_Articles.RatingAll, dbo.ham_janetArticles_Articles.RatingTotal, dbo.ham_janetArticles_Articles.RatingCount, dbo.ham_JanetArticles_Articles.IconID FROM dbo.ham_JanetArticles_Articles WHERE dbo.ham_JanetArticles_Articles.PortalID = @PortalID AND ID = @ID System.Data.SqlClient.SqlException: Invalid column name SubCategory2. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.ham_JanetArticles_AddArticle @ModuleID int, @PortalID int, @Title varchar(100), @URL_int varchar(100), @URL_ext varchar(100), @Category varchar(100), @SubCategory varchar(100), @SubCategory2 varchar(100), @Description text, @EditRoles varchar(100), @Summary varchar(150), @StartDate datetime, @EndDate datetime, @LastUpdate datetime, @MetaTitle varchar(200), @MetaDescription varchar(250), @MetaKeywords varchar(800), @Sticky bit, @Live bit, @RatingAll bit, @RatingMsgs bit, @IconID int AS INSERT INTO dbo.ham_JanetArticles_Articles ( PortalID, ModuleID, Title, URL_int, URL_ext, Category, SubCategory, SubCategory2, Description, EditRoles, Summary, StartDate, EndDate, LastUpdate, MetaTitle, MetaDescription, MetaKeywords, Sticky, Live, RatingAll, RatingMsgs, IconID ) VALUES ( @PortalID, @ModuleID, @Title, @URL_int, @URL_ext, @Category, @SubCategory, @SubCategory2, @Description, @EditRoles, @Summary, @StartDate, @EndDate, @LastUpdate, @MetaTitle, @MetaDescription, @MetaKeywords, @Sticky, @Live, @RatingAll, @RatingMsgs, @IconID ) SELECT SCOPE_IDENTITY() System.Data.SqlClient.SqlException: Invalid column name SubCategory2. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.ham_janetArticles_UpdateArticle @ModuleID int, @PortalID int, @Title varchar(100), @URL_int varchar(100), @URL_ext varchar(100), @Category varchar(100), @SubCategory varchar(100), @SubCategory2 varchar(100), @Description text, @EditRoles varchar(100), @Summary varchar(150), @StartDate datetime, @EndDate datetime, @LastUpdate datetime, @MetaTitle varchar(200), @MetaDescription varchar(250), @MetaKeywords varchar(250), @Sticky bit, @Live bit, @RatingAll bit, @RatingMsgs bit, @IconID int, @ID int AS UPDATE dbo.ham_janetArticles_Articles SET Title = @Title, URL_int = @URL_int, URL_ext = @URL_ext, Category = @Category, SubCategory = @SubCategory, SubCategory2 = @SubCategory2, Description = @Description, EditRoles = @EditRoles, Summary = @Summary, StartDate = @StartDate, EndDate = @EndDate, LastUpdate = @LastUpdate, MetaTitle = @MetaTitle, MetaDescription = @MetaDescription, MetaKeywords = @MetaKeywords, Sticky = @Sticky, Live = @Live, RatingAll = @RatingAll, RatingMsgs = @RatingMsgs, IconID = @IconID WHERE PortalID = @PortalID AND ID = @ID System.Data.SqlClient.SqlException: Invalid column name SubCategory2. The multi-part identifier "janetArticles_Articles.sticky" could not be bound. Invalid column name SubCategory2. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.ham_JanetArticles_GetArticleList @ModuleID int, @PortalID int, @Live bit, @Style varchar(20), @Number int, @Filter varchar(10), @Category varchar(20), @SubCategory varchar(20), @SubCategory2 varchar(20), @NumDays int AS if @Style = Article BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE PortalID = @PortalID AND Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, StartDate) AND getdate() BETWEEN StartDate AND EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY sticky DESC, title END ELSE IF @Style = RSS BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.url_int AS url_int, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories on dbo.ham_janetArticles_Articles.category LIKE %; + convert(varchar(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() between dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() between dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY StartDate desc END ELSE IF @Style = NewsScroll BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.Gallery0 AS Gallery0, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories ON dbo.ham_janetArticles_Articles.category LIKE %; + convert(varchar(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY NEWID() END ELSE IF @Style = Rotating BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.Gallery0 AS Gallery0, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories ON dbo.ham_janetArticles_Articles.category LIKE %; + convert(varchar(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.gallery0 <> AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY NEWID() END ELSE IF @Style = Grid BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles --inner JOIN janetArticles_categories on janetArticles_Articles.category LIKE % + janetArticles_categories.name + % --inner JOIN JanetArticles_CategoriesPlus ON JanetArticles_Categories.ID = JanetArticles_CategoriesPlus.CategoriesID WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() between dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END ELSE IF @Style = Listing BEGIN SET ROWCOUNT @number SELECT * FROM janetArticles_Articles WHERE live = 1 AND PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, StartDate) AND getdate() BETWEEN StartDate AND EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END ELSE IF @Style = IconList BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.Title AS Title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_Icons.Image AS IconImage FROM janetArticles_Articles LEFT OUTER JOIN janetArticles_Icons ON dbo.ham_janetArticles_Articles.IconId = dbo.ham_janetArticles_Icons.ID WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, StartDate) AND getdate() BETWEEN StartDate AND EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY janetArticles_Articles.title END ELSE IF @Style = Directory0 --search in the title/name BEGIN SET ROWCOUNT @number SELECT id, image_small, image_large, category, live, description, url_ext, summary, url_int, title, startdate, enddate, lastupdate, subcategory, editroles, metatitle, metadescription, metakeywords, sticky FROM janetArticles_Articles WHERE live = 1 AND PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, StartDate) AND getdate() BETWEEN StartDate AND EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) AND title LIKE @Filter ORDER BY sticky DESC, title END ELSE IF @Style = Directory1 --search in the summary BEGIN SET ROWCOUNT @number SELECT id, image_small, image_large, category, live, description, url_ext, summary, url_int, title, startdate, enddate, lastupdate, subcategory, editroles, metatitle, metadescription, metakeywords, sticky FROM dbo.ham_janetArticles_Articles WHERE live = 1 AND PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, StartDate) AND getdate() BETWEEN StartDate AND EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) AND summary LIKE @Filter ORDER BY sticky DESC, title END ELSE IF @Style = Edit0 --search in the summary BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE PortalID = @PortalID AND title LIKE @Filter AND Category LIKE @Category ORDER BY sticky DESC, title END ELSE IF @Style = Edit1 --search in the summary BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE PortalID = @PortalID AND Summary LIKE @Filter AND Category LIKE @Category ORDER BY sticky DESC, title END
|
|
EndJob
|
End Sql execution: 01.00.03.SqlDataProvider file
|
|
|
|
Info
|
Executing 01.00.05.SqlDataProvider
|
|
StartJob
|
Start Sql execution: 01.00.05.SqlDataProvider file
|
|
Failure
|
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --following stored procedures are to be updated -- JanetArticles_AddArticle -- JanetArticles_AddCategory.sql -- JanetArticles_AddCategorySearch.sql -- JanetArticles_GetArticle -- JanetArticles_GetArticleList -- janetArticles_GetCategory -- JanetArticles_UpdateArticle -- janetArticles_UpdateCategory --following tables and fields are to be added -- janetarticles_articles -- Seq -- SKU -- Name --following tables and fields are to be changed -- janetarticles_articles -- Title -- URL_ext if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_Articles) and OBJECTPROPERTY(id, NIsUserTable) = 1) ALTER TABLE dbo.ham_JanetArticles_Articles ADD Seq int System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_Articles) and OBJECTPROPERTY(id, NIsUserTable) = 1) ALTER TABLE dbo.ham_JanetArticles_Articles ADD SKU int System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_Articles) and OBJECTPROPERTY(id, NIsUserTable) = 1) ALTER TABLE dbo.ham_JanetArticles_Articles ADD Name nvarchar(150) System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_Articles) and OBJECTPROPERTY(id, NIsUserTable) = 1) ALTER TABLE dbo.ham_JanetArticles_Articles ALTER COLUMN Title nvarchar(150) System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_Articles) and OBJECTPROPERTY(id, NIsUserTable) = 1) ALTER TABLE dbo.ham_JanetArticles_Articles ALTER COLUMN URL_ext nvarchar(150) System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_AddArticle) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_JanetArticles_AddArticle System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_GetArticle) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_JanetArticles_GetArticle System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_GetArticleList) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_JanetArticles_GetArticleList System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_JanetArticles_UpdateArticle) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_JanetArticles_UpdateArticle System.Data.SqlClient.SqlException: Invalid object name dbo.ham_sysobjects. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.ham_sysobjects where id = object_id(Ndbo.ham_janetArticles_UpdateCategory) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure dbo.ham_janetArticles_UpdateCategory System.Data.SqlClient.SqlException: Invalid column name Name. Invalid column name SubCategory2. Invalid column name Seq. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.ham_janetArticles_GetArticle @ModuleID int, @PortalID int, @ID int, @Mode varchar(20), @Page int AS if @Mode = Review BEGIN if @Page < 2 BEGIN IF (SELECT NumViews FROM dbo.ham_janetArticles_Articles WHERE id = @ID ) Is Not NULL BEGIN UPDATE dbo.ham_janetArticles_Articles SET NumViews = ( SELECT NumViews + 1 FROM dbo.ham_janetArticles_Articles WHERE id = @ID ) WHERE id = @ID END ELSE BEGIN UPDATE dbo.ham_janetArticles_Articles SET NumViews = 1 WHERE id = @ID END END END SELECT dbo.ham_janetArticles_Articles.ID, dbo.ham_janetArticles_Articles.Title, dbo.ham_janetArticles_Articles.Name, dbo.ham_janetArticles_Articles.URL_ext, dbo.ham_janetArticles_Articles.URL_int, dbo.ham_janetArticles_Articles.Category, dbo.ham_janetArticles_Articles.SubCategory, dbo.ham_janetArticles_Articles.SubCategory2, dbo.ham_janetArticles_Articles.Description, dbo.ham_janetArticles_Articles.EditRoles, dbo.ham_janetArticles_Articles.Summary, dbo.ham_janetArticles_Articles.MetaTitle, dbo.ham_janetArticles_Articles.MetaDescription, dbo.ham_janetArticles_Articles.MetaKeywords, dbo.ham_janetArticles_Articles.Sticky, dbo.ham_janetArticles_Articles.Live, dbo.ham_janetArticles_Articles.StartDate, dbo.ham_janetArticles_Articles.EndDate, dbo.ham_janetArticles_Articles.NumViews, dbo.ham_janetArticles_Articles.LastUpdate, dbo.ham_janetArticles_Articles.RatingMsgs, dbo.ham_janetArticles_Articles.RatingAll, dbo.ham_janetArticles_Articles.RatingTotal, dbo.ham_janetArticles_Articles.RatingCount, dbo.ham_janetArticles_Articles.IconID, dbo.ham_janetArticles_Articles.Seq FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.PortalID = @PortalID AND ID = @ID System.Data.SqlClient.SqlException: Invalid column name Seq. Invalid column name Seq. Invalid column name SubCategory2. Invalid column name SubCategory2. Invalid column name Seq. Invalid column name SubCategory2. Invalid column name SubCategory2. Invalid column name seq. Invalid column name SubCategory2. Invalid column name SubCategory2. Invalid column name Seq. Invalid column name SubCategory2. Invalid column name SubCategory2. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.ham_JanetArticles_GetArticleList @ModuleID int, @PortalID int, @Live bit, @Style varchar(20), @Number int, @Filter varchar(10), @Category varchar(20), @SubCategory varchar(20), @SubCategory2 varchar(20), @NumDays int, @UseSeq bit AS -- Show single article -- ###### ###### ###### ###### ###### if @Style = Article BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE PortalID = @PortalID AND Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, StartDate) AND getdate() BETWEEN StartDate AND EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END -- RSS -- ###### ###### ###### ###### ###### ELSE IF @Style = RSS BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.url_int AS url_int, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories ON dbo.ham_janetArticles_Articles.category LIKE %; + CONVERT(VARCHAR(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() between dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() between dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.StartDate desc END -- Scrolling news articles -- ###### ###### ###### ###### ###### ELSE IF @Style = NewsScroll BEGIN if @UseSeq = 0 BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.Gallery0 AS Gallery0, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories ON dbo.ham_janetArticles_Articles.category LIKE %; + convert(varchar(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY NEWID() END ELSE BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.Gallery0 AS Gallery0, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories ON dbo.ham_janetArticles_Articles.category LIKE %; + convert(varchar(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.Seq END END -- rotating -- ###### ###### ###### ###### ###### ELSE IF @Style = Rotating BEGIN if @UseSeq = 0 BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.Gallery0 AS Gallery0, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories ON dbo.ham_janetArticles_Articles.category LIKE %; + convert(varchar(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.gallery0 <> AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY NEWID() END ELSE BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.ID AS ID, dbo.ham_janetArticles_Articles.PortalId AS PortalID, dbo.ham_janetArticles_Articles.Category AS Category, dbo.ham_janetArticles_Articles.Gallery0 AS Gallery0, dbo.ham_janetArticles_Articles.StartDate AS StartDate, dbo.ham_janetArticles_Articles.EndDate AS EndDate, dbo.ham_janetArticles_Articles.live AS live, dbo.ham_janetArticles_Articles.title AS title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_categories.PreviewURL AS PreviewURL FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN dbo.ham_janetArticles_categories ON dbo.ham_janetArticles_Articles.category LIKE %; + convert(varchar(5),dbo.ham_janetArticles_categories.id) + ;% WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.gallery0 <> AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.Seq END END -- grid layout -- ###### ###### ###### ###### ###### ELSE IF @Style = Grid BEGIN if @UseSeq = 0 BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles --inner JOIN janetArticles_categories on dbo.ham_janetArticles_Articles.category LIKE % + janetArticles_categories.name + % --inner JOIN JanetArticles_CategoriesPlus ON JanetArticles_Categories.ID = JanetArticles_CategoriesPlus.CategoriesID WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() between dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END ELSE BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles --inner JOIN janetArticles_categories on dbo.ham_janetArticles_Articles.category LIKE % + janetArticles_categories.name + % --inner JOIN JanetArticles_CategoriesPlus ON JanetArticles_Categories.ID = JanetArticles_CategoriesPlus.CategoriesID WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() between dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.Seq, dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END END -- Listing -- ###### ###### ###### ###### ###### ELSE IF @Style = Listing BEGIN if @UseSeq = 0 BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END ELSE BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEENdbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.seq, dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END END -- Icon list -- ###### ###### ###### ###### ###### ELSE IF @Style = IconList BEGIN SET ROWCOUNT @number SELECT dbo.ham_janetArticles_Articles.Title AS Title, dbo.ham_janetArticles_Articles.Summary AS Summary, dbo.ham_janetArticles_Icons.Image AS IconImage FROM dbo.ham_janetArticles_Articles LEFT OUTER JOIN janetArticles_Icons ON dbo.ham_janetArticles_Articles.IconId = dbo.ham_janetArticles_Icons.ID WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) ORDER BY dbo.ham_janetArticles_Articles.title END -- Directory 0 title based -- ###### ###### ###### ###### ###### ELSE IF @Style = Directory0 BEGIN if @UseSeq = 0 BEGIN SET ROWCOUNT @number SELECT id, image_small, image_large, category, live, description, url_ext, summary, url_int, title, startdate, enddate, lastupdate, subcategory, editroles, metatitle, metadescription, metakeywords, sticky FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) AND dbo.ham_janetArticles_Articles.title LIKE @Filter ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END ELSE BEGIN SET ROWCOUNT @number SELECT id, image_small, image_large, category, live, description, url_ext, summary, url_int, title, startdate, enddate, lastupdate, subcategory, editroles, metatitle, metadescription, metakeywords, sticky FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) AND dbo.ham_janetArticles_Articles.title LIKE @Filter ORDER BY dbo.ham_janetArticles_Articles.Seq, dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END END -- another directory - Summary based -- ###### ###### ###### ###### ###### ELSE IF @Style = Directory1 --search in the summary BEGIN if @UseSeq = 0 BEGIN SET ROWCOUNT @number SELECT id, image_small, image_large, category, live, description, url_ext, summary, url_int, title, startdate, enddate, lastupdate, subcategory, editroles, metatitle, metadescription, metakeywords, sticky FROM dbo.ham_janetArticles_A rticles WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) AND dbo.ham_janetArticles_Articles.summary LIKE @Filter ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END ELSE BEGIN SET ROWCOUNT @number SELECT id, image_small, image_large, category, live, description, url_ext, summary, url_int, title, startdate, enddate, lastupdate, subcategory, editroles, metatitle, metadescription, metakeywords, sticky FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.live = 1 AND dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Category LIKE @Category AND dbo.ham_janetArticles_Articles.SubCategory LIKE @SubCategory AND dbo.ham_janetArticles_Articles.SubCategory2 LIKE @SubCategory2 AND ( (getdate() < DATEADD(d,@NumDays, dbo.ham_janetArticles_Articles.StartDate) AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) OR (@NumDays=0 AND getdate() BETWEEN dbo.ham_janetArticles_Articles.StartDate AND dbo.ham_janetArticles_Articles.EndDate) ) AND dbo.ham_janetArticles_Articles.summary LIKE @Filter ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END END ELSE IF @Style = Edit0 --search in the summary BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.title LIKE @Filter AND dbo.ham_janetArticles_Articles.Category LIKE @Category ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END ELSE IF @Style = Edit1 --search in the summary BEGIN SET ROWCOUNT @number SELECT * FROM dbo.ham_janetArticles_Articles WHERE dbo.ham_janetArticles_Articles.PortalID = @PortalID AND dbo.ham_janetArticles_Articles.Summary LIKE @Filter AND dbo.ham_janetArticles_Articles.Category LIKE @Category ORDER BY dbo.ham_janetArticles_Articles.sticky DESC, dbo.ham_janetArticles_Articles.title END System.Data.SqlClient.SqlException: Invalid column name Name. Invalid column name SubCategory2. 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 | | | | | | | | |