PayPal intermittent problem

[LissaE]

I am having an intermittent problem with my store, two successful orders just today followed by one that got charged through Paypal but no record in the store at all

I am using Paypal IPN and all other modules that aren't being used are not installed

The first time this happened was right after I installed Simple SEO URL's and uninstalling the Paypal module and re-installing plus activating the PDT Token fixed that

I am at a loss as to why I can have several successful transactions and then one like this out of the blue....and this one just bites, a large sale by my store standards LOL and I have to refund it now with no way of knowing if the customer will bother repurchasing

I have logging switched on so I am going to go through those to find the ones from today....could take me a while LOL there's lots there

[LissaE]

Ok, turns out there's only one log from today at all so I am guessing this is the one, hopefully and hopefully someone can give me some insight, though I am guessing it might have something to do with the '<url> malformed' bit

2008-10-02 12:37:59
-------------------
(MODULE_PAYMENT_PAYPALWPP_SERVER transaction) --> 
Request Headers: 
Array
(
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 45
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - WPP-NVP
    [4] => X-VPS-VIT-Integration-Version: 1.3.8a
)


Request Parameters: {GetTransactionDetails} 
Array
(
    [TRANSACTIONID] => 3T28347692721273V
    [METHOD] => GetTransactionDetails
    [USER] => MODULE_PAYMENT_PAYPALWPP_APIUSERNAME
    [PWD] => ************************************
    [VERSION] => 3.2
    [SIGNATURE] => *********************************TURE
)


Response: 
Array
(
    [] => 
    [CURL_ERRORS] => (3) <url> malformed
)

(3) <url> malformed
Array
(
    [url] => 
    [http_code] => 0
    [header_size] => 0
    [request_size] => 0
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0
    [namelookup_time] => 0
    [connect_time] => 0
    [pretransfer_time] => 0
    [size_upload] => 0
    [size_download] => 0
    [speed_download] => 0
    [speed_upload] => 0
    [download_content_length] => 0
    [upload_content_length] => 0
    [starttransfer_time] => 0
    [redirect_time] => 0
)


GetTransactionDetails, Elapsed: 2ms -- Failed
(3) <url> malformed
Array
(
    [url] => 
    [http_code] => 0
    [header_size] => 0
    [request_size] => 0
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0
    [namelookup_time] => 0
    [connect_time] => 0
    [pretransfer_time] => 0
    [size_upload] => 0
    [size_download] => 0
    [speed_download] => 0
    [speed_upload] => 0
    [download_content_length] => 0
    [upload_content_length] => 0
    [starttransfer_time] => 0
    [redirect_time] => 0
)

Even though I have had many successful transactions and these instances are the rarity, could it still be the SEO URL's mod making it wonky?

[DrByte]

I am using Paypal IPN and all other modules that aren't being used are not installed

Um ... the log you posted is an Express Checkout log, not a PayPal IPN (website payments standard) log.

So ... which module are you really using?

[DrByte]

(MODULE_PAYMENT_PAYPALWPP_SERVER transaction)

The value for MODULE_PAYMENT_PAYPALWPP_SERVER is automatically set inside the PayPal Express Checkout payment module, but only when the module is properly installed. The proper way to "set" it is to simply "Install" the module.

It seems like you've somehow partially removed or only partially installed the Express Checkout module (or have manually deleted records from the configuration table for some reason), and when people are trying to use it, they're getting problems because of that.

[LissaE]

I am *really* using Paypal IPN, I had Express Checkout installed a long time ago but uninstalled it...if it didn't uninstall properly, how do I go about fixing that?

Edit to add - the reason I removed Express and started using IPN is that every so often Paypal kept returning ppl to the confirmation page to click the continue button instead of to the checkout success page and it was creating confusion in my customers thinking they were paying twice

[DrByte]

Ok, turns out there's only one log from today at all...

2008-10-02 12:37:59
-------------------
(MODULE_PAYMENT_PAYPALWPP_SERVER transaction) -->

I probably should have looked more closely too. 2008-10-02 isn't from today. That's a month old.

[LissaE]

Hmm, I didn't see that there LOL FTP said it was created not long before I posted it, still it has been months since I used Express, that one is probably the error log from when I first installed the seo mod

Off to download and open up each log to find the *real* culprit *sighs* LOL

[LissaE]

Ok, I have been going through my logs backwards and I have LOTS of these, way more than I had the actual payment errors

Nov 01 2008 2:07 -- IPN PROCESSING INITIATED. 
*** Originating IP: 66.211.170.66  notify.paypal.com

Nov 01 2008 2:07 -- IPN FATAL ERROR :: Could not find stored session in DB, cannot re-create session as PayPal IPN transaction.

Nov 01 2008 2:07 -- IPN FATAL ERROR :: No saved IPN session data available. Must be an Express Checkout or Direct Pay transaction.

Any ideas on how I fix this? Because I *don't* have Express Checkout installed, nor does it show as any of the options during the checkout process, I did re-arrange my login page a while back though, I wonder if maybe I mucked something up that doesn't show 'visibly'?

This is the code of my tpl_login_default.php just incase I did muck something up lol

<?php
/**
 * Page Template
 *
 * @package templateSystem
 * @copyright Copyright 2003-2007 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: tpl_login_default.php 5926 2007-02-28 18:15:39Z drbyte $
 */
?>
<div class="centerColumn" id="loginDefault">

<h1 id="loginDefaultHeading"><?php echo HEADING_TITLE; ?></h1>

<?php if ($messageStack->size('login') > 0) echo $messageStack->output('login'); ?>
<table algn="center" width="100%" cellpadding="5">
<tr>
<td valign="top" width="60%">

<?php if ( USE_SPLIT_LOGIN_MODE == 'True' || $ec_button_enabled) { ?>

<!--BOF PPEC split login- DO NOT REMOVE--><fieldset class="loginFieldsetLeft"><legend><?php echo HEADING_NEW_CUSTOMER_SPLIT; ?></legend>
<?php if ($_SESSION['cart']->count_contents() > 0) { ?>
<div><?php echo TEXT_NEW_CUSTOMER_INTRODUCTION_SPLIT_NO_CART; ?></div>
<?php } else { ?>
<div><?php echo TEXT_NEW_CUSTOMER_INTRODUCTION_SPLIT; ?></div>
<?php } ?>

<?php echo zen_draw_form('create_account', zen_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'), 'post', 'onsubmit="return check_form(create_account);"') . zen_draw_hidden_field('action', 'process') . zen_draw_hidden_field('email_pref_html', 'email_format'); ?>

<?php require($template->get_template_dir('tpl_modules_create_account.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_create_account.php'); ?>

<div class="buttonRow forward"><?php echo zen_image_submit(BUTTON_IMAGE_CONTINUE, BUTTON_CONTINUE_ALT); ?></div>
</form>

</form></fieldset>
<!-- end columnLeft -->
</td>
<td valign="top" width="40%">



<fieldset class="loginFieldsetRight">
<legend><?php echo HEADING_RETURNING_CUSTOMER_SPLIT; ?></legend>
<div><?php echo TEXT_RETURNING_CUSTOMER_SPLIT; ?></div><br />
<?php echo zen_draw_form('login', zen_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?>
<label class="inputLabelLogin" for="login-email-address"><?php echo ENTRY_EMAIL_ADDRESS; ?></label>
<?php echo zen_draw_input_field('email_address', '', 'size="28" id="login-email-address"'); ?>
<br class="clearBoth" />
<label class="inputLabelLogin" for="login-password"><?php echo ENTRY_PASSWORD; ?></label>
<?php echo zen_draw_password_field('password', '', 'size="28"', 'id="login-password"'); ?>
<?php 
    if (PROJECT_VERSION_MAJOR == '1' && substr(PROJECT_VERSION_MINOR, 0, 3) == '3.8') { 
        echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); 
    }
?>    
<div class="buttonRow forward"><?php echo zen_image_submit(BUTTON_IMAGE_CONTINUE, BUTTON_CONTINUE_ALT); ?></div>
<br class="clearBoth"/>
<div class="buttonRow back important"><?php echo '<a href="' . zen_href_link(FILENAME_PASSWORD_FORGOTTEN, '', 'SSL') . '">' . TEXT_PASSWORD_FORGOTTEN . '</a>'; ?></div>

</fieldset>
</form>
<br class="clearBoth"/>

<!-- BOF PAYPAL -->
<?php // ** BEGIN PAYPAL EXPRESS CHECKOUT ** 
?>
<?php if ($ec_button_enabled) { ?>
<fieldset class="loginFieldsetRight">
<legend><?php echo HEADING_PAYPAL; ?></legend>
<br class="clearBoth"/>
<div class="information"><?php echo TEXT_PAYPAL_INTRODUCTION_SPLIT; ?></div>
<br class="clearBoth"/>
<div class="center"><?php require(DIR_FS_CATALOG . DIR_WS_MODULES . 'payment/paypal/tpl_ec_button.php'); ?></div>
</fieldset>
<br class="clearBoth"/>
<?php } ?>

<?php // ** END PAYPAL EXPRESS CHECKOUT ** 
?>
<!-- EOF PAYPAL -->


    <fieldset class="loginFieldsetRight">
        <legend><?php echo HEADING_CONFIDENCE; ?></legend>
<br />
<!-- GeoTrust QuickSSL [tm] Smart Icon tag. Do not edit. -->
<script language="javascript" type="text/javascript" src="//smarticon.geotrust.com/si.js"></script>
<!-- end GeoTrust Smart Icon tag -->&nbsp;<a href="http://www.paypal.com"><img src="images/PayPal.jpg" border="0" alt="" /></a><br /><br />
This site uses a 128 bit encrypted SSL Certificate from GeoTrust to increase the security of our customer’s information.<br /><br />
<strong><a href="http://www.havendesignz.com/store/index.php?main_page=privacy">View our complete Privacy Policy here.</a></strong><br /><br />
PayPal is the safer, easier way to pay and get paid online. The service allows you to pay in any way you prefer, including through credit cards, bank accounts, buyer credit or account balances, without sharing financial information. Haven Designz DigiScraps is Paypal Verified for your extra security.<br /><br />
You can now make payments via Direct Bank Deposit, choose your selection at checkout.<br /><br />
<strong><a href="http://www.havendesignz.com/store/index.php?main_page=contact_us">Questions? Contact us here.</a></strong><br />
    </fieldset>


 <!-- end columnRight -->
 
 </td>
 </tr>
 </table>
<!--EOF PPEC split login- DO NOT REMOVE-->


<?php } else { ?>
<!--BOF normal login-->
<?php
  if ($_SESSION['cart']->count_contents() > 0) {
?>
<div class="advisory"><?php echo TEXT_VISITORS_CART; ?></div>
<?php
  }
?>
<?php echo zen_draw_form('login', zen_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?>
<fieldset>
<legend><?php echo HEADING_RETURNING_CUSTOMER; ?></legend>

<label class="inputLabel" for="login-email-address"><?php echo ENTRY_EMAIL_ADDRESS; ?></label>
<?php echo zen_draw_input_field('email_address', '', zen_set_field_length(TABLE_CUSTOMERS, 'customers_email_address', '40') . ' id="login-email-address"'); ?>
<br class="clearBoth" />

<label class="inputLabel" for="login-password"><?php echo ENTRY_PASSWORD; ?></label>
<?php echo zen_draw_password_field('password', '', zen_set_field_length(TABLE_CUSTOMERS, 'customers_password') . ' id="login-password"'); ?>
<br class="clearBoth" />
<?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?>
</fieldset>

<div class="buttonRow forward"><?php echo zen_image_submit(BUTTON_IMAGE_CONTINUE, BUTTON_CONTINUE_ALT); ?></div>
<div class="buttonRow back important"><?php echo '<a href="' . zen_href_link(FILENAME_PASSWORD_FORGOTTEN, '', 'SSL') . '">' . TEXT_PASSWORD_FORGOTTEN . '</a>'; ?></div>
</form>
<br class="clearBoth" />

<?php echo zen_draw_form('create_account', zen_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'), 'post', 'onsubmit="return check_form(create_account);"') . zen_draw_hidden_field('action', 'process') . zen_draw_hidden_field('email_pref_html', 'email_format'); ?>
<fieldset>
<legend><?php echo HEADING_NEW_CUSTOMER; ?></legend>

<div class="information"><?php echo TEXT_NEW_CUSTOMER_INTRODUCTION; ?></div>

<?php require($template->get_template_dir('tpl_modules_create_account.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_create_account.php'); ?>

</fieldset>

<div class="buttonRow forward"><?php echo zen_image_submit(BUTTON_IMAGE_CONTINUE, BUTTON_CONTINUE_ALT); ?></div>
</form>
<!--EOF normal login-->
<?php } ?>
</div>
<br class="clearBoth" />
<br class="clearBoth" />
<!--bof- site copyright display -->
<div id="siteinfoLegal" class="legalCopyright"><?php echo FOOTER_TEXT_BODY; ?></div>
<!--eof- site copyright display -->

[LissaE]

I have aquestion, and I think this might be related to my problem lol

Paypal IPN settings say that allow_url_fopen must be enabled, but my PHP Info says it is off....I think I can use the .htaccess to enable it but what are the security ramifications for doing that? ANd is it most likely to fix the intermittent problem I have?

[DrByte]

The "allow_url_fopen" requirement is incorrect. It's actually not required. That message will be removed in the next version.