Failure
|
SQL Execution resulted in following Exceptions:
System.Data.SqlClient.SqlException: SELECT permission denied on object
'syscharsets', database 'master', owner 'dbo'. SELECT permission denied on
object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'. SELECT
permission denied on object 'spt_datatype_info', database 'master', owner
'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) --Modifications for Media Gallery 1.7 IF NOT EXISTS (SELECT
COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME='Orizonti_MediaGallery_Category' AND COLUMN_NAME='CreateDate')
ALTER TABLE dbo.Orizonti_MediaGallery_Category ADD [CreateDate] [DateTime]
NULL System.Data.SqlClient.SqlException: SELECT permission denied on object
'syscharsets', database 'master', owner 'dbo'. SELECT permission denied on
object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'. SELECT
permission denied on object 'spt_datatype_info', database 'master', owner
'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) IF NOT EXISTS (SELECT COLUMN_NAME FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Orizonti_MediaGallery_Gallery'
AND COLUMN_NAME='WaterMarkShow') ALTER TABLE
dbo.Orizonti_MediaGallery_Gallery ADD [WatermarkShow] [int] NOT NULL DEFAULT
0, [WatermarkText] [varchar] (50) NULL, [WatermarkImageFontSize] [int] NULL,
[WatermarkFontColor] [varchar] (25) NULL, [WatermarkTransparency] [int] NULL,
[CreateDate] [DateTime] NULL, [CustomField1] [varchar] (150) NULL,
[CustomField2] [varchar] (150) NULL, [CustomField1Width] [int] NULL,
[CustomField2Width] [int] NULL, [SortByName] [varchar] (50) NULL, [SortAsc]
[bit] NULL, [CategorySortBy] [varchar] (50) NULL, [CategorySortOrder] [bit]
NULL System.Data.SqlClient.SqlException: SELECT permission denied on object
'syscharsets', database 'master', owner 'dbo'. SELECT permission denied on object
'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'. SELECT permission
denied on object 'spt_datatype_info', database 'master', owner 'dbo'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) IF NOT EXISTS (SELECT COLUMN_NAME FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Orizonti_MediaGallery_Media' AND
COLUMN_NAME='WaterMarkShow') ALTER TABLE dbo.Orizonti_MediaGallery_Media ADD
[WatermarkShow] [int] NOT NULL DEFAULT 0, [CreateDate] [DateTime] NULL,
[CustomField1] [varchar] (150) NULL, [CustomField2] [varchar] (150) NULL
System.Data.SqlClient.SqlException: Invalid column name 'CreateDate'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_CategoryAdd @Name
varchar(100), @GalleryID bigint, @CreateDate datetime AS INSERT INTO
dbo.Orizonti_MediaGallery_Category ( [Name], [GalleryID], [CreateDate] )
VALUES ( @Name, @GalleryID, @CreateDate ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException:
Invalid column name 'CreateDate'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_CategoryGet @ID
bigint AS SELECT [ID], [Name], [GalleryID], [CreateDate] FROM
dbo.Orizonti_MediaGallery_Category WHERE [ID] = @ID
System.Data.SqlClient.SqlException: Invalid column name 'CreateDate'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_CategoryList
@GalleryID BigInt AS SELECT [ID], [Name], [GalleryID], [CreateDate] FROM
dbo.Orizonti_MediaGallery_Category WHERE [GalleryID] = @GalleryID
System.Data.SqlClient.SqlException: Invalid column name 'CreateDate'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_CategoryUpdate
@ID bigint, @Name varchar(100), @GalleryID bigint, @CreateDate datetime AS
UPDATE dbo.Orizonti_MediaGallery_Category SET [Name] = @Name, [GalleryID] =
@GalleryID, [CreateDate] = @CreateDate WHERE [ID] = @ID
System.Data.SqlClient.SqlException: Invalid column name 'WatermarkShow'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.Orizonti_MediaGallery_GalleryAdd @Name varchar(50),
@PortalID bigint, @ThumbWidth int, @ThumbAcross int, @ImageWidth int,
@ShowFilmstrip bit, @ShowEmailLink bit, @MediaManagerRole int,
@AllowableFileTypes varchar(100), @CategoryTitleStyle varchar(150),
@ImageThumbTitleStyle varchar(150), @ImageTitleStyle varchar(150),
@ImageDescStyle varchar(150), @WatermarkShow int, @WatermarkText varchar(50),
@WatermarkImageFontSize int, @WatermarkFontColor varchar(25), @WatermarkTransparency
int, @CreateDate datetime, @CustomField1 varchar(150), @CustomField2
varchar(150), @CustomField1Width int, @CustomField2Width int, @SortByName
varchar(50), @SortAsc bit, @CategorySortBy varchar(50), @CategorySortOrder
bit AS INSERT INTO dbo.Orizonti_MediaGallery_Gallery ( [Name], [PortalID],
[ThumbWidth], [ThumbAcross], [ImageWidth], [ShowFilmstrip], [ShowEmailLink],
[MediaManagerRole], [AllowableFileTypes], [CategoryTitleStyle],
[ImageThumbTitleStyle], [ImageTitleStyle], [ImageDescStyle], [WatermarkShow],
[WatermarkText], [WatermarkImageFontSize], [WatermarkFontColor],
[WatermarkTransparency], [CreateDate], [CustomField1], [CustomField2],
[CustomField1Width], [CustomField2Width], [SortByName], [SortAsc],
[CategorySortBy], [CategorySortOrder] ) VALUES ( @Name, @PortalID,
@ThumbWidth, @ThumbAcross, @ImageWidth, @ShowFilmstrip, @ShowEmailLink,
@MediaManagerRole, @AllowableFileTypes, @CategoryTitleStyle,
@ImageThumbTitleStyle, @ImageTitleStyle, @ImageDescStyle, @WatermarkShow,
@WatermarkText, @WatermarkImageFontSize, @WatermarkFontColor,
@WatermarkTransparency, @CreateDate, @CustomField1, @CustomField2,
@CustomField1Width, @CustomField2Width, @SortByName, @SortAsc,
@CategorySortBy, @CategorySortOrder ) select SCOPE_IDENTITY()
System.Data.SqlClient.SqlException: Invalid column name 'WatermarkShow'.
Invalid column name 'WatermarkText'. Invalid column name
'WatermarkImageFontSize'. Invalid column name 'WatermarkFontColor'. Invalid
column name 'WatermarkTransparency'. Invalid column name 'CreateDate'. Invalid
column name 'CustomField1'. Invalid column name 'CustomField2'. Invalid
column name 'CustomField1Width'. Invalid column name 'CustomField2Width'.
Invalid column name 'SortByName'. Invalid column name 'SortAsc'. Invalid
column name 'CategorySortBy'. Invalid column name 'CategorySortOrder'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_GalleryGet @ID
bigint AS SELECT [ID], [Name], [PortalID], [ThumbWidth], [ThumbAcross],
[ImageWidth], [ShowFilmstrip], [ShowEmailLink], [MediaManagerRole],
[AllowableFileTypes], [CategoryTitleStyle], [ImageThumbTitleStyle],
[ImageTitleStyle], [ImageDescStyle], [WatermarkShow], [WatermarkText],
[WatermarkImageFontSize], [WatermarkFontColor], [WatermarkTransparency],
[CreateDate], [CustomField1], [CustomField2], [CustomField1Width],
[CustomField2Width], [SortByName], [SortAsc], [CategorySortBy],
[CategorySortOrder] FROM dbo.Orizonti_MediaGallery_Gallery WHERE [ID] = @ID
System.Data.SqlClient.SqlException: Invalid column name 'WatermarkShow'.
Invalid column name 'WatermarkText'. Invalid column name
'WatermarkImageFontSize'. Invalid column name 'WatermarkFontColor'. Invalid
column name 'WatermarkTransparency'. Invalid column name 'CreateDate'.
Invalid column name 'CustomField1'. Invalid column name 'CustomField2'.
Invalid column name 'CustomField1Width'. Invalid column name
'CustomField2Width'. Invalid column name 'SortByName'. Invalid column name
'SortAsc'. Invalid column name 'CategorySortBy'. Invalid column name
'CategorySortOrder'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString,
CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_GalleryList
@PortalId int AS SELECT [ID], [Name], [PortalID], [ThumbWidth],
[ThumbAcross], [ImageWidth], [ShowFilmstrip], [ShowEmailLink],
[MediaManagerRole], [AllowableFileTypes], [CategoryTitleStyle],
[ImageThumbTitleStyle], [ImageTitleStyle], [ImageDescStyle], [WatermarkShow],
[WatermarkText], [WatermarkImageFontSize], [WatermarkFontColor],
[WatermarkTransparency], [CreateDate], [CustomField1], [CustomField2],
[CustomField1Width], [CustomField2Width], [SortByName], [SortAsc],
[CategorySortBy], [CategorySortOrder] FROM dbo.Orizonti_MediaGallery_Gallery
WHERE PortalID = @PortalId System.Data.SqlClient.SqlException: Invalid column
name 'WatermarkShow'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_GalleryUpdate @ID
bigint, @Name varchar(50), @PortalID bigint, @ThumbWidth int, @ThumbAcross
int, @ImageWidth int, @ShowFilmstrip bit, @ShowEmailLink bit,
@MediaManagerRole int, @AllowableFileTypes varchar(100), @CategoryTitleStyle
varchar(150), @ImageThumbTitleStyle varchar(150), @ImageTitleStyle
varchar(150), @ImageDescStyle varchar(150), @WatermarkShow int,
@WatermarkText varchar(50), @WatermarkImageFontSize int, @WatermarkFontColor
varchar(25), @WatermarkTransparency int, @CreateDate datetime, @CustomField1
varchar(150), @CustomField2 varchar(150), @CustomField1Width int,
@CustomField2Width int, @SortByName varchar(50), @SortAsc bit,
@CategorySortBy varchar(50), @CategorySortOrder bit AS UPDATE
dbo.Orizonti_MediaGallery_Gallery SET [Name] = @Name, [PortalID] = @PortalID,
[ThumbWidth] = @ThumbWidth, [ThumbAcross] = @ThumbAcross, [ImageWidth] =
@ImageWidth, [ShowFilmstrip] = @ShowFilmstrip, [ShowEmailLink] =
@ShowEmailLink, [MediaManagerRole] = @MediaManagerRole, [AllowableFileTypes]
= @AllowableFileTypes, [CategoryTitleStyle] = @CategoryTitleStyle,
[ImageThumbTitleStyle] = @ImageThumbTitleStyle, [ImageTitleStyle] =
@ImageTitleStyle, [ImageDescStyle] = @ImageDescStyle, [WatermarkShow] =
@WatermarkShow, [WatermarkText] = @WatermarkText, [WatermarkImageFontSize] =
@WatermarkImageFontSize, [WatermarkFontColor] = @WatermarkFontColor,
[WatermarkTransparency] = @WatermarkTransparency, [CreateDate] = @CreateDate,
[CustomField1] = @CustomField1, [CustomField2] = @CustomField2,
[CustomField1Width] = @CustomField1Width, [CustomField2Width] =
@CustomField2Width, [SortByName] = @SortByName, [SortAsc] = @SortAsc,
[CategorySortBy] = @CategorySortBy, [CategorySortOrder] = @CategorySortOrder
WHERE [ID] = @ID System.Data.SqlClient.SqlException: Invalid column name
'WatermarkShow'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString,
CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_MediaAdd @Name
varchar(100), @Description varchar(250), @IsImage bit, @FileName
varchar(100), @GalleryID bigint, @CategoryID bigint, @WatermarkShow bit, @CreateDate
datetime, @CustomField1 varchar(150), @CustomField2 varchar(150) AS INSERT
INTO dbo.Orizonti_MediaGallery_Media ( [Name], [Description], [IsImage],
[FileName], [GalleryID], [CategoryID], [WatermarkShow], [CreateDate],
[CustomField1], [CustomField2] ) VALUES ( @Name, @Description, @IsImage,
@FileName, @GalleryID, @CategoryID, @WatermarkShow, @CreateDate,
@CustomField1, @CustomField2 ) select SCOPE_IDENTITY()
System.Data.SqlClient.SqlException: Invalid column name 'WatermarkShow'.
Invalid column name 'CreateDate'. Invalid column name 'CustomField1'. Invalid
column name 'CustomField2'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_MediaGet @ID
bigint AS SELECT dbo.Orizonti_MediaGallery_Media.ID AS ID,
dbo.Orizonti_MediaGallery_Media.Name AS Name,
dbo.Orizonti_MediaGallery_Media.Description AS Description,
dbo.Orizonti_MediaGallery_Media.IsImage,
dbo.Orizonti_MediaGallery_Media.FileName, dbo.Orizonti_MediaGallery_Media.GalleryID,
dbo.Orizonti_MediaGallery_Media.CategoryID,
dbo.Orizonti_MediaGallery_Category.Name AS CategoryName,
dbo.Orizonti_MediaGallery_Media.WatermarkShow,
dbo.Orizonti_MediaGallery_Media.CreateDate,
dbo.Orizonti_MediaGallery_Media.CustomField1,
dbo.Orizonti_MediaGallery_Media.CustomField2 FROM
dbo.Orizonti_MediaGallery_Media INNER JOIN dbo.Orizonti_MediaGallery_Category
ON dbo.Orizonti_MediaGallery_Media.CategoryID =
dbo.Orizonti_MediaGallery_Category.ID WHERE (Orizonti_MediaGallery_Media.ID =
@ID) System.Data.SqlClient.SqlException: Invalid column name 'WatermarkShow'.
Invalid column name 'CreateDate'. Invalid column name 'CustomField1'. Invalid
column name 'CustomField2'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE
dbo.Orizonti_MediaGallery_MediaGetBy_Category @CategoryID bigint AS SELECT
ID, Name, Description, IsImage, FileName, GalleryID, CategoryID,
WatermarkShow, CreateDate, CustomField1, CustomField2 FROM dbo.Orizonti_MediaGallery_Media
WHERE (CategoryID = @CategoryID) System.Data.SqlClient.SqlException: Invalid
column name 'WatermarkShow'. Invalid column name 'CreateDate'. Invalid column
name 'CustomField1'. Invalid column name 'CustomField2'. Invalid column name
'CreateDate'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE
dbo.Orizonti_MediaGallery_MediaGetBy_Gallery @GalleryID bigint AS SELECT
dbo.Orizonti_MediaGallery_Media.ID AS ID, dbo.Orizonti_MediaGallery_Media.Name
AS Name, dbo.Orizonti_MediaGallery_Media.Description,
dbo.Orizonti_MediaGallery_Media.IsImage,
dbo.Orizonti_MediaGallery_Media.FileName,
dbo.Orizonti_MediaGallery_Media.GalleryID,
dbo.Orizonti_MediaGallery_Media.CategoryID, dbo.Orizonti_MediaGallery_Category.Name
AS CategoryName, dbo.Orizonti_MediaGallery_Media.WatermarkShow,
dbo.Orizonti_MediaGallery_Media.CreateDate,
dbo.Orizonti_MediaGallery_Media.CustomField1,
dbo.Orizonti_MediaGallery_Media.CustomField2, dbo.Orizonti_MediaGallery_Category.CreateDate
AS CategoryCreateDate FROM dbo.Orizonti_MediaGallery_Media INNER JOIN
dbo.Orizonti_MediaGallery_Category ON
dbo.Orizonti_MediaGallery_Media.CategoryID =
dbo.Orizonti_MediaGallery_Category.ID WHERE
(dbo.Orizonti_MediaGallery_Media.GalleryID = @GalleryID) ORDER BY
CategoryName System.Data.SqlClient.SqlException: Invalid column name
'WatermarkShow'. Invalid column name 'CreateDate'. Invalid column name
'CustomField1'. Invalid column name 'CustomField2'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString,
CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_MediaList
@GalleryID bigint AS SELECT dbo.Orizonti_MediaGallery_Media.ID AS ID,
dbo.Orizonti_MediaGallery_Media.Name AS Name,
dbo.Orizonti_MediaGallery_Media.Description,
dbo.Orizonti_MediaGallery_Media.IsImage,
dbo.Orizonti_MediaGallery_Media.FileName,
dbo.Orizonti_MediaGallery_Media.GalleryID,
dbo.Orizonti_MediaGallery_Media.CategoryID,
dbo.Orizonti_MediaGallery_Category.Name AS CategoryName, dbo.Orizonti_MediaGallery_Media.WatermarkShow,
dbo.Orizonti_MediaGallery_Media.CreateDate,
dbo.Orizonti_MediaGallery_Media.CustomField1,
dbo.Orizonti_MediaGallery_Media.CustomField2 FROM
dbo.Orizonti_MediaGallery_Media INNER JOIN dbo.Orizonti_MediaGallery_Category
ON dbo.Orizonti_MediaGallery_Media.GalleryID =
dbo.Orizonti_MediaGallery_Category.ID WHERE
(dbo.Orizonti_MediaGallery_Media.GalleryID = @GalleryID)
System.Data.SqlClient.SqlException: Invalid column name 'WatermarkShow'. at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString,
CommandType commandType, String commandText, SqlParameter[]
commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions) CREATE PROCEDURE dbo.Orizonti_MediaGallery_MediaUpdate @ID
bigint, @Name varchar(100), @Description varchar(250), @IsImage bit,
@FileName varchar(100), @GalleryID bigint, @CategoryID bigint, @WatermarkShow
bit , @CreateDate datetime, @CustomField1 varchar(150), @CustomField2
varchar(150) AS UPDATE dbo.Orizonti_MediaGallery_Media SET [Name] = @Name,
[Description] = @Description, [IsImage] = @IsImage, [FileName] = @FileName,
[GalleryID] = @GalleryID, [CategoryID] = @CategoryID, [WatermarkShow] =
@WatermarkShow, [CreateDate] = @CreateDate, [CustomField1] = @CustomField1,
[CustomField2] = @CustomField2 WHERE [ID] = @ID
|