Results 1 to 5 of 5

Hybrid View

  1. #1
    Join Date
    Mar 2005
    Posts
    58
    Plugin Contributions
    0

    Default chargeback_reimbursement error log

    ZC 1.5.7C usinga slightly modified Responsive Classic template
    PHP Version: 7.3.32 (Zend: 3.3.32)
    MySQL 5.7.30
    EO
    OPC
    Google Captcha
    Mailchimp Integration

    I started receiving this error a few days ago when I won a charge back dispute through Paypal for an order that was paid by CC manually and is not associated with an order through ZenCart. Any ideas on how to stop the IPN callback or a pointer to a configuration change to keep errors like this from occuring would be greatly appreciated.

    Code:
    [28-Nov-2021 09:47:05 America/New_York] Request URI: /ipn_main_handler.php, IP address: 173.0.81.65
    #1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:170]
    #2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:142]
    #3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:269]
    #4 queryFactory->Execute() called at [/includes/functions/database.php:44]
    #5 zen_db_perform() called at [/ipn_main_handler.php:419]
    --> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'mc_fee' 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 ('20744', 'parent', 'paypal (ipn-handler)', 'IPN', 'chargeback_reimbursement', '', 'Completed', '', '3165-1628894647-[Mystore]', 'USD', '', '', '', '', '', '', '', '', '', '', '[email protected]', 'Z6PFML62KA2D4', 'verified', '2021-11-26 09:09:56', '', '', '', '49L67964SW698244C', '8C060304EJ230962J', '1', '225.85', '', '0', '', '1', '3.9', 'AtUbgugC4KybUOS9Xzrs4wqyfk7uAUAqom0B9gFibfjxN5omDN9aT-O-', now(), '{Record generated by IPN}') ==> (as called by) /includes/functions/database.php on line 44 <== in /includes/classes/db/mysql/query_factory.php on line 170.

  2. #2
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,669
    Plugin Contributions
    11

    Default Re: chargeback_reimbursement error log

    you could try changing line 305 of /ipn_main_handler.php

    PHP Code:
    //from
    'mc_fee' => $_POST['mc_fee'],
    //to
    'mc_fee' => ($_POST['mc_fee'] ?? 0), 
    this solution will only work because you are running > php 7.0.

    the problem can also be solved by taking mysql out of strict mode.

    best.
    author of square Webpay.
    mxWorks has premium plugins. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  3. #3
    Join Date
    Mar 2005
    Posts
    58
    Plugin Contributions
    0

    Default Re: chargeback_reimbursement error log

    Thanks, we chose to disable strict mode on our web server.

  4. #4
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,669
    Plugin Contributions
    11

    Default Re: chargeback_reimbursement error log

    author of square Webpay.
    mxWorks has premium plugins. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  5. #5
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: chargeback_reimbursement error log

    Zen Cart GitHub issue opened: https://github.com/zencart/zencart/issues/4493

 

 

Similar Threads

  1. v151 paypal error log and mutilple error email help please
    By tropical in forum PayPal Express Checkout support
    Replies: 3
    Last Post: 27 May 2020, 03:36 PM
  2. Replies: 5
    Last Post: 15 Mar 2017, 03:52 AM
  3. Site down, getting error in debug error log
    By rcrosier in forum General Questions
    Replies: 3
    Last Post: 25 Mar 2009, 03:01 PM
  4. Replies: 6
    Last Post: 7 Dec 2007, 03:42 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