Sebastian Leupold wrote
sanjay: great, i.e. the original log must be preserved :)
Sebastian,
Of course...
For your convinience, I've translated the message in english :
System.Data.SqlClient.SqlException: The subquery returned several values. This is not allowed when the subquery follows =,! =, <, <=,>,> = Or when it is used as an expression.
The instruction was stops.
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)
/************************************************************/
/***** SqlDataProvider *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for dbo. and *****/
/***** *****/
/************************************************************/
update dbo.[Tabs] set IsSecure = 1
where PortalID is NULL
or TabID in (select AdminTabId from dbo.[Portals])
or ParentId in (select AdminTabId from dbo.[Portals])
For your information, all of the system's tabs are shown great. Some websites have SSL enabled and some other not. All of my websites have the same problem.
I didn't use any other naming convention rather than dbo and the table names aren't customized.
This script just set "True" to the column IsSecure on certain tables.
Thanks a lot for your help