Greetings,

Just ran the 5.01 upgrade: unzipped the package over the existing install (in a virtual folder), replaced sql and token entries in the release.config file and renamed it to web.config. Browsed to localhost/dnn (my virtual folder name) and nothing - no feedback, no errors. The site appears to be running correctly, and shows as version 05.01, but the majority of my users (teachers) are off for the summer. And I did lose my admin/host icons (which I fixed with a script I found in the Forums - the ~/images problem) and I see errors in the dataprovider logs (mostly System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.). So I wonder if there are hidden problems waiting to bite me because the scripts didn't run or had errors I didn't see.

And yes - Network Services has full control over the dnn folder... ;)
Is there a manual way to kick off the database scripts or am I worrying over nothing?

Thanks!

Thanks Sebastian. The 05.01.00.log file is there.

The initial failure seems to have happened at the 05.00 upgrade:

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 )

Everything after that that looked for a PortalID column in the Packages table failed because the table schema was not altered. As a result, it seems that a lot of URL references are doubling up on the domain name, like: http://domain.com//http://domain.com/page.aspx. Do you think I should change the syntax on that failed script and run it manually?

Thanks again.