Forum

Thread tagged as: Problem, PayPal, Shop

Shop Live Transactions not working

Hi,

I've been using Runway and the Perch shop for a number of months. After quite a sticky, trial and error start, everything in the payment process was working fine.

After resolving an issue with emails not sending (seperate issue), the site works fine in 'test' mode, but now, no longer works in 'live' mode. No files have changed, so as you can imagine, I'm at a complete loss.

I have implemented the Perch Debug and PerchUtil::hold_redirects(); and return the following:

Debug Message - Perch Runway 3.0.14
[76] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /shop/result, so not using routes.
Using master page: /templates/pages/shop/result.php
[51] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_members_sessions WHERE sessionID='322d39b9f35f50ab5ae54ad9b40fc0137e8c8a8e' AND sessionHttpFootprint='3f239b444d969ba5808346558df6aaa381b3cdd8' AND sessionExpires>'2018-02-18 19:56:34' LIMIT 1
User is logged in
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/result' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=148828
[1] SELECT * FROM perch3_shop_cart WHERE cartID=148828
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2018-02-18 19:56:00' AND saleTo>'2018-02-18 19:56:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[35] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/result' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-013-004', '000-013', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/level1.html
[4] Using template: /templates/navigation/level2.html
[7] Using template: /templates/navigation/level2.html
[5] Using template: /templates/navigation/level2.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Header Call to Action' AND (regionPage LIKE '%' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=25 AND idx.itemRev=10)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[3] Using template: /templates/content/home-call-to-action.html
Runtime complete_payment for paypal-express
[1] SELECT * FROM perch3_shop_orders WHERE orderGatewayRef='EC-8AJ41656PF340853D' AND orderDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID='47' LIMIT 1
Payment failed

Omnipay\PayPal\Message\Response Object
(
    [request:protected] => Omnipay\PayPal\Message\ExpressCompletePurchaseRequest Object
        (
            [liveEndpoint:protected] => https://api-3t.paypal.com/nvp
            [testEndpoint:protected] => https://api-3t.sandbox.paypal.com/nvp
            [parameters:protected] => Symfony\Component\HttpFoundation\ParameterBag Object
                (
                    [parameters:protected] => Array
                        (
                            [username] => anticoagulationuk_api1.gmail.com
                            [password] => AVBH97QXTMHJH8UR
                            [signature] => AiPC9BjkCyDFQXbSkoZcgqH3hpacAlL4NSTSnhim10SON35lmtQ2Rr.U
                            [testMode] => 
                            [solutionType] => Sole
                            [landingPage] => Billing
                            [brandName] => 
                            [headerImageUrl] => 
                            [logoImageUrl] => 
                            [borderColor] => 
                            [token] => EC-8AJ41656PF340853D
                            [payerID] => USPCSNJ93CVW2
                            [amount] => 10.00
                            [currency] => GBP
                            [transactionReference] => 166
                        )

                )

            [httpClient:protected] => Guzzle\Http\Client Object
                (
                    [defaultHeaders:protected] => Guzzle\Common\Collection Object
                        (
                            [data:protected] => Array
                                (
                                )

                        )

                    [userAgent:protected] => Guzzle/3.9.3 curl/7.57.0 PHP/5.6.33
                    [config:Guzzle\Http\Client:private] => Guzzle\Common\Collection Object
                        (
                            [data:protected] => Array
                                (
                                    [curl.options] => Array
                                        (
                                            [78] => 60
                                            [10065] => /home/auk/public_html/admin/addons/apps/perch_shop/lib/vendor/guzzle/guzzle/src/Guzzle/Http/Resources/cacert.pem
                                            [64] => 1
                                            [81] => 2
                                        )

                                )

                        )

                    [baseUrl:Guzzle\Http\Client:private] => 
                    [curlMulti:Guzzle\Http\Client:private] => Guzzle\Http\Curl\CurlMultiProxy Object
                        (
                            [handles:protected] => Array
                                (
                                    [0] => Guzzle\Http\Curl\CurlMulti Object
                                        (
                                            [multiHandle:protected] => Resource id #184
                                            [requests:protected] => Array
                                                (
                                                )

                                            [handles:protected] => SplObjectStorage Object
                                                (
                                                    [storage:SplObjectStorage:private] => Array
                                                        (
                                                        )

                                                )

                                            [resourceHash:protected] => Array
                                                (
                                                )

                                            [exceptions:protected] => Array
                                                (
                                                )

                                            [successful:protected] => Array
                                                (
                                                )

                                            [multiErrors:protected] => Array
                                                (
                                                    [1] => Array
                                                        (
                                                            [0] => CURLM_BAD_HANDLE
                                                            [1] => The passed-in handle is not a valid CURLM handle.
                                                        )

                                                    [2] => Array
                                                        (
                                                            [0] => CURLM_BAD_EASY_HANDLE
                                                            [1] => An easy handle was not good/valid. It could mean that it isn't an easy handle at all, or possibly that the handle already is in used by this or another multi handle.
                                                        )

                                                    [3] => Array
                                                        (
                                                            [0] => CURLM_OUT_OF_MEMORY
                                                            [1] => You are doomed.
                                                        )

                                                    [4] => Array
                                                        (
                                                            [0] => CURLM_INTERNAL_ERROR
                                                            [1] => This can only be returned if libcurl bugs. Please report it to us!
                                                        )

                                                )

                                            [selectTimeout:protected] => 1
                                            [eventDispatcher:protected] => Symfony\Component\EventDispatcher\EventDispatcher Object
                                                (
                                                    [listeners:Symfony\Component\EventDispatcher\EventDispatcher:private] => Array
                                                        (
                                                        )

                                                    [sorted:Symfony\Component\EventDispatcher\EventDispatcher:private] => Array
                                                        (
                                                        )

                                                )

                                        )

                                )

                            [groups:protected] => Array
                                (
                                )

                            [queued:protected] => Array
                                (
                                )

                            [maxHandles:protected] => 3
                            [selectTimeout:protected] => 1
                            [eventDispatcher:protected] => Symfony\Component\EventDispatcher\EventDispatcher Object
                                (
                                    [listeners:Symfony\Component\EventDispatcher\EventDispatcher:private] => Array
                                        (
                                        )

                                    [sorted:Symfony\Component\EventDispatcher\EventDispatcher:private] => Array
                                        (
                                        )

                                )

                        )

                    [uriTemplate:Guzzle\Http\Client:private] => Guzzle\Parser\UriTemplate\UriTemplate Object
                        (
                            [template:Guzzle\Parser\UriTemplate\UriTemplate:private] => 
                            [variables:Guzzle\Parser\UriTemplate\UriTemplate:private] => 
                            [regex:Guzzle\Parser\UriTemplate\UriTemplate:private] => /\{([^\}]+)\}/
                        )

                    [requestFactory:protected] => Guzzle\Http\Message\RequestFactory Object
                        (
                            [methods:protected] => Array
                                (
                                    [getInstance] => 0
                                    [__construct] => 1
                                    [fromMessage] => 2
                                    [fromParts] => 3
                                    [create] => 4
                                    [cloneRequestWithMethod] => 5
                                    [applyOptions] => 6
                                    [visit_headers] => 7
                                    [visit_body] => 8
                                    [visit_allow_redirects] => 9
                                    [visit_auth] => 10
                                    [visit_query] => 11
                                    [visit_cookies] => 12
                                    [visit_events] => 13
                                    [visit_plugins] => 14
                                    [visit_exceptions] => 15
                                    [visit_save_to] => 16
                                    [visit_params] => 17
                                    [visit_timeout] => 18
                                    [visit_connect_timeout] => 19
                                    [visit_debug] => 20
                                    [visit_verify] => 21
                                    [visit_proxy] => 22
                                    [visit_cert] => 23
                                    [visit_ssl_key] => 24
                                )

                            [requestClass:protected] => Guzzle\Http\Message\Request
                            [entityEnclosingRequestClass:protected] => Guzzle\Http\Message\EntityEnclosingRequest
                        )

                    [eventDispatcher:protected] => Symfony\Component\EventDispatcher\EventDispatcher Object
                        (
                            [listeners:Symfony\Component\EventDispatcher\EventDispatcher:private] => Array
                                (
                                    [request.sent] => Array
                                        (
                                            [100] => Array
                                                (
                                                    [0] => Array
                                                        (
                                                            [0] => Guzzle\Http\RedirectPlugin Object
                                                                (
                                                                    [defaultMaxRedirects:protected] => 5
                                                                )

                                                            [1] => onRequestSent
                                                        )

                                                )

                                        )

                                    [request.clone] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => Array
                                                        (
                                                            [0] => Guzzle\Http\RedirectPlugin Object
                                                                (
                                                                    [defaultMaxRedirects:protected] => 5
                                                                )

                                                            [1] => cleanupRequest
                                                        )

                                                )

                                        )

                                    [request.before_send] => Array
                                        (
                                            [0] => Array
                                                (
                                                    [0] => Array
                                                        (
                                                            [0] => Guzzle\Http\RedirectPlugin Object
                                                                (
                                                                    [defaultMaxRedirects:protected] => 5
                                                                )

                                                            [1] => cleanupRequest
                                                        )

                                                )

                                        )

                                )

                            [sorted:Symfony\Component\EventDispatcher\EventDispatcher:private] => Array
                                (
                                )

                        )

                )

            [httpRequest:protected] => Symfony\Component\HttpFoundation\Request Object
                (
                    [attributes] => Symfony\Component\HttpFoundation\ParameterBag Object
                        (
                            [parameters:protected] => Array
                                (
                                )

                        )

                    [request] => Symfony\Component\HttpFoundation\ParameterBag Object
                        (
                            [parameters:protected] => Array
                                (
                                )

                        )

                    [query] => Symfony\Component\HttpFoundation\ParameterBag Object
                        (
                            [parameters:protected] => Array
                                (
                                    [token] => EC-8AJ41656PF340853D
                                    [PayerID] => USPCSNJ93CVW2
                                )

                        )

                    [server] => Symfony\Component\HttpFoundation\ServerBag Object
                        (
                            [parameters:protected] => Array
                                (
                                    [CONTEXT_DOCUMENT_ROOT] => /home/auk/public_html
                                    [CONTEXT_PREFIX] => 
                                    [DOCUMENT_ROOT] => /home/auk/public_html
                                    [GATEWAY_INTERFACE] => CGI/1.1
                                    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                                    [HTTP_ACCEPT_ENCODING] => gzip, deflate
                                    [HTTP_ACCEPT_LANGUAGE] => en-GB,en;q=0.5
                                    [HTTP_CONNECTION] => keep-alive
                                    [HTTP_COOKIE] => __utma=125867229.1337911016.1491228276.1518897316.1518982284.368; __utmz=125867229.1518704487.357.6.utmcsr=auk.kdl|utmccn=(referral)|utmcmd=referral|utmcct=/promotion/fundraising; __atuvc=5%7C6%2C6%7C7; cookieconsent_status=dismiss; cmsa=1; PHPSESSID=5sfoiu1r0irbnf5fsjk6qfvjd2; __utmc=125867229; p_m=322d39b9f35f50ab5ae54ad9b40fc0137e8c8a8e; __utmb=125867229.19.10.1518982284; __utmt=1
                                    [HTTP_HOST] => anticoagulationuk.org
                                    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
                                    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
                                    [PATH] => /bin:/usr/bin
                                    [QUERY_STRING] => token=EC-8AJ41656PF340853D&PayerID=USPCSNJ93CVW2
                                    [REDIRECT_QUERY_STRING] => token=EC-8AJ41656PF340853D&PayerID=USPCSNJ93CVW2
                                    [REDIRECT_SCRIPT_URI] => https://anticoagulationuk.org/shop/result
                                    [REDIRECT_SCRIPT_URL] => /shop/result
                                    [REDIRECT_STATUS] => 200
                                    [REDIRECT_UNIQUE_ID] => WonacklY@aJ6@o4sdP7F1gAAAA8
                                    [REDIRECT_URL] => /shop/result
                                    [REMOTE_ADDR] => 81.103.4.76
                                    [REMOTE_PORT] => 65040
                                    [REQUEST_METHOD] => GET
                                    [REQUEST_SCHEME] => http
                                    [REQUEST_URI] => /shop/result?token=EC-8AJ41656PF340853D&PayerID=USPCSNJ93CVW2
                                    [SCRIPT_FILENAME] => /home/auk/public_html/admin/core/runway/start.php
                                    [SCRIPT_NAME] => /admin/core/runway/start.php
                                    [SCRIPT_URI] => https://anticoagulationuk.org/shop/result
                                    [SCRIPT_URL] => /shop/result
                                    [SERVER_ADDR] => 46.29.91.6
                                    [SERVER_ADMIN] => webmaster@anticoagulationuk.org
                                    [SERVER_NAME] => anticoagulationuk.org
                                    [SERVER_PORT] => 80
                                    [SERVER_PROTOCOL] => HTTP/1.1
                                    [SERVER_SIGNATURE] => 
                                    [SERVER_SOFTWARE] => Apache
                                    [TZ] => Europe/London
                                    [UNIQUE_ID] => WonacklY@aJ6@o4sdP7F1gAAAA8
                                    [PHP_SELF] => /admin/core/runway/start.php
                                    [REQUEST_TIME_FLOAT] => 1518983794.65
                                    [REQUEST_TIME] => 1518983794
                                    [argv] => Array
                                        (
                                            [0] => token=EC-8AJ41656PF340853D&PayerID=USPCSNJ93CVW2
                                        )

                                    [argc] => 1
                                )

                        )

                    [files] => Symfony\Component\HttpFoundation\FileBag Object
                        (
                            [parameters:protected] => Array
                                (
                                )

                        )

                    [cookies] => Symfony\Component\HttpFoundation\ParameterBag Object
                        (
                            [parameters:protected] => Array
                                (
                                    [__utma] => 125867229.1337911016.1491228276.1518897316.1518982284.368
                                    [__utmz] => 125867229.1518704487.357.6.utmcsr=auk.kdl|utmccn=(referral)|utmcmd=referral|utmcct=/promotion/fundraising
                                    [__atuvc] => 5|6,6|7
                                    [cookieconsent_status] => dismiss
                                    [cmsa] => 1
                                    [PHPSESSID] => 5sfoiu1r0irbnf5fsjk6qfvjd2
                                    [__utmc] => 125867229
                                    [p_m] => 322d39b9f35f50ab5ae54ad9b40fc0137e8c8a8e
                                    [__utmb] => 125867229.19.10.1518982284
                                    [__utmt] => 1
                                )

                        )

                    [headers] => Symfony\Component\HttpFoundation\HeaderBag Object
                        (
                            [headers:protected] => Array
                                (
                                    [accept] => Array
                                        (
                                            [0] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                                        )

                                    [accept-encoding] => Array
                                        (
                                            [0] => gzip, deflate
                                        )

                                    [accept-language] => Array
                                        (
                                            [0] => en-GB,en;q=0.5
                                        )

                                    [connection] => Array
                                        (
                                            [0] => keep-alive
                                        )

                                    [cookie] => Array
                                        (
                                            [0] => __utma=125867229.1337911016.1491228276.1518897316.1518982284.368; __utmz=125867229.1518704487.357.6.utmcsr=auk.kdl|utmccn=(referral)|utmcmd=referral|utmcct=/promotion/fundraising; __atuvc=5%7C6%2C6%7C7; cookieconsent_status=dismiss; cmsa=1; PHPSESSID=5sfoiu1r0irbnf5fsjk6qfvjd2; __utmc=125867229; p_m=322d39b9f35f50ab5ae54ad9b40fc0137e8c8a8e; __utmb=125867229.19.10.1518982284; __utmt=1
                                        )

                                    [host] => Array
                                        (
                                            [0] => anticoagulationuk.org
                                        )

                                    [upgrade-insecure-requests] => Array
                                        (
                                            [0] => 1
                                        )

                                    [user-agent] => Array
                                        (
                                            [0] => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
                                        )

                                )

                            [cacheControl:protected] => Array
                                (
                                )

                        )

                    [content:protected] => 
                    [languages:protected] => 
                    [charsets:protected] => 
                    [encodings:protected] => 
                    [acceptableContentTypes:protected] => 
                    [pathInfo:protected] => 
                    [requestUri:protected] => 
                    [baseUrl:protected] => 
                    [basePath:protected] => 
                    [method:protected] => 
                    [format:protected] => 
                    [session:protected] => 
                    [locale:protected] => 
                    [defaultLocale:protected] => en
                )

            [response:protected] => Omnipay\PayPal\Message\Response Object
 *RECURSION*
            [zeroAmountAllowed:protected] => 1
            [negativeAmountAllowed:protected] => 
        )

    [data:protected] => Array
        (
            [TOKEN] => EC-8AJ41656PF340853D
            [SUCCESSPAGEREDIRECTREQUESTED] => false
            [TIMESTAMP] => 2018-02-18T19:56:37Z
            [CORRELATIONID] => f0e8793961baa
            [ACK] => Failure
            [VERSION] => 119.0
            [BUILD] => 43715881
            [L_ERRORCODE0] => 10486
            [L_SHORTMESSAGE0] => This transaction couldn't be completed.
            [L_LONGMESSAGE0] => This transaction couldn't be completed. Please redirect your customer to PayPal.
            [L_SEVERITYCODE0] => Error
        )

)

Setting order status to payment_failed

Here is my Diagnostic file:


Perch Runway: 3.0.14 Production mode: Production (100) Installed apps: content (3.0.14), assets (3.0.14), categories (3.0.14), perch_blog (5.6.1), perch_events (1.9.5), perch_forms (1.9), perch_shop_orders (1.2.5), perch_shop_products (1.2.5), perch_shop (1.2.5), perch_members (1.6.2), perch_twitter (3.7) DB driver: PDO DB tables: perch3_backup_plans (0), perch3_backup_resources (0), perch3_backup_runs (0), perch3_blog_authors (2), perch3_blog_comments (0), perch3_blog_index (1270), perch3_blog_posts (13), perch3_blog_posts_to_tags (7), perch3_blog_sections (1), perch3_blog_tags (5), perch3_blog_webmention_queue (0), perch3_blogs (2), perch3_categories (7), perch3_category_counts (3), perch3_category_sets (3), perch3_collection_index (0), perch3_collection_items (0), perch3_collection_revisions (0), perch3_collections (0), perch3_content_index (672), perch3_content_items (251), perch3_content_locks (0), perch3_content_regions (38), perch3_events (3), perch3_events_categories (1), perch3_events_to_categories (1), perch3_forms (1), perch3_forms_responses (0), perch3_members (25), perch3_members_forms (3), perch3_members_member_tags (15), perch3_members_sessions (9), perch3_members_tags (2), perch3_menu_items (16), perch3_navigation (0), perch3_navigation_pages (0), perch3_page_routes (19), perch3_page_templates (58), perch3_pages (66), perch3_resource_log (1198), perch3_resource_tags (5), perch3_resources (341), perch3_resources_to_tags (8), perch3_scheduled_tasks (50), perch3_settings (52), perch3_shop_addresses (376), perch3_shop_admin_index (36), perch3_shop_brands (1), perch3_shop_cart (148785), perch3_shop_cart_data (418), perch3_shop_cart_items (124), perch3_shop_countries (250), perch3_shop_currencies (152), perch3_shop_customers (180), perch3_shop_emails (1), perch3_shop_index (1690), perch3_shop_option_values (8), perch3_shop_options (3), perch3_shop_order_items (170), perch3_shop_order_promotions (0), perch3_shop_order_statuses (9), perch3_shop_orders (166), perch3_shop_orders_meta (1), perch3_shop_product_files (0), perch3_shop_product_option_values (10), perch3_shop_product_options (2), perch3_shop_product_tags (2), perch3_shop_products (25), perch3_shop_promotions (0), perch3_shop_sales (0), perch3_shop_search (18), perch3_shop_shipping_zone_countries (27), perch3_shop_shipping_zones (3), perch3_shop_shippings (1), perch3_shop_tax_exhibits (393), perch3_shop_tax_group_rates (1), perch3_shop_tax_groups (1), perch3_shop_tax_locations (1), perch3_shop_tax_rates (3), perch3_shop_variants (23), perch3_twitter_scheduled_tweets (0), perch3_twitter_settings (1), perch3_twitter_tweets (616), perch3_user_passwords (1), perch3_user_privileges (85), perch3_user_role_buckets (0), perch3_user_role_privileges (2), perch3_user_roles (2), perch3_users (2) Users: 2 App runtimes: <?php $apps_list = [ 'perch_blog', 'perch_twitter', 'perch_events', 'perch_forms', 'perch_members', 'perch_shop', ]; Scheduled tasks for perch_blog: delete_spam_comments (1440 mins), publish_posts (1 mins), process_webmentions (1 mins) Scheduled tasks for perch_twitter: post_tweets (1 mins), update_tweets (15 mins) Editor plug-ins: _494y5945y45yredactor, redactorcustom H1: 93d6df82900928004e2dea85a5e6ac36 L1: cf1b95b5f699c2ce68d70013e43f0e51 F1: 3b606135b33e6a102526838f4152a807 headerColour: #e6e6e6 content_singlePageEdit: 1 helpURL: siteURL: / hideBranding: 1 content_collapseList: 1 lang: en-gb installedAt: 3.0.1 update_3.0.1: done perch_twitter_update: 3.5 headerScheme: light update_runway_3.0.1: done latest_version: on_sale_version: 3.0.14 dashboard: 0 hide_pwd_reset: 0 siteOffline: 0 content_hideNonEditableRegions: 0 content_frontend_edit: 0 perch_blog_update: 5.6 perch_blog_post_url: /{blogSlug}/{postSlug} perch_blog_site_name: / perch_blog_slug_format: %Y-%m-%d-{postTitle} perch_blog_akismet_key: perch_blog_max_spam_days: 0 perch_blog_comment_notify: 0 update_runway_3.0.2: done perch_events_update: 1.8 perch_events_detail_url: {eventSlug} update_runway_3.0.4: done perch_members_update: 1.4 perch_shop_update: 1.2.5 perch_members_login_page: /members/login.php?r={returnURL} perch_shop_price_tax_mode: exc perch_shop_trade_price_tax_mode: exc perch_shop_product_url: /shop/products/{slug} perch_shop_default_currency: 47 perch_shop_reporting_currency: 47 perch_shop_invoice_number_format: AUK-Invoice%d content_skip_region_list: 0 update_runway_3.0.8: done perch_shop_site_url: keyboardShortcuts: 0 perch_blog_webmention_tx: 0 perch_blog_webmention_rx: 0 update_runway_3.0.10: done update_runway_3.0.9: done assets_restrict_buckets: 0 update_runway_3.0.14: done sidebar_back_link: 0 logoPath: /admin/resources///auk-logo-full-colour-portrait.png PERCH_DEVELOPMENT: 10 PERCH_STAGING: 50 PERCH_PRODUCTION: 100 PERCH_SITEPATH: /home/auk/public_html PERCH_SCHEDULE_SECRET: XWlAambK0VMkr6jl PERCH_DB_USERNAME: auk_DBAdmin PERCH_DB_SERVER: localhost PERCH_DB_DATABASE: auk_DB PERCH_DB_PREFIX: perch3_ PERCH_EMAIL_FROM: contact@kennedydigitalltd.com PERCH_EMAIL_FROM_NAME: Anderw Kennedy PERCH_LOGINPATH: /admin PERCH_PATH: /home/auk/public_html/admin PERCH_CORE: /home/auk/public_html/admin/core PERCH_RESFILEPATH: /home/auk/public_html/admin/resources PERCH_RESPATH: /admin/resources PERCH_HTML5: 1 PERCH_TZ: UTC PERCH_DEFAULT_BUCKET: / PERCH_DEBUG: 1 PERCH_RUNWAY: 1 PERCH_ERROR_MODE: DIE PERCH_DATE_LONG: %d %B %Y PERCH_DATE_SHORT: %d %b %Y PERCH_TIME_SHORT: %H:%M PERCH_TIME_LONG: %H:%M:%S PERCH_RUNWAY_ROUTED: PERCH_STRONG_PASSWORDS: PERCH_ASSET_VERSION: f704e7442d11292c99b5 PERCH_PREVIEW_ARG: preview PERCH_TEMPLATE_PATH: /home/auk/public_html/admin/templates PERCH_TEMPLATE_FILTERS: PERCH_DEFAULT_DOC: index.php PERCH_DEFAULT_EXT: .php PERCH_PRODUCTION_MODE: 100 PERCH_XHTML_MARKUP: PERCH_RWD: 1 PERCH_HTML_ENTITIES: PERCH_SSL: PERCH_STRIPSLASHES: PERCH_PROGRESSIVE_FLUSH: 1 PERCH_PARANOID: PERCH_FORCE_SECURE_COOKIES: PERCH_TRANSLATION_ASSIST: PERCH_PASSWORD_MIN_LENGTH: 6 PERCH_MAX_FAILED_LOGINS: 10 PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR PERCH_VERIFY_UPLOADS: PERCH_PRIV_ASSIST: PERCH_CUSTOM_EDITOR_CONFIGS: PERCH_ENABLE_EXIF: 1 PERCH_AUTH_PLUGIN: PERCH_DB_CHARSET: utf8 PERCH_DB_PORT: PERCH_DB_SOCKET: PERCH_SHOP_VERSION: 1.2.5 PERCH_APPS_EDITOR_PLUGIN: markitup PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown Hosting settings PHP: 5.6.33 Zend: 2.6.0 OS: Linux SAPI: cgi-fcgi Safe mode: not detected MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ MySQL server: 5.6.38 Free disk space: 643.40 GB Extensions: Core, date, ereg, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, cgi-fcgi, bcmath, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, imagick, imap, intl, json, exif, mcrypt, mysqlnd, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, pspell, SimpleXML, soap, sockets, sqlite3, tidy, tokenizer, xml, wddx, xmlreader, xmlrpc, xmlwriter, xsl, zip, mhash, ionCube Loader, Zend Guard Loader, Zend OPcache GD: Yes ImageMagick: Yes PHP max upload size: 12M PHP max form post size: 12M PHP memory limit: 64M Total max uploadable file size: 12M Resource folder writeable: Yes Session timeout: 24 minutes Native JSON: Yes Filter functions: Yes Transliteration functions: Yes CONTEXT_DOCUMENT_ROOT: /home/auk/public_html DOCUMENT_ROOT: /home/auk/public_html GATEWAY_INTERFACE: CGI/1.1 HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_ENCODING: gzip, deflate HTTP_ACCEPT_LANGUAGE: en-GB,en;q=0.5 HTTP_CONNECTION: keep-alive HTTP_COOKIE: __utma=125867229.1337911016.1491228276.1518897316.1518982284.368; __utmz=125867229.1518704487.357.6.utmcsr=auk.kdl|utmccn=(referral)|utmcmd=referral|utmcct=/promotion/fundraising; __atuvc=5%7C6%2C6%7C7; cookieconsent_status=dismiss; cmsa=1; PHPSESSID=5sfoiu1r0irbnf5fsjk6qfvjd2; __utmc=125867229; p_m=322d39b9f35f50ab5ae54ad9b40fc0137e8c8a8e; __utmb=125867229.20.10.1518982284 HTTP_HOST: anticoagulationuk.org HTTP_REFERER: https://anticoagulationuk.org/admin/core/settings/diagnostics/ HTTP_UPGRADE_INSECURE_REQUESTS: 1 HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0 PATH: /bin:/usr/bin QUERY_STRING: extended REDIRECT_STATUS: 200 REMOTE_ADDR: 81.103.4.76 REMOTE_PORT: 49269 REQUEST_METHOD: GET REQUEST_SCHEME: http REQUEST_URI: /admin/core/settings/diagnostics/?extended SCRIPT_FILENAME: /home/auk/public_html/admin/core/settings/diagnostics/index.php SCRIPT_NAME: /admin/core/settings/diagnostics/index.php SCRIPT_URI: https://anticoagulationuk.org/admin/core/settings/diagnostics/ SCRIPT_URL: /admin/core/settings/diagnostics/ SERVER_ADDR: 46.29.91.6 SERVER_ADMIN: webmaster@anticoagulationuk.org SERVER_NAME: anticoagulationuk.org SERVER_PORT: 80 SERVER_PROTOCOL: HTTP/1.1 SERVER_SOFTWARE: Apache TZ: Europe/London UNIQUE_ID: WonfBl2SFgOgI6xfZILp7AAAABw PHP_SELF: /admin/core/settings/diagnostics/index.php REQUEST_TIME_FLOAT: 1518984966.12 REQUEST_TIME: 1518984966 argc: 1

I have a feeling I am looking for a needle in a haystack.

Any ideas ?

I've tested and tested and tried a few different things, but not sure how/why test would work and live would not. All PayPal credentials checked and correct.

Andy

Andrew Kennedy

Andrew Kennedy 0 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

The error seems to be "This transaction couldn't be completed. Please redirect your customer to PayPal.".

Hmm, any ideas why after coming from the Perch Checkout page, filling in everything on PayPal and coming back to the Perch Checkout page, it would produce this error.

Doesn't make any sense. The redirect to returnUrl is working.

Very odd.

Ok, just tried it again this morning. Only thing I did was remove

PerchUtil::hold_redirects();

which should have made no difference.

Ahh, the only other thing it did differently was to not give me a choice to pay as a guest, so I had to sign in to a PayPal account and it worked.

Very odd indeed.