I tried an upgrade from 6.1.4 to 6.2.0 and had numerous errors on my upgrade status report, including:

00:00:01.437 -   Executing Script: 06.02.00.SqlDataProvider Error! (see 06.02.00.log.resources for more information)
00:00:13.531 -   Executing Script: 06.02.01.SqlDataProvider Error! (see 06.02.01.log.resources for more information)
00:00:16.234 -   Executing Script: 06.02.02.SqlDataProvider Error! (see 06.02.02.log.resources for more information)

00:00:17.625 -   Executing Application Upgrades: 06.02.00 Error!
00:00:20.141 -   Executing Application Upgrades: 06.02.01 Error!
00:00:34.266 -   Installing Package File DNNCE_MemberDirectory_06.02.02_Install:  Error!
00:00:34.719 -   Installing Package File DNNCE_MobileManagement_06.02.02_Install:  Error!
00:00:35.094 -   Installing Package File DNNCE_PreviewProfileManagement_06.02.02_Install:  Error!
00:00:35.485 -   Installing Package File DNNCE_SocialGroups_06.02.02_Install:  Error!
00:01:16.376 -   Installing Package File FiftyOneClientCapabilityProvider_06.02.02_Install:  Error!
00:01:40.065 -   Installing Package File Facebook_Auth_06.02.02_Install:  Error!
00:01:40.549 -   Installing Package File Google_Auth_06.02.02_Install:  Error!
00:01:41.127 -   Installing Package File Live_Auth_06.02.02_Install:  Error!
00:01:41.893 -   Installing Package File Twitter_Auth_06.02.02_Install:  Error!

All the rest of the lines read "Success". When I tried to access my site, it told me "System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.EventLog'.'PK_EventLogMaster' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full."

How do I keep my event logs from filling up, and could them being full have prevented the upgrade? Thanks!

System.Data.SqlClient.SqlException: Could not allocate a new page for database '3_03249dc_1' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 rows to dbo.[RelationshipTypes
IF NOT EXISTS (SELECT * FROM dbo.[RelationshipTypes] WHERE [Name] = N'Friends')
    BEGIN
   INSERT INTO dbo.[RelationshipTypes] ([Direction], [Name], [Description],[CreatedByUserID],[LastModifiedByUserID]) VALUES (2, N'Friends', N'Friends',-1,-1)
END


System.Data.SqlClient.SqlException: Could not allocate a new page for database '3_03249dc_1' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 NOT EXISTS (SELECT * FROM dbo.[RelationshipTypes] WHERE [Name] = N'Followers')
    BEGIN
   INSERT INTO dbo.[RelationshipTypes] ([Direction], [Name], [Description],[CreatedByUserID],[LastModifiedByUserID]) VALUES (1, N'Followers', N'Followers',-1,-1)
END


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syssingleobjrefs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[CoreMessaging_MessageAttachments]') AND type in (N'U')) BEGIN
CREATE TABLE dbo.CoreMessaging_MessageAttachments(
[MessageAttachmentID] [int] IDENTITY(1,1) NOT NULL,
[MessageID] [int] NOT NULL,
[FileID] [int] NULL,
[CreatedByUserID] [int] NULL,
[CreatedOnDate] [datetime] NULL,
[LastModifiedByUserID] [int] NULL,
[LastModifiedOnDate] [datetime] NULL,
CONSTRAINT [PK_CoreMessaging_MessageAttachments] PRIMARY KEY CLUSTERED ([MessageAttachmentID] ASC)
)

CREATE NONCLUSTERED INDEX [IX_CoreMessaging_MessageAttachments_MessageID] ON dbo.[CoreMessaging_MessageAttachments] ([MessageID] ASC)

ALTER TABLE dbo.[CoreMessaging_MessageAttachments]
ADD CONSTRAINT [FK_CoreMessaging_MessageAttachments_CoreMessaging_Messages]
FOREIGN KEY([MessageID])
REFERENCES dbo.[CoreMessaging_Messages] ([MessageID]) ON DELETE CASCADE
END


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysobjvalues'.'clst' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 PROC dbo.[UpdateUserProfileProperty] 

@ProfileID int,
@UserID int,
@PropertyDefinitionID int,
@PropertyValue ntext,
@Visibility int,
@ExtendedVisibility varchar(400),
@LastUpdatedDate datetime

AS
IF @ProfileID IS NULL OR @ProfileID = -1
-- Try the UserID/PropertyDefinitionID to see if the Profile property exists
SELECT @ProfileID = ProfileID
FROM   dbo.UserProfile
WHERE  UserID = @UserID AND PropertyDefinitionID = @PropertyDefinitionID
 
IF @ProfileID IS NOT NULL
-- Update Property
BEGIN
UPDATE dbo.UserProfile
SET PropertyValue = case when (DATALENGTH(@PropertyValue) > 7500) then NULL else @PropertyValue end,
PropertyText = case when (DATALENGTH(@PropertyValue) > 7500) then @PropertyValue else NULL end,
Visibility = @Visibility,
ExtendedVisibility = @ExtendedVisibility,
LastUpdatedDate = @LastUpdatedDate
WHERE  ProfileID = @ProfileID
SELECT @ProfileID
END
ELSE
-- Insert New Property
BEGIN
INSERT INTO dbo.UserProfile (
UserID,
PropertyDefinitionID,
PropertyValue,
PropertyText,
Visibility,
ExtendedVisibility,
LastUpdatedDate
 )
VALUES (
@UserID,
@PropertyDefinitionID,
case when (DATALENGTH(@PropertyValue) > 7500) then NULL else @PropertyValue end,
case when (DATALENGTH(@PropertyValue) > 7500) then @PropertyValue else NULL end,
@Visibility,
@ExtendedVisibility,
@LastUpdatedDate
 )

SELECT SCOPE_IDENTITY()
END


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syshobtcolumns'.'clust' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 TABLE dbo.[Journal](
[JournalId] [int] IDENTITY(1,1) NOT NULL,
[JournalTypeId] [int] NOT NULL,
[UserId] [int] NULL,
[DateCreated] [datetime] NULL,
[DateUpdated] [datetime] NULL,
[PortalId] [int] NULL,
[ProfileId] [int] NOT NULL,
[GroupId] [int] NOT NULL,
[Title] [nvarchar](255) NULL,
[Summary] [nvarchar](2000) NULL,
[ItemData] [nvarchar](2000) NULL,
[ImageURL] [nvarchar](255) NULL,
[ObjectKey] [nvarchar](255) NULL,
[AccessKey] [uniqueidentifier] NULL,
[ContentItemId] [int] NULL,
CONSTRAINT [PK_Journal] PRIMARY KEY CLUSTERED ([JournalId] ASC)
)



System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syshobtcolumns'.'clust' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 TABLE dbo.[Journal_Security](
[JournalSecurityId] [int] IDENTITY(1,1) NOT NULL,
[JournalId] [int] NOT NULL,
[SecurityKey] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Journal_Security] PRIMARY KEY CLUSTERED ( [JournalSecurityId] ASC),
CONSTRAINT [IX_Journal_Security] UNIQUE NONCLUSTERED ( [JournalId] DESC, [SecurityKey] ASC )
)



System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syshobtcolumns'.'clust' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 TABLE dbo.[Journal_Access](
[JournalAccessId] [int] IDENTITY(1,1) NOT NULL,
[JournalTypeId] [int] NOT NULL,
[PortalId] [int] NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[AccessKey] [uniqueidentifier] NOT NULL,
[IsEnabled] [bit] NOT NULL,
[DateCreated] [datetime] NOT NULL,
CONSTRAINT [PK_Journal_Access] PRIMARY KEY CLUSTERED ( [JournalAccessId] ASC )
)



System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syshobtcolumns'.'clust' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 TABLE dbo.[Journal_TypeFilters](
[JournalTypeFilterId] [int] IDENTITY(1,1) NOT NULL,
[PortalId] [int] NOT NULL,
[ModuleId] [int] NOT NULL,
[JournalTypeId] [int] NOT NULL,
CONSTRAINT [PK_Journal_TypeFilters] PRIMARY KEY CLUSTERED ([JournalTypeFilterId] ASC)
)



System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syshobtcolumns'.'clust' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 TABLE dbo.[Journal_Types](
[JournalTypeId] [int] NOT NULL,
[JournalType] [nvarchar](25) NULL,
[icon] [nvarchar](25) NULL,
[PortalId] [int] NOT NULL,
[IsEnabled] [bit] NOT NULL,
[AppliesToProfile] [bit] NOT NULL,
[AppliesToGroup] [bit] NOT NULL,
[AppliesToStream] [bit] NOT NULL,
[Options] [nvarchar](max) NULL,
[SupportsNotify] [bit] NOT NULL,
[EnableComments] [bit] NOT NULL,
CONSTRAINT [PK_JournalTypes] PRIMARY KEY CLUSTERED ([JournalTypeId] ASC)
)



System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syshobtcolumns'.'clust' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 TABLE dbo.[Journal_Comments](
[CommentId] [int] IDENTITY(1,1) NOT NULL,
[JournalId] [int] NOT NULL,
[UserId] [int] NOT NULL,
[Comment] [nvarchar](2000) NULL,
[DateCreated] [datetime] NOT NULL,
[DateUpdated] [datetime] NOT NULL,
[CommentXML] [xml] NULL,
CONSTRAINT [PK_Journal_Comments] PRIMARY KEY CLUSTERED ( [CommentId] ASC)
)



System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal]  WITH NOCHECK ADD  CONSTRAINT [FK_Journal_JournalTypes] FOREIGN KEY([JournalTypeId])
REFERENCES dbo.[Journal_Types] ([JournalTypeId])


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal] NOCHECK CONSTRAINT [FK_Journal_JournalTypes]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal] ADD  CONSTRAINT [DF_Journal_ProfileId]  DEFAULT ((-1)) FOR [ProfileId]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal] ADD  CONSTRAINT [DF_Journal_GroupId]  DEFAULT ((-1)) FOR [GroupId]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Types" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Types] ADD  CONSTRAINT [DF_JournalTypes_PortalId]  DEFAULT ((-1)) FOR [PortalId]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Types" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Types] ADD  CONSTRAINT [DF_JournalTypes_IsEnabled]  DEFAULT ((1)) FOR [IsEnabled]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Types" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Types] ADD  CONSTRAINT [DF_JournalTypes_AppliesToProfile]  DEFAULT ((1)) FOR [AppliesToProfile]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Types" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Types] ADD  CONSTRAINT [DF_JournalTypes_AppliesToGroup]  DEFAULT ((1)) FOR [AppliesToGroup]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Types" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Types] ADD  CONSTRAINT [DF_JournalTypes_AppliesToStream]  DEFAULT ((1)) FOR [AppliesToStream]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Types" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Types] ADD  CONSTRAINT [DF_JournalTypes_SupportsNotify]  DEFAULT ((0)) FOR [SupportsNotify]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Types" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Types] ADD  CONSTRAINT [DF_Journal_Types_EnableComments]  DEFAULT ((1)) FOR [EnableComments]


System.Data.SqlClient.SqlException: Foreign key 'FK_Journal_Data_Journal' references invalid table 'dbo.Journal'.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Data]  WITH NOCHECK ADD  CONSTRAINT [FK_Journal_Data_Journal] FOREIGN KEY([JournalId])
REFERENCES dbo.[Journal] ([JournalId])
ON DELETE CASCADE


System.Data.SqlClient.SqlException: Constraint 'FK_Journal_Data_Journal' does not exist.
Could not enable or disable the constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Data] NOCHECK CONSTRAINT [FK_Journal_Data_Journal]


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Comments" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Comments]  WITH NOCHECK ADD  CONSTRAINT [FK_JournalComments_Journal] FOREIGN KEY([JournalId])
REFERENCES dbo.[Journal] ([JournalId])
ON DELETE CASCADE


System.Data.SqlClient.SqlException: Cannot find the object "dbo.Journal_Comments" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 dbo.[Journal_Comments] NOCHECK CONSTRAINT [FK_JournalComments_Journal]


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syscolpars'.'clst' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[Journal_Comment_Delete]
@JournalId int,
@CommentId int
AS
DELETE FROM dbo.[Journal_Comments] 
WHERE 
(JournalId = @JournalId AND CommentId = @CommentId)
OR
(JournalId = @JournalId AND CommentId = -1)




System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syscolpars'.'clst' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[Journal_Comment_List]
@JournalId int
AS
SELECT jc.*, u.* FROM dbo.[Journal_Comments] as jc 
INNER JOIN dbo.[Users] as u ON jc.UserId = u.UserId
WHERE jc.JournalId = @JournalId
ORDER BY jc.CommentId




System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)





INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(1, 'status', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(2, 'link', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(3, 'photo', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(4, 'file', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(5, 'forum_topic', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(6, 'forum_reply', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(7, 'blog', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(8, 'friend', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(9, 'groupcreate', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(10, 'groupjoin', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(11, 'wikiadd', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(12, 'wikiupdate', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(13, 'documentadd', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(14, 'documentupdate', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify, EnableComments)
VALUES
(15, 'articleadd', '', -1, 1, 1, 1, 1, null, 1, 0)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(16, 'videoadd', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(17, 'vote', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify, EnableComments)
VALUES
(18, 'comment', '', -1, 1, 1, 1, 1, null, 1, 0)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify, EnableComments)
VALUES
(19, 'question', '', -1, 1, 1, 1, 1, null, 1, 0)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify, EnableComments)
VALUES
(20, 'answer', '', -1, 1, 1, 1, 1, null, 1, 0)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(21, 'eventcreate', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(22, 'eventattend', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(23, 'projectcreated', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(24, 'projectupdated', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(25, 'reviewadd', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(26, 'reviewupdate', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(27, 'survey', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(28, 'taskadd', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(29, 'taskupdate', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify)
VALUES
(30, 'privilege', '', -1, 1, 1, 1, 1, null, 1)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify, EnableComments)
VALUES
(31, 'ideaadd', '', -1, 1, 1, 1, 1, null, 1, 0)


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Journal_Types'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)


INSERT INTO dbo.[Journal_Types]
(JournalTypeId, JournalType, icon, PortalId, IsEnabled, AppliesToProfile, AppliesToGroup, AppliesToStream, Options, SupportsNotify, EnableComments)
VALUES
(32, 'ideaupdate', '', -1, 1, 1, 1, 1, null, 1, 0)


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysschobjs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 FUNCTION dbo.[GetSortSql]
(
@SortBy nvarchar(100),
@SortAscending BIT,
@Default nvarchar(100)
)
RETURNS nvarchar(max)
AS
BEGIN
DECLARE @sortSql nvarchar(max)
SET @sortSql = ''
IF @SortBy = ''
SET @SortBy = @Default
SET @sortSql = N'ORDER BY [' + @SortBy + CASE WHEN @SortAscending = 1 THEN N'] ASC' ELSE N'] DESC' END

RETURN(@sortSql)
END


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysschobjs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 FUNCTION dbo.[GetUsersByPropertyName]
(
@PropertyName nvarchar(100),
@PropertyValue nvarchar(max),
@PortalID int
)
RETURNS TABLE
AS
RETURN
SELECT *
FROM dbo.vw_Profile
WHERE PropertyName = @PropertyName 
AND PropertyValue LIKE @PropertyValue
AND PortalID = @PortalID



System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysschobjs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[GetUsersAdvancedSearch]
(
@PortalID int, -- portal
@UserId int, -- for determining correct visibility permissions
@FilterUserId int, -- for filtering relationships on
@FilterRoleId int, -- for filtering by roles
@RelationshipTypeId int, -- for filtering by relationships
@IsAdmin bit, -- determines visibility
@PageSize int, -- page size
@PageIndex int, -- 0 based page index
@SortBy nvarchar(100), -- sort field
@SortAscending bit, -- sort flag indicating whether sort is asc or desc
@PropertyNames nvarchar(max), -- list of property names to filter
@PropertyValues nvarchar(max) -- list of property values to filter
)
AS
-- Setup Top XX
DECLARE @topSql nvarchar(20) SET @topSql = ''
IF @PageSize > -1 BEGIN SET @topSql = ' TOP ' + CONVERT(nvarchar(20), @PageSize) END

-- Setup Specific Page
DECLARE @minRowNumberSql nvarchar(20) SET @minRowNumberSql =  CONVERT(nvarchar(20), ((@PageIndex * @PageSize) + 1))
-- Setup Pivot Field List
DECLARE @pivotSql nvarchar(max) SELECT @pivotSql = dbo.GetProfileFieldSql(@PortalID, '')

-- Get User specific columns
DECLARE @UserColumns TABLE(ColumnName NVARCHAR(100))
INSERT INTO @UserColumns SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.vw_Users'

-- Lists Filters names and values into tables
DECLARE @PropertyNamesTable TABLE (RowNumber INT, RowValue nvarchar(MAX))
DECLARE @PropertyValuesTable TABLE (RowNumber INT, RowValue nvarchar(MAX))
INSERT INTO @PropertyNamesTable SELECT * FROM dbo.ConvertListToTable(',', @PropertyNames)
INSERT INTO @PropertyValuesTable SELECT * FROM dbo.ConvertListToTable(',', @PropertyValues)

-- Gets filters that are on the User rather than Profile Properties
DECLARE @UserFiltersTable TABLE (RowNumber Int, RowValue NVARCHAR(MAX))
INSERT INTO @UserFiltersTable SELECT * FROM dbo.ConvertListToTable(',',@PropertyNames) WHERE RowValue IN (SELECT * FROM @UserColumns)


DECLARE @sql nvarchar(max) SET @sql = ''
DECLARE @filterSql nvarchar(max)SET @filterSql = ''


-- ///////////////////////////////////////////////////
-- FILTERING by PROFILE PROPERTY or USER PROPERTY
-- ///////////////////////////////////////////////////
--IF @PropertyNames IS NOT NULL AND @PropertyNames <> ''
IF ((SELECT COUNT(*) FROM @PropertyNamesTable) > 0) AND ((SELECT COUNT(*) FROM @PropertyValuesTable)> 0) 
BEGIN
DECLARE @propertyFilter nvarchar(max)
DECLARE @userFilter nvarchar(max)
DECLARE @userFilterJoin nvarchar(max) SET @userFilterJoin = ''
DECLARE @profilePropertyCount INT
DECLARE @userFilterCount INT
DECLARE @propertyAndUserFilter nvarchar(10) SET @propertyAndUserFilter = ''
DECLARE @groupBy NVARCHAR(300)

-- Filters on Profile Properties
;WITH CTE_PropertyNames(RowNumber, RowValue) AS
( SELECT * FROM @PropertyNamesTable
WHERE RowValue NOT IN (SELECT ColumnName FROM @UserColumns)),
CTE_PropertyValues(RowNumber, RowValue) AS
( SELECT * FROM @PropertyValuesTable
WHERE RowValue NOT IN (SELECT ColumnName FROM @UserColumns))

SELECT @propertyFilter = COALESCE(@propertyFilter + ' OR ' , ' ') 
+ ' (PropertyName=''' + N.RowValue 
+ ''' AND ((PropertyValue LIKE ''' + V.RowValue +'%'') OR (PropertyValue LIKE ''% ' + V.RowValue +'%'')))'
FROM CTE_PropertyNames AS N INNER JOIN CTE_PropertyValues AS V ON N.RowNumber = V.RowNumber

-- Filters on User Property
SELECT @userFilter = COALESCE(@userFilter + ' AND ', ' ')  
+ ' ((u.' + N.RowValue + ' LIKE ''' + V.RowValue +'%'') OR (u.' + N.RowValue + ' LIKE ''% ' + V.RowValue +'%'')) '
FROM @UserFiltersTable AS N INNER JOIN @PropertyValuesTable AS V ON N.RowNumber = V.RowNumber

SELECT @userFilterCount = COUNT(*) FROM @UserFiltersTable
IF @userFilterCount > 0 BEGIN SET @userFilterJoin = ' INNER JOIN dbo.vw_Users u ON u.UserId = p.UserId ' END


-- Determining the Group By Clause -- dependant on types of filters used
SELECT @profilePropertyCount = COUNT(*) FROM dbo.ConvertListToTable(',', @PropertyNames)
WHERE RowValue IN (SELECT PropertyName FROM dbo.ProfilePropertyDefinition WHERE PortalID = @PortalId)
AND RowValue NOT IN (SELECT ColumnName FROM @UserColumns)
IF @profilePropertyCount > 0
BEGIN SET @groupBy = ' GROUP BY p.UserId HAVING COUNT(*) = ' + CONVERT(nvarchar(20),@profilePropertyCount ) END
ELSE
BEGIN SET @groupBy = ' GROUP BY p.UserId HAVING COUNT(*) > 0 ' END

IF ( @profilePropertyCount > 0 AND @userFilterCount > 0)
BEGIN SET @propertyAndUserFilter = ' AND ' END

-- CREATE FINAL FILTER
SET @filterSql = ' DECLARE @MatchingUsers TABLE (UserID INT, Occurrances INT) INSERT INTO @MatchingUsers SELECT p.UserID, COUNT(*) AS occurances ' 
+ ' FROM dbo.vw_profile p ' + @userFilterJoin
+ ' WHERE ' + COALESCE(' ( ' + @propertyFilter + ') ', ' ') + @propertyAndUserFilter + COALESCE(@userFilter, ' ') 
+ @groupBy
END


-- ///////////////////////////////////////////////////
-- SETUP ROLE AND RELATIONSHIP FILTERS
-- ///////////////////////////////////////////////////
DECLARE @roleAndRelationshipFilter nvarchar(1000)
DECLARE @roleFilter nvarchar(100) SET @roleFilter = ''
DECLARE @relationshipFilter nvarchar(1000) SET @relationshipFilter = ''
DECLARE @roleAndRelationshipFlag bit SET @roleAndRelationshipFlag  = 0
DECLARE @RoleAndRelationshipSelect nvarchar(100) SET @RoleAndRelationshipSelect = ''

-- Filter by Role
IF @FilterRoleId <> -1 
BEGIN
SET @roleAndRelationshipFlag = 1
SET @roleFilter = ' JOIN dbo.UserRoles UR ON U.UserID = UR.UserID AND UR.RoleID = ' + CONVERT(nvarchar(20), @FilterRoleId)
END

-- Filter by Relationship
IF @RelationshipTypeId <> -1  
BEGIN
SET @roleAndRelationshipFlag = 1
SET @relationshipFilter = ' JOIN dbo.Relationships REL ON REL.PortalID = ' + CONVERT(nvarchar(20), @PortalID)
+ ' AND RelationshipTypeID = ' + CONVERT(nvarchar(20), @RelationshipTypeId) 
+ ' JOIN dbo.UserRelationships UREL ON REL.RelationshipID = UREL.RelationshipID AND
((UREL.UserID = ' + CONVERT(nvarchar(20), @FilterUserId) + ' AND UREL.RelatedUserID = U.UserID) OR
(UREL.UserID = U.UserID AND UREL.RelatedUserID = ' + CONVERT(nvarchar(20), @FilterUserId) + '))'
+ ' WHERE UREL.Status = 2'
END 

IF @roleAndRelationshipFlag = 1 BEGIN SET @RoleAndRelationshipSelect = ' AND s.UserId IN (SELECT userID FROM  RoleAndRelationUsers) ' END

SET @roleAndRelationshipFilter =  ', RoleAndRelationUsers AS ( SELECT U.userId FROM dbo.vw_Users U ' + @roleFilter + @relationshipFilter + ' )' 


-- ///////////////////////////////////////////////////  
    -- SET UP SORT
-- ///////////////////////////////////////////////////
    DECLARE @sortSql nvarchar(1000) SET @sortSql = ''
    DECLARE @propertySort nvarchar(1000) SET @propertySort = ''
    DECLARE @filterJoin nvarchar(100) SET @filterJoin = ''
DECLARE @filterSortSql nvarchar(1000) SET @filterSortSql = ''
DECLARE @sortByUserProperty BIT
SELECT @sortByUserProperty = COUNT(*) FROM @UserColumns WHERE ColumnName = @SortBy

IF ( @profilePropertyCount > 0 OR @userFilterCount > 0)
BEGIN SET @filterJoin = ' INNER JOIN @MatchingUsers m ON m.UserID = s.UserID ' END

-- Determine the Type of Sort
IF (@SortBy IS NOT NULL AND @SortBy <> '') AND @sortByUserProperty <> 1
BEGIN -- Sort By Profile Property
SET @sortSql = dbo.GetSortSql(@SortBy,@SortAscending,'UserID')
SET @propertySort = dbo.GetSortSql('PropertyValue',@SortAscending,'UserID')
SET @filterSortSql = ' ;WITH SortedUsers AS ( SELECT ROW_NUMBER() OVER( ' + @propertySort + ' ) AS RowNumber, *  ' 
+ ' FROM dbo.vw_Profile WHERE PortalId = ' + CONVERT(nvarchar(20), @PortalID) + ' AND PropertyName = ''' + @SortBy + ''' )'
+ ' , MatchingSorted AS ( SELECT ROW_NUMBER() OVER(ORDER BY [RowNumber]) AS RowNumber, s.UserId FROM SortedUsers s '
+ @filterJoin + ' ) '
END
ELSE
BEGIN
-- Sort By User Property
IF @sortByUserProperty = 1 BEGIN SET @sortSql = dbo.GetSortSql(@SortBy,@SortAscending,'UserID')END

-- Default: Sort By UserID
ELSE BEGIN SET @sortSql = dbo.GetSortSql('UserID',@SortAscending,'UserID') END
SET @filterSortSql = ' ;WITH SortedUsers AS ( SELECT ROW_NUMBER() OVER( ' + @sortSql + ' ) AS RowNumber, * '
+ ' FROM dbo.vw_Users WHERE PortalId = ' + CONVERT(nvarchar(20), @PortalID) + ')'
+ ' , MatchingSorted AS ( SELECT ROW_NUMBER() OVER(ORDER BY [RowNumber]) AS RowNumber, s.UserId FROM SortedUsers s '
+ @filterJoin + ' ) '
END

-- ///////////////////////////////////////////////////
-- CREATE FINAL QUERY
-- ///////////////////////////////////////////////////
SET @sql = @filterSql
+ ' DECLARE @TempUsers TABLE (SortOrder INT, UserID INT) '
+ @filterSortSql
+ @roleAndRelationshipFilter
+ ' INSERT INTO @TempUsers SELECT ' + @topSql
+ ' s.RowNumber, s.UserId FROM MatchingSorted s ' 
+ ' WHERE RowNumber >= ' + @minRowNumberSql 
+ @roleAndRelationshipSelect
+ ' ;WITH PivotedUsers AS ( SELECT U.UserID, U.PortalID, U.Username, U.Email, U.DisplayName, U.IsSuperUser, U.IsDeleted,        
U.AffiliateID, U.UpdatePassword, U.Authorised, U.CreateDate, U.LastActivityDate, U.LastLockoutDate,
U.LastLoginDate, U.LastPasswordChangedDate, U.IsLockedOut, U.PasswordQuestion, U.IsApproved, Prop.PropertyName,
CASE
WHEN (p.Visibility = 0) THEN p.PropertyValue
WHEN (p.Visibility = 1 AND ' + CONVERT(nvarchar(20), @IsAdmin) + ' = 1) THEN p.PropertyValue
WHEN (p.Visibility = 1 AND ' + CONVERT(nvarchar(20), @IsAdmin) + ' = 0 AND ' + CONVERT(nvarchar(20), @UserId) + '> 0) THEN p.PropertyValue
WHEN U.UserID = ' + CONVERT(nvarchar(20), @UserId) + 'OR (p.Visibility = 2 AND ' + CONVERT(nvarchar(20), @IsAdmin) + ' = 1) THEN p.PropertyValue
ELSE NULL
END AS PropertyValue
FROM dbo.vw_Users AS U
INNER JOIN dbo.UserProfile AS P ON U.UserID = P.UserID
INNER JOIN dbo.ProfilePropertyDefinition AS Prop ON Prop.PropertyDefinitionID = p.PropertyDefinitionID
WHERE U.UserId IN (SELECT UserId FROM @TempUsers)
AND u.PortalID = ' + CONVERT(nvarchar(20), @PortalID) + '  AND u.IsDeleted = 0 
)
SELECT * FROM PivotedUsers PIVOT (MAX(PropertyValue) for PropertyName in (' + @pivotSql + ') ) as pivotTable '
+ @sortSql
EXEC(@sql)


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysschobjs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[GetUsersBasicSearch]
(
@PortalID int, -- portal
@PageSize int, -- page size
@PageIndex int, -- 0 based page index
@SortBy nvarchar(100), -- sort field
@SortAscending bit, -- sort flag indicating whether sort is asc or desc
@PropertyName nvarchar(256),    -- property to filter by (username, diaplayname, email)
@PropertyValue nvarchar(256) -- value of property
)
AS
-- Set up Top XX
DECLARE @topSql nvarchar(20)
SET @topSql = CONVERT(nvarchar(20), @PageSize)

--Set up Count
DECLARE @minRowNumberSql nvarchar(20)
SET @minRowNumberSql =  CONVERT(nvarchar(20), ((@PageIndex * @PageSize) + 1))

-- Set up Sort
DECLARE @sortSql nvarchar(1000)
SET @sortSql = dbo.GetSortSql(@SortBy, @SortAscending, 'UserID')

-- Setup Pivot Field List
DECLARE @pivotSql nvarchar(max)
SELECT @pivotSql = dbo.GetProfileFieldSql(@PortalID, '')

-- Setup FieldName Field List for temporary table
DECLARE @fieldNames nvarchar(max)
SELECT @fieldNames = dbo.GetProfileFieldSql(@PortalID, ' nvarchar(max)')

DECLARE @sql nvarchar(max)
SELECT @sql=
'
DECLARE @pivotedUsers TABLE
(
RowNumber int,
UserID int,
PortalID int,
Username nvarchar(100),
Email nvarchar(256),
DisplayName nvarchar(128),
IsSuperUser bit,
IsDeleted bit,
AffiliateID int,
UpdatePassword bit,
Authorised bit,
CreateDate datetime,
LastActivityDate datetime,
LastLockoutDate datetime,
LastLoginDate datetime,
LastPasswordChangedDate datetime,
IsLockedOut bit,
PasswordQuestion nvarchar(256),
IsApproved bit,
' + @fieldNames + '
);

WITH TempUsers
AS
(
SELECT TOP ' + @topSql + ' * FROM (
SELECT
ROW_NUMBER() OVER(' + @sortSql + ') AS RowNumber,
U.UserID,
U.PortalID,
U.Username,
U.Email,
U.DisplayName,
U.IsSuperUser,
U.IsDeleted,
U.AffiliateID,
U.UpdatePassword,
U.Authorised,
U.CreateDate,
U.LastActivityDate,
U.LastLockoutDate,
U.LastLoginDate,
U.LastPasswordChangedDate,
U.IsLockedOut,
U.PasswordQuestion,
U.IsApproved
FROM dbo.vw_Users AS U
WHERE U.PortalID = ' + CONVERT(nvarchar(20), @PortalID) + '
AND (U.' + @PropertyName + ' LIKE ''' + @PropertyValue + '%'')
OR ((U.' + @PropertyName + ' LIKE ''% ' + @PropertyValue + '%''))
AND U.IsDeleted = 0
) AS U
WHERE RowNumber >= ' + @minRowNumberSql + ' 
),
TempUsersWithProfile
AS
(
SELECT 
U.UserID,
U.PortalID,
U.Username,
U.Email,
U.DisplayName,
U.IsSuperUser,
U.IsDeleted,
U.AffiliateID,
U.UpdatePassword,
U.Authorised,
U.CreateDate,
U.LastActivityDate,
U.LastLockoutDate,
U.LastLoginDate,
U.LastPasswordChangedDate,
U.IsLockedOut,
U.PasswordQuestion,
U.IsApproved,
P.PropertyName,
P.PropertyValue
FROM TempUsers U
INNER JOIN dbo.vw_Profile P ON P.UserID = U.UserID
AND P.PortalId = U.PortalId
)

SELECT  * FROM TempUsersWithProfile
PIVOT 
(
MAX(PropertyValue) for PropertyName in (' + @pivotSql + ')
) as pivotTable
' + @sortSql
EXEC(@sql)


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syshobtcolumns'.'clust' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 RoleSettings Table */
/**************************/

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[RoleSettings]') AND type in (N'U'))
BEGIN
CREATE TABLE dbo.[RoleSettings]
(
[RoleSettingID] [int] IDENTITY(1,1) NOT NULL,
[RoleID] [int] NOT NULL,
[SettingName] [nvarchar](50) NOT NULL,
[SettingValue] [nvarchar](2000) NOT NULL,
[CreatedByUserID] [int] NOT NULL,
[CreatedOnDate] [datetime] CONSTRAINT [DF_RoleSettings_CreatedOnDate]  DEFAULT (getdate()) NOT NULL ,
[LastModifiedByUserID] [int] NOT NULL,
[LastModifiedOnDate] [datetime] CONSTRAINT [DF_RoleSettings_LastModifiedOnDate]  DEFAULT (getdate()) NOT NULL,
CONSTRAINT [PK_RoleSettings] PRIMARY KEY CLUSTERED ( [RoleSettingID] ASC )
)
END


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syscolpars'.'clst' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 AddRole Procedure */
/*************************/

CREATE PROCEDURE dbo.[AddRole] 
@PortalID         int,
@RoleGroupId      int,
@RoleName         nvarchar(50),
@Description      nvarchar(1000),
@ServiceFee       money,
@BillingPeriod    int,
@BillingFrequency char(1),
@TrialFee         money,
@TrialPeriod      int,
@TrialFrequency   char(1),
@IsPublic         bit,
@AutoAssignment   bit,
@RSVPCode         nvarchar(50),
@IconFile         nvarchar(100),
@CreatedByUserID  int,
@Status  int,
@SecurityMode   bit
AS

INSERT INTO dbo.Roles (
 PortalId,
 RoleGroupId,
 RoleName,
 Description,
 ServiceFee,
 BillingPeriod,
 BillingFrequency,
 TrialFee,
 TrialPeriod,
 TrialFrequency,
 IsPublic,
 AutoAssignment,
 RSVPCode,
 IconFile,
 CreatedByUserID,
 CreatedOnDate,
 LastModifiedByUserID,
 LastModifiedOnDate,
 Status,
 SecurityMode
)

VALUES (
 @PortalID,
 @RoleGroupId,
 @RoleName,
 @Description,
 @ServiceFee,
 @BillingPeriod,
 @BillingFrequency,
 @TrialFee,
 @TrialPeriod,
 @TrialFrequency,
 @IsPublic,
 @AutoAssignment,
 @RSVPCode,
 @IconFile,
 @CreatedByUserID,
 getdate(),
 @CreatedByUserID,
 getdate(),
 @Status,
 @SecurityMode
)

SELECT SCOPE_IDENTITY()



System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysschobjs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[GetUserByDisplayName]

@PortalID int,
@DisplayName nvarchar(128)

AS
SELECT * FROM dbo.vw_Users
WHERE  DisplayName = @DisplayName
AND  ((@PortalId IS NULL) OR (PortalId = @PortalID) OR IsSuperUser = 1)


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysschobjs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 Columns To UserRoles Table */
/**************************************/

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME='dbo.UserRoles' AND COLUMN_NAME='Status')
BEGIN
ALTER TABLE dbo.UserRoles
ADD [Status] int NOT NULL CONSTRAINT DF_UserRoles_Status DEFAULT 1
END


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.sysschobjs'.'nc1' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME='dbo.UserRoles' AND COLUMN_NAME='IsOwner')
BEGIN
ALTER TABLE dbo.UserRoles
ADD IsOwner bit NOT NULL CONSTRAINT DF_UserRoles_IsOwner DEFAULT 0
END


System.Data.SqlClient.SqlException: Invalid column name 'Status'.
Invalid column name 'IsOwner'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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 VIEW dbo.[vw_UserRoles]
AS
SELECT     
UR.UserRoleID, 
R.RoleID, 
U.UserID, 
R.PortalID, 
R.RoleName, 
U.Username, 
R.Description, 
U.DisplayName, 
U.Email,
UR.Status, 
UR.IsOwner,
R.SecurityMode,
R.ServiceFee, 
R.BillingFrequency, 
R.TrialPeriod, 
        R.TrialFrequency, 
R.BillingPeriod, 
R.TrialFee, 
R.IsPublic, 
R.AutoAssignment, 
R.RoleGroupID, 
R.RSVPCode, 
R.IconFile, 
UR.EffectiveDate, 
UR.ExpiryDate, 
        UR.IsTrialUsed, 
UR.CreatedByUserID, 
UR.CreatedOnDate, 
UR.LastModifiedByUserID, 
UR.LastModifiedOnDate 
FROM dbo.UserRoles AS UR 
INNER JOIN dbo.Users AS U ON UR.UserID = U.UserID 
INNER JOIN dbo.Roles AS R ON UR.RoleID = R.RoleID
WHERE R.Status = 1



System.Data.SqlClient.SqlException: Invalid column name 'Status'.
Invalid column name 'IsOwner'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[AddUserRole]
@PortalID int,
@UserID int,
@RoleId int,
@Status int,
@IsOwner bit,
@EffectiveDate datetime = null,
@ExpiryDate datetime = null,
@CreatedByUserID  int
AS

DECLARE @UserRoleId int

SELECT @UserRoleId = null

SELECT @UserRoleId = UserRoleId
FROM dbo.UserRoles
WHERE  UserId = @UserID AND RoleId = @RoleId
 
IF @UserRoleId IS NOT NULL
BEGIN
UPDATE dbo.UserRoles
SET 
Status = @Status,
IsOwner = @IsOwner,
ExpiryDate = @ExpiryDate,
EffectiveDate = @EffectiveDate,
IsTrialUsed = 1,
LastModifiedByUserID = @CreatedByUserID,
LastModifiedOnDate = getdate()
WHERE  UserRoleId = @UserRoleId
SELECT @UserRoleId
END
ELSE
BEGIN
INSERT INTO dbo.UserRoles (
UserId,
RoleId,
Status,
IsOwner,
EffectiveDate,
ExpiryDate,
IsTrialUsed,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate
 )
VALUES (
@UserID,
@RoleId,
@Status,
@IsOwner,
@EffectiveDate,
@ExpiryDate,
1,
@CreatedByUserID,
getdate(),
@CreatedByUserID,
getdate()
 )

SELECT SCOPE_IDENTITY()
    END


System.Data.SqlClient.SqlException: Invalid column name 'Status'.
Invalid column name 'IsOwner'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[UpdateUserRole]
    @UserRoleId int, 
@Status int,
@IsOwner bit,
@EffectiveDate datetime = null,
@ExpiryDate datetime = null,
@LastModifiedByUserID int
AS
UPDATE dbo.UserRoles 
SET 
Status = @Status,
IsOwner = @IsOwner,
ExpiryDate = @ExpiryDate,
EffectiveDate = @EffectiveDate,
IsTrialUsed = 1,
LastModifiedByUserID = @LastModifiedByUserID,
LastModifiedOnDate = getdate()
WHERE  UserRoleId = @UserRoleId


System.Data.SqlClient.SqlException: Could not allocate space for object 'sys.syscolpars'.'clst' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[AddModuleSetting]
@ModuleId int,
@SettingName nvarchar(50),
@SettingValue nvarchar(max),
@CreatedByUserID int
AS
INSERT INTO dbo.ModuleSettings ( 
ModuleId,
SettingName,
SettingValue,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate
) 
VALUES ( 
@ModuleId, 
@SettingName, 
@SettingValue,
@CreatedByUserID,
getdate(),
@CreatedByUserID,
getdate()
)


System.Data.SqlClient.SqlException: Invalid column name 'IsOwner'.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[GetServices]
@PortalId  int,
@UserId    int

AS
SELECT     
R.*,
UR.IsOwner, 
UR.UserRoleID, 
UR.UserID, 
UR.ExpiryDate, 
UR.IsTrialUsed, 
UR.EffectiveDate, 
U.DisplayName, 
U.Email
FROM dbo.Users U 
INNER JOIN dbo.UserRoles AS UR ON U.UserID = UR.UserID 
RIGHT OUTER JOIN dbo.Roles AS R ON UR.RoleID = R.RoleID AND UR.UserID = @UserId
WHERE  R.PortalId = @PortalId AND R.IsPublic = 1
ORDER BY R.RoleName



System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.DesktopModules'.'PK_DesktopModules' in database '3_03249dc_1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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)



/* Update version number in DesktopModules */
/*******************************************/
DECLARE @version nvarchar(8)
SET @version = '06.02.00'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='SiteWizard'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Lists'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Authentication'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='FileManager'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='SiteLog'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Newsletters'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Portals'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='SQL'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='HostSettings'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='RecycleBin'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='LogViewer'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Scheduler'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='SearchAdmin'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Security'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Tabs'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Vendors'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Banners'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='ProfessionalPreview'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='SearchInput'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='SearchResults'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='FeedExplorer'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Extensions'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Solutions'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='WhatsNew'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Dashboard'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Languages'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Skins'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='SkinDesigner'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Console'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='GoogleAnalytics'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Marketplace'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='ViewProfile'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='Sitemap'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='ContentList'
UPDATE dbo.DesktopModules SET Version = @version WHERE ModuleName='ConfigurationManager'

UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Authentication'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Banners'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.FeedExplorer'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.FileManager'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.HostSettings'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Lists'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.LogViewer'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Newsletters'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Portals'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.RecycleBin'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Scheduler'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SearchAdmin'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SearchInput'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SearchResults'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Security'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SiteLog'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SiteWizard'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Tabs'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SQL'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Vendors'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.ACTIONBUTTONSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.ACTIONSSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.BANNERSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.BREADCRUMBSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.COPYRIGHTSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.CURRENTDATESkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.DOTNETNUKESkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.DROPDOWNACTIONSSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.HELPSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.HOSTNAMESkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.ICONSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.LANGUAGESkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.LINKACTIONSSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.LINKSSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.LOGINSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.LOGOSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.MENUSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.NAVSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.PRINTMODULESkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.PRIVACYSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SEARCHSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SIGNINSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SOLPARTACTIONSSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.SOLPARTMENUSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.TERMSSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.TITLESkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.TREEVIEWSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.USERSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.VISIBILITYSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Extensions'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Solutions'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.TEXTSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.WhatsNew'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.STYLESSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.LEFTMENUSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.JQUERYSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.CONTROLPANEL.SkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Dashboard'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Languages'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Skins'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Skin Designer'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Console'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Google Analytics'
UPDATE dbo.Packages SET Version = @version WHERE Name='DefaultAuthentication'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Marketplace'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.ViewProfile'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Sitemap'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.TagsSkinObject'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.ContentList'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.Configuration Manager'
UPDATE dbo.Packages SET Version = @version WHERE Name='DotNetNuke.ProfessionalPreview'

UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1619' WHERE ControlSrc='DesktopModules/Admin/Security/Roles.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1625' WHERE ControlSrc='DesktopModules/Admin/Security/EditRoles.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1582' WHERE ControlSrc='DesktopModules/Admin/Tabs/Tabs.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1586' WHERE ControlSrc='DesktopModules/Admin/Tabs/ManageTabs.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1387' WHERE ControlSrc='DesktopModules/Admin/Portals/SiteSettings.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1700' WHERE ControlSrc='DesktopModules/Admin/Security/Users.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1709' WHERE ControlSrc='DesktopModules/Admin/Security/ManageUsers.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1733' WHERE ControlSrc='DesktopModules/Admin/Vendors/Vendors.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1743' WHERE ControlSrc='DesktopModules/Admin/Vendors/EditVendors.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=190' WHERE ControlSrc='DesktopModules/Admin/Banners/DisplayBanners.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=195' WHERE ControlSrc='DesktopModules/Admin/Banners/BannerOptions.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1464' WHERE ControlSrc='DesktopModules/Admin/FileManager/FileManager.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1480' WHERE ControlSrc='DesktopModules/Admin/FileManager/WebUpload.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1640' WHERE ControlSrc='DesktopModules/Admin/SiteLog/SiteLog.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1515' WHERE ControlSrc='DesktopModules/Admin/Newsletters/Newsletter.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1748' WHERE ControlSrc='DesktopModules/Admin/Vendors/EditBanner.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1618' WHERE ControlSrc='DesktopModules/Admin/Security/SecurityRoles.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1189' WHERE ControlSrc='DesktopModules/Admin/Portals/Portals.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1207' WHERE ControlSrc='DesktopModules/Admin/SQL/SQL.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1121' WHERE ControlSrc='DesktopModules/Admin/HostSettings/HostSettings.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1601' WHERE ControlSrc='DesktopModules/Admin/RecycleBin/RecycleBin.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1756' WHERE ControlSrc='DesktopModules/Admin/Vendors/EditAffiliate.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1436' WHERE ControlSrc='DesktopModules/Admin/LogViewer/LogViewer.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1449' WHERE ControlSrc='DesktopModules/Admin/LogViewer/EditLogTypes.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1211' WHERE ControlSrc='DesktopModules/Admin/Scheduler/ViewSchedule.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1219' WHERE ControlSrc='DesktopModules/Admin/Scheduler/EditSchedule.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1213' WHERE ControlSrc='DesktopModules/Admin/Scheduler/ViewScheduleHistory.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1214' WHERE ControlSrc='DesktopModules/Admin/Scheduler/ViewScheduleStatus.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1221' WHERE ControlSrc='DesktopModules/Admin/SearchAdmin/SearchAdmin.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1221' WHERE ControlSrc='DesktopModules/Admin/SearchResults/SearchResults.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1663' WHERE ControlSrc='DesktopModules/Admin/SiteWizard/SiteWizard.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1507' WHERE ControlSrc='DesktopModules/Admin/Lists/ListEditor.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1632' WHERE ControlSrc='DesktopModules/Admin/Security/EditGroups.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=332' WHERE ControlSrc='Admin/Users/ViewProfile.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1263' WHERE ControlSrc='DesktopModules/Admin/Extensions/Extensions.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1295' WHERE ControlSrc='DesktopModules/Admin/WhatsNew/WhatsNew.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1293' WHERE ControlSrc='DesktopModules/Admin/Dashboard/Dashboard.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1524' WHERE ControlSrc='DesktopModules/Admin/Languages/languageEnabler.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=212' WHERE ControlSrc='DesktopModules/Admin/Console/ViewConsole.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1611' WHERE ControlSrc='DesktopModules/Admin/Sitemap/SitemapSettings.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=2019' WHERE ControlSrc='DesktopModules/MemberDirectory/View.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=2018' WHERE ControlSrc='DesktopModules/SocialGroups/Loader.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=2018' WHERE ControlSrc='DesktopModules/SocialGroups/Create.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=2018' WHERE ControlSrc='DesktopModules/SocialGroups/ListSettings.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1665' WHERE ControlSrc='DesktopModules/Admin/Skins/editskins.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1297' WHERE ControlSrc='DesktopModules/Admin/XmlMerge/XmlMerge.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=2038' WHERE ControlSrc='DesktopModules/Admin/FiftyOneClientCapabilityProvider/Administration.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=1304' WHERE ControlSrc='DesktopModules/Admin/RadEditorProvider/ProviderConfig.ascx'
UPDATE dbo.ModuleControls SET HelpUrl = 'http://help.dotnetnuke.com/Default.aspx?tabid=111' WHERE ControlSrc='DesktopModules/Admin/ViewProfile/ViewProfile.ascx'

your database is full, please check file space, switch to simple recovery model, shink all files.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN