Hi, I am running version 5.0.1 and most things seem to work fine apart from this.  Are other people having this problem?  Is there a known fix for it?

When I go in to Page Settings, make any change, then click Update, I get this error message:

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Failed to convert parameter value from a String to a Int32. ---> System.formatException: Failed to convert parameter value from a String to a Int32. ---> System.formatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberformatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberformatInfo info) at System.String.System.IConvertible.ToInt32(IformatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IformatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) at System.Data.SqlClient.SqlParameter.GetCoercedValue() at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdateTab(Int32 TabId, String TabName, Boolean IsVisible, Boolean DisableLink, Int32 ParentId, String IconFile, String Title, String Description, String KeyWords, Boolean IsDeleted, String Url, String SkinSrc, String ContainerSrc, String TabPath, DateTime StartDate, DateTime EndDate, Int32 RefreshInterval, String PageHeadText, Boolean IsSecure, Boolean PermanentRedirect) at DotNetNuke.Entities.Tabs.TabController.UpdateTab(TabInfo updatedTab) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.SaveTabData(String strAction) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.cmdUpdate_Click(Object Sender, EventArgs e) --- End of inner exception stack trace ---

Here DotNetNuke is attempting to update the database with the changes you have entered, but there is a problem converting one of the values to an integer.  Take a look over your settings page and see if there is anything that might be causing this conversion problem (like entering a non-integer value into the "refresh interval" field, for example).

Posting a screenshot of the offending page settings screen, with all of the sections expanded, might also allow us to more easily help.

Brandon

Thanks Brandon

Unfortunately I get the error even if I have made no changes at all to the settings!  Maybe DNN tries to submit all the settings again even if no changes are made?

And it is happening on all pages, so I can send you a screenshot but I'm not sure if this will help.

Actually I've realised this page also updates the TabPermissions table - could it be anything to do with that?  Has this table changed at all in the newer versions of DNN and my upgrade maybe not upgraded the stored procedures properly?  Is there anyway I can test this?