Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogDNN Blog 6.2.2 - error while searchDNN Blog 6.2.2 - error while search
Previous
 
Next
New Post
2/10/2016 8:17 AM
 
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?
 
New Post
2/10/2016 6:34 PM
 
most likely, a stored procedure did not get updated properly.
I suggest backing up your database and rerun all upgrade script past 6.1.1 in ascending order.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
2/11/2016 3:45 AM
 
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!
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogDNN Blog 6.2.2 - error while searchDNN Blog 6.2.2 - error while search


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out