AbleCommerce Shopping Cart Software

Hello:

I just ran the update patches for V7.04 with "Full text searching" enable. It looks fine as searching was doing very well. But a customer email me this morning and said that the "Product Finder" on the main page will cause a crash. I tried it and confirm that.

Then, I disabled the "Full text searching" but doing so end up that the 'Search' function crash!

I got reply from my hosting support and they said that it's either missing database schema or somehow fields missing.

Please help if anyone know how to fix the problem!

Thanks
Speedy
http://www.lightobject.com

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

The multi-part identifier "FTS.Rank" could not be bound.
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: The multi-part identifier "FTS.Rank" could not be bound.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[SqlException (0x80131904): The multi-part identifier "FTS.Rank" could not be bound.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +96
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
CommerceBuilder.Data.Database.a(DbCommand A_0, CommandBehavior A_1) +92
CommerceBuilder.Data.Database.ExecuteReader(DbCommand command) +100
CommerceBuilder.Products.ProductDataSource.NarrowSearch(String keyword, Int32 categoryId, Int32 manufacturerId, LSDecimal lowPrice, LSDecimal highPrice, Int32 maximumRows, Int32 startRowIndex, String sortExpression) +2999
ConLib_SearchPage.BindProductList() +220
ConLib_SearchPage.BindSearchResultsPanel() +71
ConLib_SearchPage.Page_Load(Object sender, EventArgs e) +236
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4205

I believe that the website you are talking about is:

http://www.lightobject.com

Can you please repeat the steps that how we can reproduce the issue? Also Can you please mention that which version of MS SQL Server you are using? SQL Server 2000 or 2005?

I just disable the "Full Text Searching" so that it's working now. But once I enabled it (will do it right after this message) and when you click the "Product Finder" the tag next to the 'Home" on the maing page, it crash. My site is: http://www.lightobject.com

I believe It's MS SQL 2008.

Here is some infor I get from Help on AB:

AbleCommerce for ASP.NET
VERSION: 7.0.4.13936
MSSQL v2008
AC SCHEMA v2005
ASP.NET TRUST: Unrestricted

AjaxControlToolkit: 1.0.20229.20821
CommerceBuilder: 7.4.13936.0
CommerceBuilder.AbleCommerceTax: 7.4.13043.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.3.12625.0
CommerceBuilder.BankOfCanada: 7.3.0.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.Configuration: 7.4.13416.0
CommerceBuilder.CyberSource: 7.4.13718.0
CommerceBuilder.Data: 7.4.13416.0
CommerceBuilder.DataClient.Api: 7.4.13416.0
CommerceBuilder.DataClient.Csv: 7.0.34.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.GoogleCheckout: 7.3.12468.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.10061.0
CommerceBuilder.PayJunction: 7.3.12625.0
CommerceBuilder.PaymentechOrbital: 7.3.12625.0
CommerceBuilder.PayPal: 7.4.13453.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.4.13564.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.4.13022.0
CommerceBuilder.USPS: 7.4.13441.0
CommerceBuilder.Web: 7.4.13416.0
ComponentArt.Web.UI: 2008.2.1267.3
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
edtFTPnet: 1.2.4.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.0
Microsoft.Web.Preview: 1.2.61025.0
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
System.Web.Extensions: 1.0.61025.0
System.Web.Extensions.Design: 1.0.61025.0
Validators: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0

I though that it may be caused by any "orphaned items" or item that set to "Hidden", so I did all clean up and deleted all those hidden items. I also ran the "rebuilt Index" but the problem still exits.

FYI, before I ran the update, I found that there a minor issue on my product catalog. Some items I added just couldn't appeared when clicking the Left Menu Catlogy button, unless I did sorting like "Z to A" or by Manufacturer. As long as I keep the default, a few items just couldn't show up on screen. May be it's a hint why the Full Text Searching crashed.

Thanks for your help

Speedy

Hello,

We have confirmed this issue in the ConLib/SearchPage.ascx.cs file distributed with AC704_SP1_13936.zip patch dated 6/14/10.

To immediately correct this issue, you can open the ConLib/SearchPage.ascx.cs and make the following change:

FROM: TO: Note that the only difference is the case of "Rank" changed to "RANK". At this time, we are still not certain where the issue originated.
An updated patch will be available later today.

Thank you,
Katie

Thank you Katie, it works!

Speedy

Hi Katie,

We were just looking for a solution to the same issue. Your solution works great.

Thanks,

Phil Chrisman

Sorry for the dumb question, I'm still struggling with the process flow for maintenance in this system that's still new to us:

Is there some kind of "official" patch for this issue (patched file) or at least an issue tracking number that I can refer to in case there is no separate patch released? We have not run into the problem so far but I'd like to keep our code base as fully patched as possible since we are now in the main phase of customizing a lot of the code. Having to go back later and account for missing patches is such a waste of time.

Looking at the HotPatches list for 7.0.4 on http://help.ablecommerce.com I couldn't find anything about this fix. Am I looking in the wrong spot again?

Thanks in advance for any guidance you can give.

-- Karin Stevenson