an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > There is an error once I search a product Throu...
There is an error once I search a product Through a keyword
Last Post 1/7/2008 9:02:56 AM By robin. 11 replies.
Page 1 of 2 (12 posts) << First < Prev 1 2 Next > Last >> 
1/2/2008 8:35:12 AM
robin
Posts: 19
Joined: 4/23/2008
There is an error once I search a product Through a keyword

We're sorry, an internal error occurred that prevents the request to complete.

Our supporting staff has been notified with this error and will address this issue shortly. We profusely apologize for the inconvenience and for any damage this may cause. You might want to try the same action at later time.
1/2/2008 10:27:42 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: There is an error once I search a product Through a keyword

First make sure your exception handlling has configured correctly. In web.config file, search for <loggingConfiguration name="Logging Application Block" and look for the first listener. Make sure smtpServer and toAddress are correctly configured. In case that you see the message above, you will receive an exception email describing the all the exception details.

Another way is to check your eventlog and DotShoppingCart category to view the exception log.

DotShoppingCart Staff
1/6/2008 9:45:15 AM
robin
Posts: 19
Joined: 4/23/2008
Re: There is an error once I search a product Through a keyword

Hi, Luke Zhang

when I search product on the web or processed to the page "cart.aspx" and click "Processed to check out' button,the same error occured.

----------------------------------------error infomation----------------------------------

We're sorry, an internal error occurred that prevents the request to complete.

Our supporting staff has been notified with this error and will address this issue shortly. We profusely apologize for the inconvenience and for any damage this may cause. You might want to try the same action at later time.

-----------------------------------------------------------------------------------------------------------------

bellow is my a part of the web.Config file

 

    <loggingConfiguration name="Logging Application Block" tracingEnabled="true" defaultCategory="General" logWarningsWhenNoCategoriesMatch="true">
        <listeners>
            <add toAddress="service@dashshopping.com" fromAddress="service@dashshopping.com" subjectLineStarter="Unhandled Execption: " subjectLineEnder="" smtpServer="smtp.dashshopping.com" smtpPort="25" formatter="Text Formatter" listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.EmailTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" traceOutputOptions="None" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.EmailTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="Email TraceListener"/>
            <add source="DotShoppingCart" formatter="Text Formatter" log="DotShoppingCart" machineName="" listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.FormattedEventLogTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" traceOutputOptions="None" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.FormattedEventLogTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="Formatted EventLog TraceListener"/>
        </listeners>
        <formatters>
            <add template="Timestamp: {timestamp}&#xA;Message: {message}&#xA;Category: {category}&#xA;Priority: {priority}&#xA;EventId: {eventid}&#xA;Severity: {severity}&#xA;Title:{title}&#xA;Machine: {machine}&#xA;Application Domain: {appDomain}&#xA;Process Id: {processId}&#xA;Process Name: {processName}&#xA;Win32 Thread Id: {win32ThreadId}&#xA;Thread Name: {threadName}&#xA;Extended Properties: {dictionary({key} - {value}&#xA;)}" type="Microsoft.Practices.EnterpriseLibrary.Logging.Formatters.TextFormatter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="Text Formatter"/>
        </formatters>

.......

.

    <system.net>
        <mailSettings>
            <smtp deliveryMethod="network" from="service@dashshopping.com">
                <network host="smtp.dashshopping.com" port="25" defaultCredentials="true"/>
            </smtp>
        </mailSettings>
    </system.net>


my web site if www.dashshopping.com

Robin

Thank you
1/6/2008 9:48:08 AM
robin
Posts: 19
Joined: 4/23/2008
Re: There is an error once I search a product Through a keyword

following is the all web.config content

<?xml version="1.0"?>
<!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    \Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
    <configSections>
        <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
            <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
                <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
                <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
                    <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere"/>
                    <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
                    <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
                </sectionGroup>
            </sectionGroup>
        </sectionGroup>
        <section name="enterpriseLibrary.ConfigurationSource" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ConfigurationSourceSection, Microsoft.Practices.EnterpriseLibrary.Common, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
        <section name="securityCryptographyConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Security.Cryptography.Configuration.CryptographySettings, Microsoft.Practices.EnterpriseLibrary.Security.Cryptography, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
        <section name="loggingConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
        <section name="exceptionHandling" type="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Configuration.ExceptionHandlingSettings, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
        <section name="dscConfiguration" type="XShan.DotShoppingCart.Common.Configuration.DSCConfigurationSection, XShan.DotShoppingCart.Common"/>
        <section name="orderPipelineServiceConfiguration" type="XShan.DotShoppingCart.Common.Configuration.OrderPipelineServiceConfigurationSection, XShan.DotShoppingCart.Common"/>
        <section name="taskConfiguration" type="XShan.DotShoppingCart.Common.Configuration.TaskConfigurationSection, XShan.DotShoppingCart.Common"/>
    </configSections>
    <appSettings/>
    <connectionStrings>
        <!--<add name="dotshoppingcart" connectionString="Data Source=LIFENG/SQLEXPRESS;Initial Catalog=SQL2005_DashShop;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />-->
 <add name="dotshoppingcart" connectionString="Data Source=tcp:sql2k504.discountasp.net;Initial Catalog=SQL2005_451780888889_dashshop;User ID=***************;Password=****************;" providerName="System.Data.SqlClient" />
    </connectionStrings>
    <dscConfiguration>
        <DSC>
            <add name="DSCWebRootPath" value="none"/>
            <add name="ShadowServer" value="none"/>
            <add name="FixedHostName" value="dotshoppingcart"/>
            <add name="InstallPath" value="e:\web\dashshoppin\htdocs"/>
        </DSC>
    </dscConfiguration>
    <orderPipelineServiceConfiguration defaultProvider="">
        <providers>
            <!-- name must match with the entries in DSC_OrderPipeline_Processor_lkp, DSC_Order_Status_lkp -->

            <add name="OrderConfirmationEmail" type="XShan.DotShoppingCart.OrderPipeline.OrderEmailProcessorProvider, XShan.DotShoppingCart.OrderPipeline" emailTemplate="OrderConfirmation" />
            <add name="CreditCardAuthorization" type="XShan.DotShoppingCart.OrderPipeline.CreditCardProcessorProvider, XShan.DotShoppingCart.OrderPipeline" action="Authorization" />
            <add name="CreditCardCapture" type="XShan.DotShoppingCart.OrderPipeline.CreditCardProcessorProvider, XShan.DotShoppingCart.OrderPipeline" action="Capture" />
            <add name="PaypalExpressCapture" type="XShan.DotShoppingCart.OrderPipeline.PaypalExpressProcessorProvider, XShan.DotShoppingCart.OrderPipeline" action="Capture" />
            <add name="GoogleCheckoutCapture" type="XShan.DotShoppingCart.OrderPipeline.GoogleCheckoutProcessorProvider, XShan.DotShoppingCart.OrderPipeline" action="Capture" />
            <add name="GoogleCheckoutShipAndArchive" type="XShan.DotShoppingCart.OrderPipeline.GoogleCheckoutProcessorProvider, XShan.DotShoppingCart.OrderPipeline" action="ShipAndArchive" />
            <add name="OrderCompleteEmail" type="XShan.DotShoppingCart.OrderPipeline.OrderEmailProcessorProvider, XShan.DotShoppingCart.OrderPipeline" emailTemplate="OrderComplete" />
        </providers>
    </orderPipelineServiceConfiguration>

    <taskConfiguration defaultProvider="">
        <providers>
            <add name="DataRefresh" type="XShan.DotShoppingCart.OrderPipeline.DataRefreshTaskProvider, XShan.DotShoppingCart.OrderPipeline" />
        </providers>
    </taskConfiguration>

    <enterpriseLibrary.ConfigurationSource selectedSource="System Configuration Source">
        <sources>
            <add name="SiteConfigurationSource" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.FileConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"
              filePath="DSC.config" />
            <add name="System Configuration Source" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.SystemConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
        </sources>
    </enterpriseLibrary.ConfigurationSource>
    <securityCryptographyConfiguration defaultSymmetricCryptoInstance="RijndaelManaged">
        <symmetricCryptoProviders>
            <add algorithmType="System.Security.Cryptography.RijndaelManaged, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" protectedKeyFilename="e:\web\dashshoppin\htdocs\key\DotshoppingcartMaster.key" protectedKeyProtectionScope="LocalMachine" type="Microsoft.Practices.EnterpriseLibrary.Security.Cryptography.SymmetricAlgorithmProvider, Microsoft.Practices.EnterpriseLibrary.Security.Cryptography, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="RijndaelManaged"/>
        </symmetricCryptoProviders>
    </securityCryptographyConfiguration>
    <loggingConfiguration name="Logging Application Block" tracingEnabled="true" defaultCategory="General" logWarningsWhenNoCategoriesMatch="true">
        <listeners>
            <add toAddress="service@dashshopping.com" fromAddress="service@dashshopping.com" subjectLineStarter="Unhandled Execption: " subjectLineEnder="" smtpServer="smtp.dashshopping.com" smtpPort="25" formatter="Text Formatter" listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.EmailTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" traceOutputOptions="None" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.EmailTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="Email TraceListener"/>
            <add source="DotShoppingCart" formatter="Text Formatter" log="DotShoppingCart" machineName="" listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.FormattedEventLogTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" traceOutputOptions="None" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.FormattedEventLogTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="Formatted EventLog TraceListener"/>
        </listeners>
        <formatters>
            <add template="Timestamp: {timestamp}&#xA;Message: {message}&#xA;Category: {category}&#xA;Priority: {priority}&#xA;EventId: {eventid}&#xA;Severity: {severity}&#xA;Title:{title}&#xA;Machine: {machine}&#xA;Application Domain: {appDomain}&#xA;Process Id: {processId}&#xA;Process Name: {processName}&#xA;Win32 Thread Id: {win32ThreadId}&#xA;Thread Name: {threadName}&#xA;Extended Properties: {dictionary({key} - {value}&#xA;)}" type="Microsoft.Practices.EnterpriseLibrary.Logging.Formatters.TextFormatter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="Text Formatter"/>
        </formatters>
        <categorySources>
            <add switchValue="All" name="CacheRemove">
                <listeners>
                    <add name="Formatted EventLog TraceListener"/>
                </listeners>
            </add>
            <add switchValue="All" name="General">
                <listeners>
                    <add name="Formatted EventLog TraceListener"/>
                    <add name="Email TraceListener"/>
                </listeners>
            </add>
        </categorySources>
        <specialSources>
            <allEvents switchValue="All" name="All Events"/>
            <notProcessed switchValue="All" name="Unprocessed Category"/>
            <errors switchValue="All" name="Logging Errors &amp; Warnings">
                <listeners>
                    <add name="Formatted EventLog TraceListener"/>
                </listeners>
            </errors>
        </specialSources>
    </loggingConfiguration>
    <exceptionHandling>
        <exceptionPolicies>
            <add name="Unhandled Policy">
                <exceptionTypes>
                    <add type="System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" postHandlingAction="NotifyRethrow" name="Exception">
                        <exceptionHandlers>
                            <add logCategory="General" eventId="100" severity="Error" title="Enterprise Library Exception Handling" formatterType="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.TextExceptionFormatter, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" priority="0" type="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.LoggingExceptionHandler, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" name="Logging Handler"/>
                        </exceptionHandlers>
                    </add>
                </exceptionTypes>
            </add>
        </exceptionPolicies>
    </exceptionHandling>
    <system.web>
        <pages validateRequest="false">
            <controls>
                <add tagPrefix="ajax" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
                <add tagPrefix="ajaxc" namespace="AjaxControlToolkit" assembly="AjaxControlToolkit"/>
                <add tagPrefix="dsc" namespace="XShan.DotShoppingCart.WebControls" assembly="XShan.DotShoppingCart.WebControls"/>
            </controls>
        </pages>
        <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.
        -->
        <compilation debug="true">
            <assemblies>
                <add assembly="System.Management, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Configuration.Install, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
                <add assembly="Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add assembly="System.Messaging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Runtime.Serialization.Formatters.Soap, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.DirectoryServices.Protocols, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Web.RegularExpressions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            </assemblies>
        </compilation>
        <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
        <httpHandlers>
            <remove verb="*" path="*.asmx"/>
            <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
            <add path="dbfile.axd" verb="*" type="XShan.DotShoppingCart.HttpHandlers.DbFileHttpHandler, XShan.DotShoppingCart.HttpHandlers.DbFileHttpHandler"/>
            <add path="dbimage.axd" verb="*" type="XShan.DotShoppingCart.HttpHandlers.DbImageHttpHandler, XShan.DotShoppingCart.HttpHandlers.DbImageHttpHandler"/>
            <add path="dyimage.axd" verb="*" type="XShan.DotShoppingCart.HttpHandlers.DyImageHttpHandler, XShan.DotShoppingCart.HttpHandlers.DyImageHttpHandler"/>
        </httpHandlers>
        <httpModules>
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
        </httpModules>
        <authentication mode="Forms">
            <forms name=".ASPNET" loginUrl="login.aspx" cookieless="UseCookies" protection="All" timeout="30" path="/"/>
        </authentication>
        <anonymousIdentification enabled="true"/>
        <identity impersonate="false"/>
        <membership defaultProvider="SqlMembershipProvider" userIsOnlineTimeWindow="15" hashAlgorithmType="SHA1">
            <providers>
                <clear/>
                <add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" applicationName="DotShoppingCart" connectionStringName="dotshoppingcart" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" passwordAttemptWindow="10" passwordStrengthRegularExpression="" minRequiredPasswordLength="4" minRequiredNonalphanumericCharacters="0"/>
            </providers>
        </membership>
        <roleManager enabled="true" defaultProvider="SqlRoleProvider">
            <providers>
                <clear/>
                <add name="SqlRoleProvider" type="System.Web.Security.SqlRoleProvider" applicationName="DotShoppingCart" connectionStringName="dotshoppingcart" />
            </providers>
        </roleManager>
        <profile automaticSaveEnabled="true" defaultProvider="SqlProfileProvider" inherits="XShan.DotShoppingCart.Common.ProfileDSC">
            <providers>
                <clear/>
                <add name="SqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" applicationName="DotShoppingCart" connectionStringName="dotshoppingcart" />
            </providers>
            <properties>
                <group name="Whosonline">
                    <add name="EnableAutoRefresh" type="System.Boolean" allowAnonymous="false"/>
                    <add name="RefreshIntervalInMinutes" type="System.Int32" allowAnonymous="false"/>
                </group>
            </properties>
        </profile>
        <siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">
            <providers>
                <add name="CategorySiteMapProvider" type="Xshan.DotShoppingCart.Providers.CategorySiteMapProvider, Xshan.DotShoppingCart.Providers.CategorySiteMapProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"/>
            </providers>
        </siteMap>
        <!--
            The <customErrors> section enables configuration
            of what to do if/when an unhandled error occurs
            during the execution of a request. Specifically,
            it enables developers to configure html error pages
            to be displayed in place of a error stack trace.
        -->
        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm"/>
            <error statusCode="404" redirect="FileNotFound.htm"/>
        </customErrors>
    </system.web>
    <system.web.extensions>
        <scripting>
            <webServices>
                <!-- Uncomment this line to customize maxJsonLength and add a custom converter -->
                <!--
      <jsonSerialization maxJsonLength="500">
        <converters>
          <add name="ConvertMe" type="Acme.SubAcme.ConvertMeTypeConverter"/>
        </converters>
      </jsonSerialization>
      -->
                <!-- Uncomment this line to enable the authentication service. Include requireSSL="true" if appropriate. -->
                <!--
        <authenticationService enabled="true" requireSSL = "true|false"/>
      -->
                <!-- Uncomment these lines to enable the profile service. To allow profile properties to be retrieved
           and modified in ASP.NET AJAX applications, you need to add each property name to the readAccessProperties and
           writeAccessProperties attributes. -->
                <!--
      <profileService enabled="true"
                      readAccessProperties="propertyname1,propertyname2"
                      writeAccessProperties="propertyname1,propertyname2" />
      -->
            </webServices>
            <!--
      <scriptResourceHandler enableCompression="true" enableCaching="true" />
      -->
        </scripting>
    </system.web.extensions>
    <system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
        <modules>
            <add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
        </modules>
        <handlers>
            <remove name="WebServiceHandlerFactory-Integrated"/>
            <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
        </handlers>
    </system.webServer>
    <system.net>
        <mailSettings>
            <smtp deliveryMethod="network" from="service@dashshopping.com">
                <network host="smtp.dashshopping.com" port="25" defaultCredentials="true"/>
            </smtp>
        </mailSettings>
    </system.net>
    <location path="Checkout.aspx">
        <system.web>
            <authorization>
                <deny users="?"/>
            </authorization>
        </system.web>
    </location>
    <location path="CheckoutComplete.aspx">
        <system.web>
            <authorization>
                <deny users="?"/>
            </authorization>
        </system.web>
    </location>
    <location path="MyAccount.aspx">
        <system.web>
            <authorization>
                <deny users="?"/>
            </authorization>
        </system.web>
    </location>
    <location path="OrderDetail.aspx">
        <system.web>
            <authorization>
                <deny users="?"/>
            </authorization>
        </system.web>
    </location>
    <location path="Invoice.aspx">
        <system.web>
            <authorization>
                <deny users="?"/>
            </authorization>
        </system.web>
    </location>
    <location path="RateProduct.aspx">
        <system.web>
            <authorization>
                <deny users="?"/>
            </authorization>
        </system.web>
    </location>
    <location path="TellFriend.aspx">
        <system.web>
            <authorization>
                <deny users="?"/>
            </authorization>
        </system.web>
    </location>
    <location path="Controls/UploadFiles.aspx">
        <system.web>
            <authorization>
                <allow roles="Administrator"/>
                <deny users="*"/>
            </authorization>
        </system.web>
    </location>
</configuration>

thanks
1/6/2008 11:36:24 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: There is an error once I search a product Through a keyword

Can you TS to the machine and check the eventlog?

Another way is to turn off custom errors in your web.config file and you will see the error from the web page.

<customErrors mode="<font style="background-color: #ffff00">Off" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm"/>
            <error statusCode="404" redirect="FileNotFound.htm"/>
</customErrors>

DotShoppingCart Staff
1/6/2008 9:41:27 PM
robin
Posts: 19
Joined: 4/23/2008
Re: There is an error once I search a product Through a keyword

Hello Luck Zhang,

Thanks for your help.

I turn off custom errors in your web.config file and see the error from the web page  below:

<font style="background-color: #ffffff" color="#ff0000">The column prefix 'p' does not match with a table name or alias name used in the query.
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'p' because it is not full-text indexed.
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.

<font style="background-color: #ffffff" color="#ff0000">Exception Details: System.Data.SqlClient.SqlException: The column prefix 'p' does not match with a table name or alias name used in the query.
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'p' because it is not full-text indexed.

<font style="background-color: #ffffff" color="#ff0000">Source Error:

<font style="background-color: #ffffff" color="#ff0000">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.

How could I to do next step?

thanks
1/6/2008 9:46:47 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: There is an error once I search a product Through a keyword

Looks like either your SQL server doesn't support fulltext index. Check your DB provider.

DotShoppingCart Staff
1/6/2008 10:15:55 PM
robin
Posts: 19
Joined: 4/23/2008
Re: There is an error once I search a product Through a keyword

my web host and Sql SERVER2005 provider is  www.discountasp.net

The DISCOUNTASP.NET SQL 2005 Database Management Functions below:

<img height="11" alt="microsoft sql 2005 hosting with remote sql management" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Remote SQL 2005 Database Management
Connect to your MSSQL 2005 database with SQL Management Studio.

<img height="11" alt="ms sql 2005 hosting and control panel features" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Other SQL 2005 Hosting & Control Panel Features
<img height="11" alt="ms sql 2005 hosting with dbo rights" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> DBO Rights to SQL 2005
<img height="11" alt="mssql hosting with stored procedure support" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Stored procedure support
<img height="11" alt="sql fulltext search hosting" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Full text search
<img height="11" alt="ms sql2005 hosting with asp.net sql session support" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> ASP.NET SQL Session
<img height="11" alt="sql2005 hosting with tsql enhancements" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> T-SQL Enhancements
<img height="11" alt="sql2k5 hosting with xml data types" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> XML Data Types
<img height="11" alt="sql 2005 hosting with sql xml 4.0" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> SQLXML 4.0
<img height="11" alt="yukon hosting with mars multipld active result set" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Multiple Active Result Set (MARS)
<img height="11" alt="ms sql2005 hosting with xquery" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> XQuery
<img height="11" alt="mssql 2005 hosting with triggers" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Triggers
<img height="11" alt="sql 2005 hosting with sql cache dependency" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> SQL Cache Dependency
<img height="11" alt="ms sql 2005 hosting with sql native client" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> SQL Native Client
<img height="11" alt="order multipls sql 2005 databases" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Order Multiple SQL 2005 Database Addons
<img height="11" alt="mssql2005 hosting disk space meter" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> SQL Disk Space Meter
<img height="11" alt="ms sql 2005 user password reset tool" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> SQL Login Password Reset Tool
<img height="11" alt="sql server 2005 hosting with multiple user manager" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> Additional SQL 2005 Login Manager
<img height="11" alt="sql 2005 hosting" src="http://www.discountasp.net/images/blue_bullet.gif" width="11" border="0" /> And more....

 

so the sql server2005 support  Full text search
1/6/2008 10:29:41 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: There is an error once I search a product Through a keyword

How did you create dotshoppingcart DB? Did you use InstDSC.exe? DSC.exe should create DB with fulltext indexes for you. Anyway the issue is that you need to turn on fulltext index on your DB and create indexes for the tables.

DotShoppingCart Staff
1/6/2008 11:39:08 PM
robin
Posts: 19
Joined: 4/23/2008
Re: There is an error once I search a product Through a keyword

hello,Luke Zhang

I create dotshoppingcart DB not use InstDSC.exe,

I  direct run the SQL Script copy from "CreateDB.sql" file in the SQL Server Management Studio at my local machine.

and Shrink the DB with out full text search and up to the Romote Host server,and Attach MDF File Through then DisCOUNT.NET Attach MDF File Tool .

I know I must create fulltext index on DB Server and create indexes for the tables?

But I don't know how to do? because some products data have been saved at the database.

 

thanks
1/7/2008 12:03:48 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: There is an error once I search a product Through a keyword

Yes, you have to create fullindex index otherwise search and other features won't work. You'd better contact your service provider or educate yourself about fulltext index.

DotShoppingCart Staff
Page 1 of 2 (12 posts) << First < Prev 1 2 Next > Last >> 
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.