Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,315
    Plugin Contributions
    9

    Default problem with ipn_main_handler...

    i recently got the following log. it seems that we are not cleansing the data coming back from paypal? (i rarely use or support it.)

    it seems that \xa0 is actually non-breaking space in Latin1 (ISO 8859-1).

    is this a paypal setting that i have wrong? or do we need to make a coding change?

    log (some elements changed to protect the innocent):

    Code:
    [06-Jul-2022 07:54:06] Request URI: /ipn_main_handler.php, IP address: 173.0.81.65
    #1  trigger_error() called at [/myHome/includes/classes/db/mysql/query_factory.php:171]
    #2  queryFactory->show_error() called at [/myHome/includes/classes/db/mysql/query_factory.php:143]
    #3  queryFactory->set_error() called at [/myHome/includes/classes/db/mysql/query_factory.php:270]
    #4  queryFactory->Execute() called at [/myHome/includes/functions/database.php:44]
    #5  zen_db_perform() called at [/myHome/ipn_main_handler.php:419]
    --> PHP Fatal error: 1366:Incorrect string value: '\xA0east ...' for column `mydatabase`.`paypal`.`address_state` at row 1 :: INSERT INTO paypal 
    (order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, invoice, mc_currency, first_name, 
    last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, 
    payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, parent_txn_id, num_cart_items, mc_gross, mc_fee, 
    settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo) VALUES ('236947', 'parent', 'paypal (ipn-handler)', 'IPN', 
    'refund', 'instant', 'Refunded', '', '2588-1622644268-[mystore]', 'USD', 'kristen', 'smith', '', 'kris smith', '555 somewhere Drive', 'Eastbourne', '<A0>east 
    sussex', 'BN208AR', 'United Kingdom', '', 'myemail######################', '8WQ3AK9PLLZK8', '', '2022-07-06 04:53:59', 
    'myemail######################', 'myemail######################', '5AEL7BMZHK86N', '68422392U6908592X', 
    '5E876138AL509150Y', '1', '-149.40', '0.00', '0', '', '1', '3.9', 'ATKG0W3.Sgjo.GzJn2YUDDvu5565Loi8lHe0SofBB2XQf7M02Hhp', now(), '{Record generated 
    by IPN} [ProtectionEligibility:Eligible]') ==> 
    (as called by) /myHome/includes/functions/database.php on line 44 <== in /myHome/includes/classes/db/mysql/query_factory.php on line 171.
    WCAG is here.
    cake is nice...(venmo) called the savior by the chief bottle washer...
    mxWorks on paypal

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,646
    Plugin Contributions
    117

    Default Re: problem with ipn_main_handler...

    I wonder if we need to sanitize the data that comes back from PayPal. Guilty until proven innocent!
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,315
    Plugin Contributions
    9

    Default Re: problem with ipn_main_handler...

    Quote Originally Posted by swguy View Post
    I wonder if we need to sanitize the data that comes back from PayPal. Guilty until proven innocent!
    clearly in this example, it is warranted...
    WCAG is here.
    cake is nice...(venmo) called the savior by the chief bottle washer...
    mxWorks on paypal

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,646
    Plugin Contributions
    117

    Default Re: problem with ipn_main_handler...

    I reckon so. Please PR.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. v151 Sorry I'm also getting a blank screen with- ipn_main_handler.php?type=ec
    By KrisFoxton in forum Built-in Shipping and Payment Modules
    Replies: 7
    Last Post: 18 Sep 2013, 11:09 AM
  2. Help with paypal express: ipn_main_handler.php
    By shessorandom in forum PayPal Express Checkout support
    Replies: 14
    Last Post: 16 Jun 2012, 07:27 AM
  3. ipn_main_handler.php
    By kgovett in forum PayPal Express Checkout support
    Replies: 2
    Last Post: 30 Sep 2009, 08:52 PM
  4. ipn_main_handler.php
    By mediathing in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 11 Sep 2006, 09:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR