I've just upgraded a site on Arvixe to 2.3.9.7 but got this feedback:

Welcome to mojoPortal Setup

Setup is disabled but running setup anyway because current user is an administrator.
Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema is up to date.
1 site(s) found.
Configuring feature Html Content - 00:00:00.1470000
Configuring feature Site Statistics - 00:00:00.1690000
Configuring feature Child Page Site Map - 00:00:00.1740000
Configuring feature Newsletter Sign Up Form - 00:00:00.1750000
Configuring feature Recent Content - 00:00:00.1850000
An Error Occurred:String or binary data would be truncated. The statement has been terminated.
Source:.Net SqlClient Data Provider
Stack Trace at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) at mojoPortal.Data.SqlParameterHelper.ExecuteNonQuery() at mojoPortal.Data.DBModuleDefinition.UpdateModuleDefinitionSetting(Guid featureGuid, Int32 moduleDefId, String resourceFile, String groupName, String settingName, String settingValue, String controlType, String regexValidationExpression, String controlSrc, String helpKey, Int32 sortOrder) at mojoPortal.Business.ModuleDefinition.UpdateModuleDefinitionSetting(Guid featureGuid, Int32 moduleDefId, String resourceFile, String groupName, String settingName, String settingValue, String controlType, String regexValidationExpression, String controlSrc, String helpKey, Int32 sortOrder) at mojoPortal.Web.UI.Pages.SetupHome.SetupFeature(ContentFeature feature) at mojoPortal.Web.UI.Pages.SetupHome.SetupFeatures(String applicationName) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 

The site now claims to be 2.3.9.7 but clearly the upgrade did not complete. What now?

Thanks

Have done the upgrade again - copying the 2.3.9.7 files into the faulty installation, set the machine key and folder permissions, then run /setup/default.aspx... same problem again.

Help would be appreciated. Stupidly, because these upgrades usually go smoothly, I do not have a complete copy of both folders plus database from just before this upgrade attempt, so cannot simply revert to previous.

Hi Joe

Running those blog scripts in manually has fixed the blog - thanks. But running setup/default.aspx still throws the original error (above), suggesting a problem around the Recent Content feature or whatever comes immediately after that. Presumably this prevented any other scripts running, so it would be good to identify the cause.

I have remembered that this site had its database in SQLCE originally, then migrated to SQL Server. Could that be the cause?

PS I've just upgraded another site (without a hitch!) and found that this is the sequence:

Configuring feature Recent Content - 00:00:06.1030000
Configuring feature Sign In Module - 00:00:06.1710000
Configuring feature Site Search - 00:00:06.1720000
Configuring feature Bing Map - 00:00:06.2100000

so the error in my upgrade is presumably something to do with the Recent Content module or perhaps Sign In though that seems unlikely.

Hi Joe

The contents of mp_BlogComments have migrated successfully into mp_Comments, and the values in the [name] field were all <50 chars.

Any tips on how to diagnose what is going wrong?

thanks

Hi Joe

OK sorted - I scripted out all the tables from the bad database and compared to structures from a good one, and found a thousand diffs, then fixed the ones that seemed important.

I think the one that made the big difference and allowed the upgrade to run was mp_ModuleDefinitionSettings.SettingValue which was nvarchar(255).

Thanks for your help - have a couple of pints of Murphy's!