Hi  

I get this error on upgrade:

System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

The statement has been terminated.

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)

   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

ClientConnectionId:85d13a84-3d78-4ab9-a6d1-e9800ad6151b

 

 

 

WITH RecursiveTabs (TabID, Level, TabPath)

AS

(

SELECT 

TabID,

0 AS Level,

CAST('//' + dbo.RemoveStringCharacters(TabName, '&? ./''-#') AS NVARCHAR(255)) AS TabPath

FROM dbo.Tabs

WHERE ParentId IS Null

 

UNION ALL

 

SELECT 

T.TabID,

R.Level + 1,

CAST(R.TabPath + '//' + dbo.RemoveStringCharacters(TabName, '&? ./''-#') AS NVARCHAR(255))

FROM dbo.Tabs T

INNER JOIN RecursiveTabs R ON T.ParentId = R.TabID

)

UPDATE dbo.Tabs SET Level = R.LEVEL, TabPath = R.TabPath

FROM dbo.Tabs T

LEFT JOIN RecursiveTabs R ON R.TabID = T.tabID

The site runs but when I try to naviage to a page the pages don't load correctly as the url is something like mydomin/.aspx.

Any ideas how I can fix this?

thanks

Gus

---

"if the only tool you have is a hammer you tend to see every problem as a nail" http://www.carawaydesign.com

I believe this issue is caused by the site having duplicate tab names in different locations.

For example, there are these pages:

http://www.mysite.com/MembersHome/Ene...
http://www.mysite.com/EnergyClimateCh...

There are different pages with the same name in different levels on the tree. The script breaks because it's not smart enough to see these as different tabs?

Any ideas how I can fix? Perhaps rename the pages before upgrade and then rename back?

will give that a try

---

"if the only tool you have is a hammer you tend to see every problem as a nail" http://www.carawaydesign.com

thanks for posting Sebastian

unfortunately that's not the case. There were some tabs with matching name but they had different parents.
I rolled back to the original backup and then renamed those tabs anyway and ran the upgrade.

I got the same error.

---

"if the only tool you have is a hammer you tend to see every problem as a nail" http://www.carawaydesign.com