Thank you! I'm almost sure I removed all .zip files. I have to restore my database and file directory once again for a new try! This is something I really don't want to do! Will this SqlProvider problem be solved when upgrading to 4.01?

Let's ask help from DotNetNuke team. Sebastian, can you help us?

---

Luiz Pires

Portuguese Language Packs

Well...i dont think that 5.04.01 will fix it....

00:00:00.017 - Upgrading to Version: 05.04.01
00:00:00.053 -   Executing Script: 05.04.00.SqlDataProvider Error! (see 05.04.00.log for more information)
00:00:00.851 -   Executing Script: 05.04.01.SqlDataProvider Success
 

here are my logs:

System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_PortalLocalization_Portals". The conflict occurred in database "DotNetNuke", table "dbo.Portals", column 'PortalID'.
at System.Data.SqlClient.SqlConnection.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)

/* Add Foreign Key to PortalLocalization Table */
/***********************************************/

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'FK_PortalLocalization_Portals') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
BEGIN
/* add key and cascade delete rule */
ALTER TABLE dbo.PortalLocalization
ADD CONSTRAINT FK_PortalLocalization_Portals
FOREIGN KEY ( PortalID ) REFERENCES dbo.Portals ( PortalID ) ON DELETE CASCADE
END

---

http://shop.smallinternetsolutions.com
UNLIMITED HOSTING for less...
Windows Hosting Starting at $3.95/mo