Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2005
    Posts
    41
    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,115
    Plugin Contributions
    9

    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.
    help with WCAG is now here! PM if you want some help with this. (or any ZC issue).
    if you feel so inclined, feel free to send some cake....

  3. #3
    Join Date
    Mar 2005
    Posts
    41
    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,115
    Plugin Contributions
    9

    Default Re: chargeback_reimbursement error log

    help with WCAG is now here! PM if you want some help with this. (or any ZC issue).
    if you feel so inclined, feel free to send some cake....

  5. #5
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,827
    Plugin Contributions
    80

    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