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 ...Packages Table Error when upgrading to 5.1.4Packages Table Error when upgrading to 5.1.4
Previous
 
Next
New Post
10/18/2009 10:15 PM
 

Hi,

I am upgrading from dotnetnuke 4.9.5 to 5.1.4. Here is a copy of my upgrade logs and errors. They all reference the packages table. Has anyone been able to fix this? Thanks!

DotNetNuke Errors:

00:00:00.066 -   Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:03.129 -   Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:05.462 -   Executing Script: 05.01.01.SqlDataProvider Error! (see 05.01.01.log for more information)
00:00:05.594 -   Executing Script: 05.01.03.SqlDataProvider Error! (see 05.01.03.log for more information)
00:00:05.767 -   Executing Application Upgrades: 05.00.00 Error!
00:00:08.822 -   Executing Application Upgrades: 05.01.00 Error!
00:00:09.040 -   Executing Application Upgrades: 05.01.03 Error!

Log File Errors:

System.Data.SqlClient.SqlException: 'FK_aubdnn_PackageAssemblies_PackageAssemblies' is not a constraint.
Could not drop constraint. See previous errors.

System.Data.SqlClient.SqlException: Could not drop object 'dbo.aubdnn_Packages' because it is referenced by a FOREIGN KEY constraint.
Error: The new name 'aubdnn_Packages' is already in use as a OBJECT name and would cause a duplicate that is not permitted.
Table 'aubdnn_Packages' already has a primary key defined on it.
Could not create constraint. See previous errors.

System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'ReleaseNotes'.
Invalid column name 'Owner'.
Invalid column name 'Organization'.
Invalid column name 'Url'.
Invalid column name 'Email'.
Invalid column name 'IsSystemPackage'.

 

 
New Post
10/19/2009 10:55 AM
 

 I hit a series of similar set of problems on a test upgrade from DNN 4.09.02 to 5.01.02 with SQL errors in the 05.00.00, 05.01.00, and 05.01.01.log files. All of the errors stemmed from failures to drop and the re-create the Packages table with major changes in its structure. Without the proper columns in the Packages table, many of the administrative controls (which moved from the \admin\controls folder to \DesktopModules\admin folder were not properly registered resulting in errors when navigating to Module Definitions, Extensions (was completely missing), Skins, etc.

Further analysis showed that the root of the problem was failure (in 05.00.00.SqlDataProvider script) when attempting to drop the foreign key constraint FK_DNN_PackageAssemblies_PackageAssemblies on the DNN_Packages table. Apparently back in DNN 4.06.xx or so when the Packages table was added to the database, there was a missing {objectQualifier} token in the name of this FK. For those of us who had defined an objectQualifier in their web.config (in my case it was "DNN_" and in your case is "aubdnn_"),  the resulting FK constraint name then became FK_PackageAssemblies_PackageAssemblies. For those not using an objectQualifier, there would be no problem in dropping the FK constraint.

In the 05.01.01.SqlDataProvider script another attempt is made (apprently to fix a related issue of the script not completing when run on MS SQL Server 2000) to restructure the Packages table but that too fails in when first attempting to drop the FK constraint FK_DNN_PackageAssemblies_PackageAssemblies which did not exist. With th FK constraint FK_PackageAssemblies_PackageAssemblies still in place on the Packages table, the table itself could not be dropped and replaced by the newly structured Packages table.

I finally worked around this first on the test site then the production site by directly editing the database to rename the FK constraint "FK_PackageAssemblies_PackageAssemblies on the Packages table to "FK_DNN_PackageAssemblies_PackageAssemblies" before triggering the upgrade. This time the upgrade completed without error and the site appeared to be working well. You would want to rename the FK constraint on the Packages table to  "FK_aubdnn_PackageAssemblies_PackageAssemblies".

As always take a full filesystem and database backup before attempting the upgrade.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
10/22/2009 8:26 PM
 

That did the trick. The foreign keys were in the Assemblies table and there were actually two foreign keys that didn't have the objectqualifier on them.

 
New Post
10/22/2009 10:29 PM
 

Glad that got you past the difficulties! BTW, what was the second FK ? I just checked the Packages and Assemblies table and found only the one FK that I mentioned in my post.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Packages Table Error when upgrading to 5.1.4Packages Table Error when upgrading to 5.1.4


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