Hi!

I get an error tring to use the Search in the Article module. I got the following exception. Can you see why I get this error?
Thanx!

/Niclas

Error retrieving the article list:
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String ProcedureName, Object[] commandParameters) at EfficionConsulting.Articles.ArticleController.SearchArticles(Int32 PortalId, String SearchTerm, String SortField) at EfficionConsulting.Articles.ArticleListBase.GetData() --- End of inner exception stack trace ---

--------------------------------------------------------------------------------
Error Loading the Article List:
DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at EfficionConsulting.Articles.ArticleListBase.GetDataPage() at EfficionConsulting.Articles.ArticleListBase.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Niclas,
No other users have reported this error and I cannot reproduce it. I will contact you separately to troubleshoot the problem.

After some additional digging, we did find the source of the problem. A new version, 4.0.14, is now available with a fix to this issue.

Please let me know if you have any additional problems.

Great David!
I did not get the your last post here that you found the problem, so I did start my own research today. I was just going to report the problem, but now saw you already found it.

Sorry, I should have contacted you directly when I found it. Let me know if you experience any other problems.

I have this issue too, but still in version 4.1.4.
Is ther a script that I can run to solve this problem?

This issue occurs in Version 4.1.4 on DNN 4.8.4.

I solved the problem myself by running the procedure scripts again. First I dropped the procedures. Then I runned all the !procedure!scripts in the install package: the procedure part of the installscript and the procedure parts of the update scripts. Now the search engine works fine.

Sorry for the delayed response. We usually respond to problems within 1 business day. I'm still looking into how this problem is occurring. The fix is to run the specific procedure that is giving the problem. Articles_GetSearchResults

If you are experiencing this problem, please run the following in you HOST-> SQL Tab:

/* ************ STORED PROCEDURE: Articles_GetSearchResults ******************/
ALTER PROCEDURE {databaseOwner}{objectQualifier}Articles_GetSearchResults
@PortalID int,
@SearchTerm varchar(100),
@ShowAuthOnly bit,
@SortField varchar(100)
AS
SELECT ItemID,
PortalID,
ModuleId,
Title,
Description,
Article,
Authed,
Featured,
ImageFile,
NumberOfViews,
CreatedDate,
PublishDate,
ExpireDate,
LastModifiedDate
FROM {databaseOwner}{objectQualifier}Article a
WHERE PortalID = @PortalID
AND (@SearchTerm = '' OR a.Title LIKE '%' + @SearchTerm + '%' OR a.Description LIKE '%' + @SearchTerm + '%'OR a.Article LIKE '%' + @SearchTerm + '%')
AND (@ShowAuthOnly = 0 OR Authed = 1)
ORDER BY
CASE @SortField
WHEN 'PublishDate' THEN PublishDate
WHEN 'LastModifiedDate' THEN LastModifiedDate
ELSE CreatedDate
END DESC,
LastModifiedDate DESC
GO

Thanks for the fix! I had to restart the DNN app for it to work, but all seems well now.