Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Problem with Search function

  1. 10-19-2010, 01:00 PM #1
    Marc55 is offline Junior Member
    Join Date
    Oct 2010
    Posts
    0

    Default Problem with Search function

    A customer I have decided a few days ago that they wanted to empty their searchlog. After this they recive the following error message when using the searchfunction:

    Server Error in '/' Application.
    --------------------------------------------------------------------------------

    Invalid object name 'SearchLog'.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'SearchLog'.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:


    [SqlException: Invalid object name 'SearchLog'.]
    AspDotNetStorefrontCommon.DB.ExecuteSQL(String Sql)
    AspDotNetStorefront.searchadv.RenderContents(HtmlT extWriter writer)
    AspDotNetStorefront.SkinBase.CreateContent()
    AspDotNetStorefront.SkinBase.OnPreRender(EventArgs e)
    System.Web.UI.Control.PreRenderRecursiveInternal() +62
    System.Web.UI.Page.ProcessRequestMain() +1476


    Can anyone explain what has gone wrong here? The store they are using is ML 5.8.
  2. 10-20-2010, 12:00 PM #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    Sounds like instead of emptying the SearchLog table, they deleted it.
    ECommerce Shopping Cart