Paypal payment failed to be inserted...

[tungsten2k]

Shawn,

To answer your questions, no there was no error following the transaction ID in the insertion failure email. The full source of the
email is further down. "paypal.txt" is in the Filelmaker Pro Unlimited "Web" folder along with the "paypal.php" and the IIS virtual
directory setup for it to function correctly. Will any of the following info help ?:


below is the exact contents of the unaltered <FMPUnlimited>/Web/paypal.txt file:
<===================begin paypal.txt======================>
[FMP-Field: gText Temp 1]
<===================end paypal.txt======================>



below are the exact fields from the "settings" section of the <FMPUnlimited>/Web/paypal.php file (paypal_key blanked)

<===================begin paypal.php======================>
$paypal_key = "1234567890xxx"; // *** CHANGE THIS!!! *** This should match what you have set under Maintenance &
Preferences -> General Preferences -> Billing
$paypal_email = "paypal@5angle.com"; // This should be your PayPal email address (used for verification purposes)
$email_success = TRUE; // Do you want to email the above address when it was inserted into Optigold successfully?
$email_failure = TRUE; // Do you want to email the above address when the transaction failed to be inserted into Optigold?
$optigold_url = "http://eagle.5angle.com"; // Your machine running FileMaker Unlimited or WSC (no trailing slash needed).
<===================end paypal.php======================>

Maintenance & Preferences -> General Preferences -> Billing has the same value for "paypal_key" as in paypal.php


below is the exact full source of the message (last 7 digits of the transaction id blanked):
<===================begin failure email source======================>
Return-Path: <paypal@5angle.com>
Received: from sonar.5angle.com (root@localhost)
by 5angle.com (8.12.10/8.12.10) with ESMTP id i4BLHQZe019632
for <paypal@5angle.com>; Tue, 11 May 2004 14:17:26 -0700
X-ClientAddr: 24.4.173.67
Received: from eagle.5angle.com (eagle.5angle.com [24.4.173.67])
by sonar.5angle.com (8.12.10/8.12.10) with ESMTP id i4BLHPYM019623
for <paypal@5angle.com>; Tue, 11 May 2004 14:17:25 -0700
Message-Id: <200405112117.i4BLHPYM019623@sonar.5angle.com>
Received: from eagle (eagle.5angle.com [10.111.0.10])
by 5angle.com (sonar) with SMTP
id <2004051121175501100kaa5je>; Tue, 11 May 2004 21:17:56 +0000
Date: Tue, 11 May 2004 14:18:53 -0800
From: paypal@5angle.com
Subject: PayPal Transaction Failed
To: paypal@5angle.com
X-FiveAngle-MailScanner-Information: Please contact the ISP for more information
X-FiveAngle-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details
X-Spam-Status: No, hits=2.0 required=5.0
tests=MSG_ID_ADDED_BY_MTA_2,NO_REAL_NAME
version=2.55
X-Spam-Level: **
X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp)

A PayPal payment failed to be inserted into Optigold.

From: paypal@5angle.com
Amount: 105.00
Transaction ID: 0123456789xxxxxxx
<===================end failure email source======================>




I am at a complete loss.

-=dave

--
Dave Johnson - dave.johnson@5angle.com - 415.640.2551 - http://5angle.com
FiveAngle - We've got your business communication needs covered at every angle.


----- Original Message -----
From: "Shawn Hogan" <shawn@digitalpoint.com>
To: "Optigold ISP List" <isp-list@optigold.com>
Sent: Friday, May 14, 2004 12:26 PM
Subject: Re: [Optigold ISP] payment failed to be inserted...


> dave johnson wrote:
>
> > I have exhausted every possible scenario but customer paypal payments are
> > never inserted correctly and the very terse error message (forwarded below -
> > transaction id removed) lends no help in determining why.
> >
> > Is there a reason all questions concerning Paypal payment support are shunned
> > ?
> >
> > I've implemented the script, I have set the correct token pass in filemaker
> > and the php script, the paypal transaction IS hitting the script, i have sent
> > paypal payments from the email address corresponding to the "login" for a
> > fictious optigold customer account (which is the only key-off id i can assume
> > since there is no documentation or instructions for this) and nothing has
> > worked.
> >
> > i continue to manually process paypal transactions.
> >
> > so what's the trick ? i have sent 3 previous requests for more information on
> > this that have gone unanswered. if support for Paypal payment processing is
> > not finished, please just say so.
>
> Is that the compete email notification you received? After the Transaction
> ID, it should show what the error actually was. Also, make sure the
> paypal.txt is installed in your Web folder on the machine running Unlimited
> and that it was not altered.
>
> - Shawn
>
> ----------------------------------
> Shawn D. Hogan
> President, Digital Point Solutions
> http://www.digitalpoint.com
> (858) 452-3696

[digitalpoint]

Does your PHP configuration allow URLs in fopen() (http://www.php.net/manual/en/ref.filesystem.php#ini.allow-url-fopen)? If you aren't sure, make a php script with the function phpinfo() and run it, it should tell you there.

At this point, that's the only thing I can think of.

[daemeh]

My suggestion is try something other than paypal. There are hundreds maybe thousands of bad reviews out there, enough to scare the living hell out of me. When I hear about paypal the words "touch" and "bargepole" instantly come to mind. Just a warning.

[tungsten2k]

My suggestion is try something other than paypal.would you also suggest not accepting American Express as well ? how about personal check ? i'll just tell these very internet-centric customers (mostly DJs, designers, and performers) to just pay by some other means or go somewhere else huh ? guess what... i *am* the "somewhere else".

I was looking for solutions, not suggestions.

Thanks anyway.

ps- problem remains unsolved and paypal transactions result in failed insertion notification emails... shawn, could it be that Optigold is blindly assuming that the FMPU web interface is on port 80 ? (I didn't update the post above, but I tried originally putting "http://eagle.5angle.com:<port number>" in for FMPU server and got the same result.)

[digitalpoint]

That should be fine (any port).

Did you check if your version of PHP supports fopen()?

[tungsten2k]

Did you check if your version of PHP supports fopen()?that was the first thing i checked... and i even tested it by creating a test php script to verify. i will let you know if i ever find out what the hiccup is.