After repeated failures, I took Smahaffie's advice and it worked like a champ. I created a new DB with the same rights and reloaded all the files to reinstall. I moved all modules but html and links to a seperate hold directory and ran the install install/install.aspx?mode=install. The installation completed successfuly but the portal showed that some resouces were not available.

I placed the modules back in the install directory and it toook 2 additionall install/install.aspc?mode=InstallResources to get them all loaded. First one timed out on the store.

I am posting this is a bug in the prioritization of the install process - modules should go last since modules have an install mode that can resolve them.

Only a day wasted thanks to smahaffie...

Leif

Leif Johnston - leif@technologycatalyst.com

By the wat I also got another exceptions, I don't remember where I got them, but I'm writing here:

System.Data.SqlClient.SqlException: Invalid column name 'WIdth'.
   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) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

 

CREATE procedure dbo.dnn_GetFile

@FileName  nvarchar(100),
@PortalId  int,
@Folder nvarchar(200)

as

select FileId,
       FileName,
       Extension,
       Size,
       WIdth,
       Height,
       ContentType
from dnn_Files
where  FileName = @FileName AND Folder=@Folder
and    ((PortalId = @PortalId) or (@PortalId is null and PortalId is null))

 

 

 

 

System.Data.SqlClient.SqlException: Invalid column name 'WIdth'.
   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) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

 

CREATE procedure dbo.dnn_GetFiles

@PortalId   int,
@Folder nvarchar(200)
as

select FileId,
       PortalId,
       FileName,
       Extension,
       Size,
       WIdth,
       Height,
       ContentType
from dnn_Files
where  ((PortalId = @PortalId AND Folder=@Folder) or (@PortalId is null and PortalId is null AND Folder=@Folder))
order by FileName

 

 

 

 

System.Data.SqlClient.SqlException: Must declare the variable '@moduleid'.
   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) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

CREATE procedure dbo.dnn_GetModuleSetting

@ModuleId      int,
@SettingName   nvarchar(50)

as

select
'SettingValue' = case when dnn_Files.FileName is null then dnn_ModuleSettings.SettingValue else dnn_Files.Folder + dnn_Files.FileName end

from dnn_ModuleSettings
left outer join dnn_Files on dnn_ModuleSettings.SettingValue = 'fileid=' +
convert(varchar,dnn_Files.FileID)
where SettingName = @SettingName and moduleid=@moduleid

 

 

 

 

System.Data.SqlClient.SqlException: Invalid column name 'WIdth'.
   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) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

 

CREATE procedure dbo.dnn_UpdateFile

@FileId      int,
@FileName    nvarchar(100),
@Extension   nvarchar(100),
@Size        int,
@WIdth       int,
@Height      int,
@ContentType nvarchar(200),
@Folder nvarchar(200)

as

update dnn_Files
set    FileName = @FileName,
       Extension = @Extension,
       Size = @Size,
       WIdth = @WIdth,
       Height = @Height,
       ContentType = @ContentType,
       Folder=@Folder
where  FileId = @FileId

 

 

 

 

System.Data.SqlClient.SqlException: Invalid column name 'WIdth'.
   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) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

 

CREATE procedure dbo.dnn_AddFile

@PortalId    int,
@FileName    nvarchar(100),
@Extension   nvarchar(100),
@Size        int,
@WIdth       int,
@Height      int,
@ContentType nvarchar(200),
@Folder nvarchar(200)

as

insert into dnn_Files (
  PortalId,
  FileName,
  Extension,
  Size,
  WIdth,
  Height,
  ContentType,
  Folder
)
values (
  @PortalId,
  @FileName,
  @Extension,
  @Size,
  @WIdth,
  @Height,
  @ContentType,
  @Folder
)

select SCOPE_IDENTITY()

 

 

 

 

System.Data.SqlClient.SqlException: Invalid column name 'tabid'.
Invalid column name 'tabmoduleid'.
Invalid column name 'tabmoduleid'.
Invalid column name 'Moduleid'.
   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) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

 

CREATE PROCEDURE dbo.dnn_GetAllTabsModules

@PortalId int,
@AllTabs bit

AS

select
  dnn_tabmodules.tabid,
  dnn_Modules.*,
  dnn_DesktopModules.*
from   dnn_Modules
inner join dnn_ModuleDefinitions on dnn_Modules.ModuleDefID = dnn_ModuleDefinitions.ModuleDefID
inner join dnn_DesktopModules on dnn_ModuleDefinitions.DesktopModuleID = dnn_DesktopModules.DesktopModuleID
inner join dnn_TabModules on dnn_Modules.ModuleID = dnn_TabModules.ModuleID
where  dnn_Modules.PortalId = @PortalId and dnn_Modules.AllTabs = @AllTabs
  and dnn_tabmodules.tabmoduleid =(select min(tabmoduleid)
  from dnn_tabmodules
  where Moduleid = dnn_Modules.ModuleID)
order by dnn_Modules.ModuleId

 

 

 

System.Data.SqlClient.SqlException: Must declare the variable '@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) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 282

CREATE procedure dbo.dnn_GetBanner

@BannerId int,
@VendorId int,
@PortalID int

as

select dnn_Banners.BannerId,
       dnn_Banners.VendorId,
       'ImageFile' = case when dnn_Files.FileName is null then dnn_Banners.ImageFile else dnn_Files.Folder + dnn_Files.FileName end,
       dnn_Banners.BannerName,
       dnn_Banners.Impressions,
       dnn_Banners.CPM,
       dnn_Banners.Views,
       dnn_Banners.ClickThroughs,
       dnn_Banners.StartDate,
       dnn_Banners.EndDate,
       'CreatedByUser' = dnn_Users.FirstName + ' ' + dnn_Users.LastName,
       dnn_Banners.CreatedDate,
       dnn_Banners.BannerTypeId,
       dnn_Banners.Description,
       dnn_Banners.GroupName,
       dnn_Banners.Criteria,
       dnn_Banners.URL,       
       dnn_Banners.Width,
       dnn_Banners.Height
FROM   dnn_Banners
INNER JOIN dnn_Vendors ON dnn_Banners.VendorId = dnn_Vendors.VendorId
LEFT OUTER JOIN dnn_Users ON dnn_Banners.CreatedByUser = dnn_Users.UserID
left outer join dnn_Files on dnn_Banners.ImageFile = 'FileId=' + convert(varchar,dnn_Files.FileID)
where  dnn_Banners.BannerId = @BannerId
and   dnn_Banners.vendorId = @VendorId
AND (dnn_Vendors.PortalId = @PortalID or (dnn_Vendors.PortalId is null and @portalid is null))

The only way to reinstall the portal is to delete the database, and deleted the <InstallationDate> key from the web.config to do a clean install.  Don't foget to copy the HTMLText and Links module from original package file to the <yourdomain>/installs/modules directory.