I’m upgrade DNN Blog module from version 6.1.1 to version 6.2.2 and try to search in Blog module. (DNN ver. 7.4.2)
While search starts, I get the error:


Error: can not convert String to Int32.
In: in System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) in System.Data.SqlClient.SqlParameter.GetCoercedValue() in System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) in System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) in System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) in System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) in System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) in System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) in System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) in Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) in Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) in DotNetNuke.Modules.Blog.Data.SqlDataProvider.SearchPostsByCategory(Int32 moduleId, Int32 blogID, String displayLocale, Int32 userId, Boolean userIsAdmin, String categories, String searchText, Boolean searchTitle, Boolean searchContents, Int32 published, String limitToLocale, DateTime endDate, Int32 authorUserId, Int32 pageIndex, Int32 pageSize, String orderBy) in D:\Develop\DNNBlog\Components\Data\SqlDataProvider_CMD.vb:string 155 in DotNetNuke.Modules.Blog.Entities.Posts.PostsController.SearchPostsByCategory(Int32 moduleId, Int32 blogID, String displayLocale, String categories, String searchText, Boolean searchTitle, Boolean searchContents, Int32 published, String limitToLocale, DateTime endDate, Int32 authorUserId, Int32 pageIndex, Int32 pageSize, String orderBy, Int32& totalRecords, Int32 userId, Boolean userIsAdmin) in D:\Develop\DNNBlog\Components\Entities\Posts\PostsController.vb:string 175 in DotNetNuke.Modules.Blog.Blog.EnsurePostList(Int32 pageSize) in D:\Develop\DNNBlog\Blog.ascx.vb:string 497 in DotNetNuke.Modules.Blog.Blog.vtContents_GetData(String DataSource, Dictionary`2 Parameters, List`1& Replacers, List`1& Arguments, Object callingObject) in D:\Develop\DNNBlog\Blog.ascx.vb:string 253 in DotNetNuke.Modules.Blog.Templating.ViewTemplate.Template_GetData(String DataSource, Dictionary`2 Parameters, List`1& Replacers, List`1& Arguments, Object callingObject) in D:\Develop\DNNBlog\Components\Templating\ViewTemplate.vb:string 82 in DotNetNuke.Modules.Blog.Templating.Template.Template_GetData(String DataSource, Dictionary`2 Parameters, List`1& Replacers, List`1& Arguments, Object callingObject) in D:\Develop\DNNBlog\Components\Templating\Template.vb:string 34 in DotNetNuke.Modules.Blog.Templating.Template.ReplaceSubtemplates(Match m) in D:\Develop\DNNBlog\Components\Templating\Template.vb:string 133 in System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat) in System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator) in System.Text.RegularExpressions.Regex.Replace(String input, String pattern, MatchEvaluator evaluator) in DotNetNuke.Modules.Blog.Templating.Template.ReplaceContents() in D:\Develop\DNNBlog\Components\Templating\Template.vb:string 73


Can anybody give advice on how to resolve this error?

Fortunately, it was a simple “Copy-Paste” mistake.
In the file SqlDataProvider_CMD.vb string 147 you must correct the name of the stored procedure. Please, replace the name of procedure "Search Posts By Term" to other name "SearchPostsBy Category" inside the function SearchPostsByCategory .
The function must be:

Public Overrides Function SearchPostsByCategory(moduleId As Int32, blogID As Int32, displayLocale As String, userId As Int32, userIsAdmin As Boolean, categories As String, searchText As String, searchTitle As Boolean, searchContents As Boolean, published As Int32, limitToLocale As String, endDate As Date, authorUserId As Int32, pageIndex As Int32, pageSize As Int32, orderBy As String) As IDataReader
Return CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & ModuleQualifier & "SearchPostsByCategory", moduleId, blogID, displayLocale, userId, userIsAdmin, categories, searchText, searchTitle, searchContents, published, GetNull(limitToLocale), GetNull(endDate), authorUserId, pageIndex, pageSize, orderBy), IDataReader)
End Function


Thank to Author for the source code!