Well, I upgraded from 4.5.5 to 4.6.0 and it FAILED to upgrade the database. As soon as that happened, my site went dead.
I have not fully revived my site, but I do have some insight that might be of interest to other users, as well as to the DotNetNuke developers.
I have found a couple bugs in the 4.06.00.SqlDataProvider file that is provided.
/* Create Assemblies Table */
/***************************/
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'{databaseOwner}[{objectQualifier}Assemblies]') AND OBJECTPROPERTY(id, N'IsTable') = 1)
BEGIN
CREATE TABLE {databaseOwner}[{objectQualifier}Assemblies](
[AssemblyID] [int] IDENTITY(1,1) NOT NULL,
[PackageID] [int] NOT NULL,
[AssemblyName] [nvarchar](250) NOT NULL,
[Version] [nvarchar](20) NOT NULL,
CONSTRAINT [PK_****PackageAssemblies] PRIMARY KEY CLUSTERED ([AssemblyID] ASC)
)
ALTER TABLE {databaseOwner}[{objectQualifier}Assemblies]
ADD CONSTRAINT [FK_****PackageAssemblies_PackageAssemblies] FOREIGN KEY([PackageID]) REFERENCES {databaseOwner}[{objectQualifier}Packages] ([PackageID])
END
GO
The two sections with the **** are actually NOT included in the SQL. They should be replaced with the {objectQualifier} as they are for other FK and PK values. This happens a couple of times in the SQLprovider, and really messes up the installations...
And the same thing happens in the PackageTypes section
/* Create PackageTypes Table */
/*****************************/
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'{databaseOwner}[{objectQualifier}PackageTypes]') AND OBJECTPROPERTY(id, N'IsTable') = 1)
BEGIN
CREATE TABLE {databaseOwner}[{objectQualifier}PackageTypes]
(
[PackageType] [nvarchar](100) NOT NULL,
[Description] [nvarchar](500) NOT NULL,
[SecurityAccessLevel] [int] NOT NULL,
CONSTRAINT [PK_****_PackageTypes_1] PRIMARY KEY CLUSTERED ( [PackageType] ASC )
)
/* Add Auth_System Package Type */
INSERT INTO {databaseOwner}{objectQualifier}PackageTypes
( PackageType, Description, SecurityAccessLevel )
VALUES ( 'Auth_System', 'Authentication System', 3 )
END
GO
back