Article ID: 3795, created on Feb 8, 2008, last review on Apr 18, 2012

  • Applies to:
  • Helm 3

Resolution

Problem
 
Users receive an error on the billingMenu.asp page:
 
CCardType.AvailableCardTypes error '80040403'

Unable to perform account card type search.

/interfaces/standard/billingMenu.asp, line 131
 
Also errors may occur when using the autosignup.asp page such as
 
CCardType.AvailableCardTypesEx error '80040403'
Execution failed. SQL was: SELECT CardType.CardTypeID, CardType.CardName, CardType.RequireValidDate, CardType.RequireExpiryDate, CardType.RequireSecurityCode, CardType.RequireIssueNumber FROM CardType INNER JOIN UserPaymentGateway_CardType ON CardType.CardTypeID = UserPaymentGateway_CardType.CardTypeId INNER JOIN Account ON UserPaymentGateway_CardType.AccountNumber = Account.AccountNumber INNER JOIN UserPaymentGateway ON UserPaymentGateway_CardType.PaymentGatewayID = UserPaymentGateway.PaymentGatewayID WHERE (1 = 1) AND (Account.AccountNumber = 'ADMIN') AND (UserPaymentGateway.PaymentGatewayPropertyName = 'Enabled') AND (UserPaymentGateway.UserPaymentGatewayPropertyValue = 'Yes') GROUP BY CardType.CardTypeID, CardType.CardName, CardType.RequireValidDate, CardType.RequireExpiryDate, CardType.RequireSecurityCode, CardType.RequireIssueNumber (Cannot group by a bit column.)

 
Solution
 
You are running Helm on a MSQL 7 database. In order to use Auto-billing, Helm must be running on a MSSQL2000 / MSDE2000 database or higher.

110556ad4b9f1c73a3682661cd1dca89 152090ff5e9a05ea7e1cf0c248449638 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF