Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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 ForumsHelpHelptried to search - got critical errortried to search - got critical error
Previous
 
Next
New Post
11/1/2006 11:16 AM
 
Peter

Joined: 11/9/2003
Posts: 63
hi guys, i tested the search button in the category module and it gave me this error:

A critical error has occurred.
The stored procedure 'dbo.Help_SearchTutorials' doesn't exist.

can this be fixed?

Thanks
 
New Post
11/10/2006 12:08 AM
 
Philip Beadle


Joined: 1/7/2003
Posts: 1822

Here it is.  Don't know why it didnt work the irst time.  Just paste this into the SQL window.

CREATE PROCEDURE {databaseOwner}[{objectQualifier}Help_SearchTutorials]

@Search nvarchar(100),
@ModuleCategoryId int

AS

SELECT DISTINCT
 {databaseOwner}{objectQualifier}Help_Tutorials.TutorialGUID,
 {databaseOwner}{objectQualifier}Help_Tutorials.TutorialID,
 {databaseOwner}{objectQualifier}Help_Tutorials.Title,
 {databaseOwner}{objectQualifier}Help_Tutorials.ProductImage,
 {databaseOwner}{objectQualifier}Help_Tutorials.Featured,
 {databaseOwner}{objectQualifier}Help_Tutorials.KeyWords,
 {databaseOwner}{objectQualifier}Help_Tutorials.DownloadName,
 {databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc,
 {databaseOwner}{objectQualifier}Help_Tutorials.Archive,
 Description ='',
 0 AS ViewOrder
FROM      {databaseOwner}{objectQualifier}Help_Tutorials INNER JOIN
          {databaseOwner}{objectQualifier}Help_TutorialCategory ON {databaseOwner}{objectQualifier}Help_Tutorials.TutorialID = {databaseOwner}{objectQualifier}Help_TutorialCategory.TutorialID INNER JOIN
          {databaseOwner}{objectQualifier}Help_Category ON {databaseOwner}{objectQualifier}Help_TutorialCategory.CategoryID = {databaseOwner}{objectQualifier}Help_Category.CategoryID
WHERE     ({databaseOwner}{objectQualifier}Help_Category.ModuleID = @ModuleCategoryId AND {databaseOwner}{objectQualifier}Help_Category.Visible = 1)
AND  
 (
  ({databaseOwner}{objectQualifier}Help_Tutorials.Title LIKE N'%' + @Search + '%') OR
  ({databaseOwner}{objectQualifier}Help_Tutorials.KeyWords LIKE N'%' + @Search + '%') OR
  ({databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc LIKE N'%' + @Search + '%') OR
  ({databaseOwner}{objectQualifier}Help_Tutorials.Description LIKE N'%' + @Search + '%')
 )

GO

 

make sure you add 2 carriage returns at the end in the SQL window :)

Philip Beadle - Employee
 
New Post
11/10/2006 4:58 AM
 
Peter

Joined: 11/9/2003
Posts: 63
hi philip, i pasted the code in the SQL window and clicked "execute" and i get "There is an error in your query!" so i checked the "Run as Script" box and it went ok, then i try searching from help and i get the following error:

A critical error has occurred.
Parameter count does not match Parameter Value count.

i am testing on godaddy's "medium trust" account.. does it make a difference? i am not that great at SQL stuff..

let me know if you can fix this

Thanks
Peter
 
New Post
11/17/2006 6:22 AM
 
Erik van Ballegoij


Erik van Ballegoij's Avatar

erikvanballegoij.com
Joined: 4/7/2004
Posts: 4445

Philip,

the 02.00.04 SQLdataprovider file has this for the Help_SearchTutorials sproc:

CREATE PROCEDURE {databaseOwner}[{objectQualifier}Help_SearchTutorials]

@Search nvarchar(100)

AS

SELECT    
  {databaseOwner}{objectQualifier}Help_Tutorials.TutorialGUID,
  {databaseOwner}{objectQualifier}Help_Tutorials.TutorialID,
  {databaseOwner}{objectQualifier}Help_Tutorials.Title,
  {databaseOwner}{objectQualifier}Help_Tutorials.ProductImage,
  {databaseOwner}{objectQualifier}Help_Tutorials.Featured,
  {databaseOwner}{objectQualifier}Help_Tutorials.KeyWords,
  {databaseOwner}{objectQualifier}Help_Tutorials.DownloadName,
  {databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc,
  {databaseOwner}{objectQualifier}Help_Tutorials.Archive,
  {databaseOwner}{objectQualifier}Help_Tutorials.Description,
        0 AS ViewOrder
FROM {databaseOwner}{objectQualifier}Help_Tutorials
WHERE   ({databaseOwner}{objectQualifier}Help_Tutorials.Title LIKE N'%' + @Search + '%') OR
  ({databaseOwner}{objectQualifier}Help_Tutorials.KeyWords LIKE N'%' + @Search + '%') OR
        ({databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc LIKE N'%' + @Search + '%') OR
  ({databaseOwner}{objectQualifier}Help_Tutorials.Description LIKE N'%' + @Search + '%')

GO

This sproc seems to work fine with the 02.00.04 version of the module. Could it be that you displayed a sproc from a newer version of the module here?

The reason why this didnt make it in the install is that the reference to the 02.00.04.sqldataprovider is missing in the help.dnn file

For those of you how did add the sproc Philip mentioned to their portal, please change the sproc like this:

ALTER PROCEDURE {databaseOwner}[{objectQualifier}Help_SearchTutorials]

@Search nvarchar(100)

AS

SELECT    
  {databaseOwner}{objectQualifier}Help_Tutorials.TutorialGUID,
  {databaseOwner}{objectQualifier}Help_Tutorials.TutorialID,
  {databaseOwner}{objectQualifier}Help_Tutorials.Title,
  {databaseOwner}{objectQualifier}Help_Tutorials.ProductImage,
  {databaseOwner}{objectQualifier}Help_Tutorials.Featured,
  {databaseOwner}{objectQualifier}Help_Tutorials.KeyWords,
  {databaseOwner}{objectQualifier}Help_Tutorials.DownloadName,
  {databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc,
  {databaseOwner}{objectQualifier}Help_Tutorials.Archive,
  {databaseOwner}{objectQualifier}Help_Tutorials.Description,
        0 AS ViewOrder
FROM {databaseOwner}{objectQualifier}Help_Tutorials
WHERE   ({databaseOwner}{objectQualifier}Help_Tutorials.Title LIKE N'%' + @Search + '%') OR
  ({databaseOwner}{objectQualifier}Help_Tutorials.KeyWords LIKE N'%' + @Search + '%') OR
        ({databaseOwner}{objectQualifier}Help_Tutorials.ShortDesc LIKE N'%' + @Search + '%') OR
  ({databaseOwner}{objectQualifier}Help_Tutorials.Description LIKE N'%' + @Search + '%')

GO

and run it from Host > SQL

For those of you that read this prior to installing the module, just add this to the .dnn file:

        <file>
          <name>02.00.03.SqlDataProvider</name>
        </file>

(in the already existing <files> section of the file)

Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert

DNN Blog | Twitter: @erikvb | LinkedIn: Erik van Ballegoij on LinkedIn
 
New Post
11/20/2006 6:48 AM
 
Jan Olsmar


www.olsmar.com/
Joined: 9/19/2005
Posts: 1354

I did the changes below (abow) but is still not working. I have help dll 204.25045 and 101.25045

I get this

Message: DotNetNuke.Services.Exceptions.PageLoadException: 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.Modules.Help.SqlDataProvider.SearchTutorials(String searchText) at DotNetNuke.Modules.Help.HelpController.SearchTutorials(String searchText) at DotNetNuke.Modules.Help.Help.BindList(String searchText, Int32 categoryID) at DotNetNuke.Modules.Help.Help.OnModuleCommunication(Object s, ModuleCommunicationEventArgs e) at DotNetNuke.Modules.Help.NavPane.btnSearch_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsHelpHelptried to search - got critical errortried to search - got critical error


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out