Gift Certificate Error when checking out.

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi, 

I have my Merchant Account setup and running in Product cart 4.0sp3. Standard products (non Gift Certificates) are processed succesfully via our gateway. However I we are receiving an error when we try to process Gift Certificates.

I have process orders when they are placed checked and have tried setting payment status set at both "authorized" and "paid" but still get the error when we try to cehckout. 

The Gift Cert orders ARE getting thru to out merchant as I can see them in the ePay interface.

Can anyone shed some light on this error for me? I've searched the forums and don't see anything related.

We are hosting the install on IIS6 on a SQL server internally. Error below

thank you!!
Steve

------------------------------------------------------
* Error At 3/9/2010 
1:04:00 PM
* CustomerRefID: XXXXXXXXXXXX
* Session ID: XXXXXXXXXXXXXXX
* 
Error Number: 9
* Error Source: Microsoft VBScript runtime error
* Error 
Description: Subscript out of range
* Last Query: SELECT 
pcCField_ID,pcCField_Name,pcCField_FieldType,pcCField_Value,pcCField_Length,pcCField_Maximum,pcCField_Required,pcCField_PricingCategories,pcCField_ShowOnReg,pcCField_ShowOnCheckout,'''',pcCField_Description 
FROM pcCustomerFields;
* RequestMethod: GET
* ServerPort: 443
* HTTPS: 
on
* LocalAddr: 192.168.254.202
* HostAddress :10.150.1.19
* UserAgent: 
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6.4; .NET CLR 1.1.4322; 
.NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; MS-RTC LM 8; 
.NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC EA 
2)
* URL: /store/pc/gwReturn.asp
* FormData: 
* HTTP Headers: 

*****************************
HTTP_CACHE_CONTROL:no-cache
HTTP_CONNECTION:Keep-Alive
HTTP_ACCEPT:image/gif, 
image/x-xbitmap, image/jpeg, image/pjpeg, application/xaml+xml, 
application/vnd.ms-xpsdocument, application/x-ms-xbap, 
application/x-ms-application, application/vnd.ms-excel, 
application/vnd.ms-powerpoint, application/msword, 
application/x-shockwave-flash, */*
HTTP_ACCEPT_ENCODING:gzip, 
deflate
HTTP_ACCEPT_LANGUAGE:en-us
HTTP_COOKIE:__utma=214372547.2811713850984207000.1245943414.1266945262.1267118577.54; 
__utmz=214372547.1265739287.47.13.utmcsr=comchannel.epd.org|utmccn=(referral)|utmcmd=referral|utmcct=/home.asp; 
pcfront%5FvisitedPrds=%2A10%2A3%2A1%2A; 
SavedCartGUID=FF79F9AB%2DE389%2D4EE9%2D9401%2D5758E2B57207; 
ASPSESSIONIDQATDACRA=OFLBEKICMPNDKOHDCEAGDCND
HTTP_HOST:www.XXX.XXX
HTTP_REFERER:https://xxx.xxx.xxx/store/pc/gweMoney.asp
HTTP_USER_AGENT:Mozilla/4.0 
(compatible; MSIE 7.0; Windows NT 5.1; GTB6.4; .NET CLR 1.1.4322; .NET CLR 
2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; MS-RTC LM 8; .NET CLR 
3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC EA 
2)
HTTP_UA_CPU:x86
*****************************
------------------------------------------------------

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
sdittemore Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 30-July-2009 Status: Offline Points: 0	Post Options Post Reply Quote sdittemore Report Post Thanks(0) Quote Reply Topic: Gift Certificate Error when checking out. Posted: 09-March-2010 at 2:12pm
	Hi, I have my Merchant Account setup and running in Product cart 4.0sp3. Standard products (non Gift Certificates) are processed succesfully via our gateway. However I we are receiving an error when we try to process Gift Certificates. I have process orders when they are placed checked and have tried setting payment status set at both "authorized" and "paid" but still get the error when we try to cehckout. The Gift Cert orders ARE getting thru to out merchant as I can see them in the ePay interface. Can anyone shed some light on this error for me? I've searched the forums and don't see anything related. We are hosting the install on IIS6 on a SQL server internally. Error below thank you!! Steve ------------------------------------------------------ * Error At 3/9/2010 1:04:00 PM * CustomerRefID: XXXXXXXXXXXX * Session ID: XXXXXXXXXXXXXXX * Error Number: 9 * Error Source: Microsoft VBScript runtime error * Error Description: Subscript out of range * Last Query: SELECT pcCField_ID,pcCField_Name,pcCField_FieldType,pcCField_Value,pcCField_Length,pcCField_Maximum,pcCField_Required,pcCField_PricingCategories,pcCField_ShowOnReg,pcCField_ShowOnCheckout,'''',pcCField_Description FROM pcCustomerFields; * RequestMethod: GET * ServerPort: 443 * HTTPS: on * LocalAddr: 192.168.254.202 * HostAddress :10.150.1.19 * UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6.4; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; MS-RTC LM 8; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC EA 2) * URL: /store/pc/gwReturn.asp * FormData: * HTTP Headers: ***************************** HTTP_CACHE_CONTROL:no-cache HTTP_CONNECTION:Keep-Alive HTTP_ACCEPT:image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/xaml+xml, application/vnd.ms-xpsdocument, application/x-ms-xbap, application/x-ms-application, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, / HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:en-us HTTP_COOKIE:__utma=214372547.2811713850984207000.1245943414.1266945262.1267118577.54; __utmz=214372547.1265739287.47.13.utmcsr=comchannel.epd.org\|utmccn=(referral)\|utmcmd=referral\|utmcct=/home.asp; pcfront%5FvisitedPrds=%2A10%2A3%2A1%2A; SavedCartGUID=FF79F9AB%2DE389%2D4EE9%2D9401%2D5758E2B57207; ASPSESSIONIDQATDACRA=OFLBEKICMPNDKOHDCEAGDCND HTTP_HOST:www.XXX.XXX HTTP_REFERER:https://xxx.xxx.xxx/store/pc/gweMoney.asp HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6.4; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; MS-RTC LM 8; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC EA 2) HTTP_UA_CPU:x86 ***************************** ------------------------------------------------------

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 09-March-2010 at 9:04pm
	We are not aware of any issues with Gift Certificates. If you are using a custom Gift Certificate code generator, make sure that the script is running properly. If you still believe that there might be an issue in ProductCart, please open a support ticket.
	The ProductCart Team Home of ProductCart shopping cart software

Pbutler504 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 09-July-2014 Status: Offline Points: 1	Post Options Post Reply Quote Pbutler504 Report Post Thanks(0) Quote Reply Posted: 09-July-2014 at 10:32am
	I'm getting the exact same error when trying to place a test order for a Gift Certificate. Did you ever figure out what was wrong?