 |
|
|
 |
Joined: 12/31/2006
Posts: 20
|
|
|
Hi,
I have 5.4.4. dnn site and want to upgrade to 5.6.2; but was trying to do in stages as suggested here on dotnetnuke site.
So while doing upgrade from 5.4.4 to 5.5.1, I have following error:
00:00:00.468 - Executing Script: 05.05.00.SqlDataProvider Error! (see 05.05.00.log.resources for more information)
Would you please tell me what shall be done:
- Is there fix for that (I was searching the issue, but I cannot actually pinpoint that there is one per se)
- Should I restore 5.4.4 version back, and then go to upgrade first to 5.5.0, and then do latest version
I hope you will be able to advise me on this.
Thank you.
Den
|
| |
|
|
 | |
|
|
 |
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
Please take a look at the following file: Providers/DataProviders/SqlDataProvider/05.05.00.log.resources to see the actual error that was logged. You may then post the error in this thread so we may examine it further. Were any other errors noted during the upgrade?
Depending on the error it may be necessary to restore the file system and database back to 5.4.4, correct whatever issue caused the error, then reattempt the upgrade. I have seen various recommended upgrade sequences but generally recommend going directly from 5.4.4 to 5.6.2.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |
|
|
|
Joined: 12/31/2006
Posts: 20
|
|
|
Hi William (again; i was replying on your post, but it seems it doesn't want to "show itself" - so i do apology if the same log is posted few times)
here is the log file:
System.Data.SqlClient.SqlException: 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)
at System.Data.SqlClient.SqlInternalConnection. (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)
/* Update IconFile References for Admin Tabs */
/*********************************************/
UPDATE dbo.Tabs
SET IconFile = '~/images/' + IconFile
WHERE IconFile LIKE 'icon_%'
AND (TabPath LIKE '//Host%' OR TabPath LIKE '//Admin%')
System.Data.SqlClient.SqlException: 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)
at System.Data.SqlClient.SqlInternalConnection. (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)
/* Set Admin and Host Pages to be Secure By Default */
/****************************************************/
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])
What are your thoughts on this?
Thank you.
Regards,
Den
|
| |
|
|
| |
|
|
|
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
Den,
New users of these forums are moderated until they make a certain number of posts so your replies and new posts will not appear immediately. Depending on the avaiibility of our team volunteers, most moderated posts get approved within a few minutes to a few hours at the most.
Regarding the errors that you posted . . . where those the ones found in the log file \Providers\DataProviders\SqlDataProvider\05.05.00.log.resources or some that you found in the event viewer? The reason that I ask is that no where in the 05.05.00.SqlDataProvider script file do the two SQL scripts appear.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |
|
|
|
Joined: 12/31/2006
Posts: 20
|
|
|
Hi William,
Yes, that log was copied from here: host > host settings > view upgrade log for version
and this log below is the copy of \Providers\DataProviders\SqlDataProvider\05.05.00.log.resources:
System.Data.SqlClient.SqlException: 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)
at System.Data.SqlClient.SqlInternalConnection. (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)
/* Fix incorrect culture codes assigned pre-5.5 */
/************************************************/
UPDATE dbo.Tabs
SET CultureCode = NULL
I hope this will help. what are your thoughts on this. Thank you.
Regards,
Den
|
| |
|
|
| |