Hi there. I have tried and tried every method I have seen on this site and on the web but still I have no luck with this IPN
My test page looks like this;-
Thank you IPN Tester,
Your simulated IPN has been sent successfully
Your status report appears below:
IPN Creation Date: 15:02:49 Apr 17, 2004 PDT
IPN Expiration Date: 00:02:49 Apr 19, 2004 PDT
Send Count: 1
Target IPN Script:
http://www.jeantorry.com/WA_eCart/ipn.cfm
IPN Sent: 15:02:49 Apr 17, 2004 PDT
HTTP Status: HTTP/1.1 500 Internal Server Error
IPN Received: Your script did not reply!
Post Back: N/A
Variables Sent: 57
Variables Expected: 58
Variables Received: 0
String Length Sent: 1327
String Length Expected: 1348
String Length Received: 0
Desired Response: VERIFIED
Actual Response: None
Intentional Response: No!
Summary: Your script is not posting back to us!
>>> Resend Key: kFo2zBgNYK9y <<<
My page looks like this;-
<!-- read post from PayPal system and add 'cmd' -->
<cfset x = GetHttpRequestData()>
<CFSET str="cmd=_notify-validate&" & x.content>
<!-- Use For Testing
<CFHTTP URL="https://www.paypal.com/cgi-bin/webscr?#str#" METHOD="GET" RESOLVEURL="false">
</CFHTTP>
-->
<CFHTTP URL="http://www.eliteweaver.co.uk/cgi-bin/webscr?#str#" METHOD="GET" RESOLVEURL="false">
</CFHTTP>
<!-- check notification validation -->
<CFIF #CFHTTP.FileContent# is "VERIFIED">
<!-- check that payment_status=Completed -->
<cfif FORM.payment_status eq "Completed">
<!-- check that receiver_email is your email address -->
<cfif #FORM.RECEIVER_EMAIL# eq "Orders@jeantorry.com">
<!-- process payment -->
<cftry>
<cfquery name="qInsertOrder" datasource="myDSN">
INSERT INTO Orders(
receiver_email,
item_number,
quantity,
payment_status,
payment_date,
payment_gross,
payment_fee,
txn_id,
txn_type,
payment_type,
payer_id
)
VALUES(
'#FORM.RECEIVER_EMAIL#',
'#FORM.ITEM_NUMBER#',
'#FORM.QUANTITY#',
'#FORM.PAYMENT_STATUS#',
#CreateODBCDateTime(Now())#,
'#FORM.PAYMENT_GROSS#',
'#FORM.PAYMENT_FEE#',
'#FORM.TXN_ID#',
'#FORM.TXN_TYPE#',
'#FORM.PAYMENT_TYPE#',
'#FORM.PAYER_ID#'
)
</cfquery>
<cfcatch>
<!--- let's log all errors --->
<cffile action="append"
file="D:\paypal_logs\paypal_log.txt"
output="Error order info">
</cfcatch>
</cftry>
<cfcatch>
<!--- log any errors when inserting this customer --->
<cffile action="append"
file="D:\paypal_logs\paypal_log.txt"
output="Error inserting customer">
</cfcatch>
</cftry>
<!--- send user an email --->
<cftry>
<cfmail from="Orders@jeantorry.com" to="#FORM.payer_email#" subject="Jean Torry.com.Thank you for your Purchase!">
Thank you for purchasing Maternity clothing from Jean Torry.Com
If you have questions or need help, please go to:
http://www.jeantorry.com
Thanks again for your purchase!
Jeantorry.Com
http://www.jeantorry.com
</cfmail>
<!--- Now send yourself an email alerting that there was a sale done --->
<cfmail from="Orders@jeantorry.com" to="Mark@jeantorry.com" subject="Someone Purchased From The Website!">
An order was placed by: #FORM.first_name#' #FORM.last_name#
Item Purchased:
Item Number: #FORM.ITEM_NUMBER#
Purchase Price: #DOLLARFORMAT(FORM.PAYMENT_GROSS)#
PayPal Fee: #DollarFORMAT(FORM.PAYMENT_FEE)#
==========================
Profit Fee: #DollarFormat(Evaluate("#FORM.PAYMENT_GROSS# - #FORM.PAYMENT_FEE#"))#
A Reminder Email:
http://www.jeantorry.com
</cfmail>
<cfcatch>
<!--- Log Any Errors Sending Emails --->
<cffile action="append"
file="D:\paypal_logs\paypal_log.txt"
output="Error sending email">
</cfcatch>
</cftry>
</cfif>
</cfif>
<CFELSEIF #CFHTTP.FileContent# is "INVALID">
<!-- log for investigation -->
Something that was purchased was invalid, either the order or the information provided. This is usually good to log in case someone is trying to purchase with stolen card numbers, etc. Here simply place a QUERY tag that insert the data above into a database.
<CFELSE>
<!-- error -->
This usually means that something went wrong along the way, you can use this area to log it and keep for your records.
</CFIF>
Can someone plese help me???????????????????????????????????????
Where the hell am I going wrong?
I must be missing something somewhere...In the head I know!
Please, please, please!!
All the best torry
