Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problems after upgrade from 4.7.0 to 5.0.0, and then to 5.0.1Problems after upgrade from 4.7.0 to 5.0.0, and then to 5.0.1
Previous
 
Next
New Post
3/4/2009 12:35 AM
 

I did an upgrade from 4.7.0 to 5.0.0 and started to have problems. Below are the errors based on the Host Upgrade Log:

4.7.0 : The log file is empty for the script version specified. This generally indicates that the script ran successfully.
4.8.0: The log file is empty for the script version specified. This generally indicates that the script ran successfully.
4.8.1: The log file is empty for the script version specified. This generally indicates that the script ran successfully.
4.8.2: The log file is empty for the script version specified. This generally indicates that the script ran successfully.
4.9.0: The log file is empty for the script version specified. This generally indicates that the script ran successfully.
4.9.1: The log file is empty for the script version specified. This generally indicates that the script ran successfully.

5.0.0: ERROR (refer to the end of this post for full log)

I was logged in while doing the upgrade, so I could still see the Admin and Host menu after that. But the Admin and Host menu were missing several items e.g. Extensions, Dashboard etc.

I also could not access Skin Management, Module Definitions etc. The items are available in the menu, but when clicked; does not load any of the admin controls, just a blank page. However, I can still access Site Settings and Host Settings, and can edit the Text/HTML modules.

Then I logged out, closed the browser (Firefox), cleared browser cache and tried to access again. This time I could not log in and got the following error:

A critical error has occurred.
Method not found: 'System.Collections.Hashtable DotNetNuke.Services.Authentication.AuthenticationConfigBase.get_ModuleSettings()'.

I then upgraded to 5.0.1: The log file is empty for the script version specified. This generally indicates that the script ran successfully.

The upgrade fixed the login problem, but I am still missing Admin and Host menu items and cannot access the Skin Management and Module Definition options.

I've gone through 35 pages of forum posts and googled for a solution and couldn't find any. The closest I got was this forum post. I tried what Tim Simpson did but somehow I couldn't get it to work, or probably I did it wrong. I think I might need to make some changes to the database in order to fix the problem that I am facing.

Can anyone guide me on the changes that I need to make? Thanks!

The 5.0.0 Host Upgrade Log

System.Data.SqlClient.SqlException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)





/***********************************************************/
/* End Update Admin Modules to conform to Module Standards */
/***********************************************************/

/* Update Packages */
/*******************/

ALTER TABLE dbo.Packages
ADD PortalID int NULL

ALTER TABLE dbo.Packages
ALTER COLUMN Description nvarchar(2000) NULL

ALTER TABLE dbo.Packages
ALTER COLUMN License ntext NULL

ALTER TABLE dbo.Packages
ALTER COLUMN Manifest ntext NULL

ALTER TABLE dbo.Packages
ADD Owner nvarchar(100) NULL

ALTER TABLE dbo.Packages
ADD Organization nvarchar(100) NULL

ALTER TABLE dbo.Packages
ADD Url nvarchar(250) NULL

ALTER TABLE dbo.Packages
ADD Email nvarchar(100) NULL

ALTER TABLE dbo.Packages
ADD ReleaseNotes ntext NULL

ALTER TABLE dbo.Packages
ADD IsSystemPackage bit NOT NULL CONSTRAINT DF_Packages_IsSystemPackage DEFAULT 0

DROP INDEX IX_Packages ON dbo.Packages

CREATE UNIQUE NONCLUSTERED INDEX IX_Packages ON dbo.Packages ( Owner, Name, PortalID )



System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[AddPackage]
@PortalID int,
@Name nvarchar(50),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit
AS
INSERT INTO dbo.Packages
(
PortalID,
[Name],
FriendlyName,
[Description],
PackageType,
Version,
License,
Manifest,
ReleaseNotes,
[Owner],
Organization,
Url,
Email,
IsSystemPackage
)
VALUES (
@PortalID,
@Name,
@FriendlyName,
@Description,
@PackageType,
@Version,
@License,
@Manifest,
@ReleaseNotes,
@Owner,
@Organization,
@Url,
@Email,
@IsSystemPackage
)
SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[UpdatePackage]
@PortalID int,
@Name nvarchar(50),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit
AS
UPDATE dbo.Packages
SET
PortalID = @PortalID,
FriendlyName = @FriendlyName,
[Description] = @Description,
PackageType = @PackageType,
Version = @Version,
License = @License,
Manifest = @Manifest,
[Owner] = @Owner,
Organization = @Organization,
Url = @Url,
Email = @Email,
ReleaseNotes = @ReleaseNotes,
IsSystemPackage = @IsSystemPackage
WHERE [Name] = @Name



System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[GetPackages]
@PortalID int
AS
SELECT *
FROM dbo.Packages
WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
ORDER BY PackageType ASC, [FriendlyName] ASC


System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[GetPackagesByType]
@PortalID int,
@PackageType nvarchar(50)
AS
SELECT *
FROM dbo.Packages
WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
AND PackageType = @PackageType
ORDER BY [FriendlyName] ASC


System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.GetPackageByName
@PortalID int,
@Name nvarchar(250)
AS
SELECT *
FROM dbo.Packages
WHERE [Name] = @Name
AND (PortalID = @PortalID OR @PortalID IS NULL)


Error: The stored procedure 'dbo.AddPackage' doesn't exist.


Warm Regards,

Ed Borhan [ evolve | build | connect ]

A DotNetNuker Since 2005 (v 03.00.11)

Ed Borhan > adaptive webware
Think Gold Internet (TGI)
 
New Post
3/4/2009 5:36 PM
 

If you search for System.Collections.Hashtable there are lots of posts about it.
I think it might be less trouble to update directly to 5.0.1 (not sure).



Alex Shirley


 
New Post
3/5/2009 1:08 AM
 

I have already upgraded to 5.0.1, and that actually fixed the login (System.Collections.Hashtable) problem.

But the items in Admin and Host menu is still missing. Plus I cannot access Module Definitions and Skin Management. Both showed empty pages.


Warm Regards,

Ed Borhan [ evolve | build | connect ]

A DotNetNuker Since 2005 (v 03.00.11)

Ed Borhan > adaptive webware
Think Gold Internet (TGI)
 
New Post
3/5/2009 3:44 AM
 

Try restarting IIS, clearing your cache/cookies, checking your permissions and google: site:dotnetnuke.com Admin Host menu missing to start with.

If you've got cardspace in there somewhere then delete it.
Look at the change log in support.dotnetnuke.com for issues fixed in 5.0.1, fixes that might be relevant to your situation.... it's possible there is some dirty data that 5.0.0 has produced... the issues might give a clue as to how to clear that up.

You may find it easier to trial an upgrade direct to 5.0.1 bypassing 5.0.0... assuming you have a backup. Not sure what the results would be.



Alex Shirley


 
New Post
3/5/2009 5:03 AM
 

How is the issue related to IIS and requiring a restart of IIS?

What are the permissions required to run version 5.0.x; that is different from 4.x?

I googled and found this forum post.

How is cardspace related to the missing menu items or the blank pages? What and where should I delete items related to cardspace (files and/or database)?

I went through the changelog for 5.0.1, and couldn't find references to any case similar to mine. So perhaps I should log the case. Is anyone else facing the same problem, or is it just me?

I don't have a back-up. Yes, I should have done a back-up. My bad. Moving on.


Warm Regards,

Ed Borhan [ evolve | build | connect ]

A DotNetNuker Since 2005 (v 03.00.11)

Ed Borhan > adaptive webware
Think Gold Internet (TGI)
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problems after upgrade from 4.7.0 to 5.0.0, and then to 5.0.1Problems after upgrade from 4.7.0 to 5.0.0, and then to 5.0.1


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out