Having difficulty with the "Similar Products" page in catalog administration. I get a "The text, ntext, or image data type cannot be selected as DISTINCT" error on: SearchResultsGrid.DataBind();
I have seen that others (long ago) had a similar issue when using SQL 2000, which is what we are using, but I could find no resolution.
Only noticed this problem after upgrading to 7.0.5. I have found no other pages experiencing this problem, only occurs with the EditSimilarProducts.aspx page.
Suggestions?
-=Alan=-
Additional details:
AbleCommerce for ASP.NET
VERSION: 7.0.5.14053
MSSQL v2000
AC SCHEMA v2000
ASP.NET TRUST: Unrestricted
AjaxControlToolkit: 3.0.20229.20843
CommerceBuilder: 7.5.14053.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.5.14053.0
CommerceBuilder.CyberSource: 7.5.13718.0
CommerceBuilder.Data: 7.5.14053.0
CommerceBuilder.DataClient.Api: 7.5.14053.0
CommerceBuilder.DataClient.Csv: 1.0.0.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.5.14028.0
CommerceBuilder.PayPal: 7.4.13453.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.5.14053.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.4.13441.0
CommerceBuilder.WATax: 7.5.13942.0
CommerceBuilder.Web: 7.5.14053.0
ComponentArt.Web.UI: 2008.2.1267.35
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
DataPort.Framework: 7.4.221.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.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
Validators: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0
cannot be selected as DISTINCT
Re: cannot be selected as DISTINCT
If you will stay at SQL2000 you are likely to end up in more and more issues in the future. I have heard AbleCommerce will drop support for SQL2000 soon.
