Perch PayPal Shop - Suddenly Not Working

Hi Rachel,

Sure - But as far as the timestamps on the server go, and as far as us making any changes - nothing!

I've logged in and checked the IPN URL specified inside the client's PayPal account, and that's still correct.

Nope, not working in development either!

Okay - thanks!

Do you have any idea at this stage of what might have caused this?

I can see that PayPal has gone through a look-and-feel type change since we launched the site, I'm not sure if that update had any technical implications but I take it that an update on the PayPal side of things could have caused this issue?

EDIT - Perch Debug Output

I'm not really finding anything in the debug output - there are two unrelated errors, but they would have been present since launch.

Debug Message
[1] SELECT * FROM perch2_pages WHERE pagePath='/training-and-courses/product.php' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
Using sub-template: /templates/pages/attributes/facebook.html
Using sub-template: /templates/pages/attributes/twitter.html
[6] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/training-and-courses/product.php' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='social links' AND (regionPage='/training-and-courses/product.php' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=50 AND idx.itemRev=13)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval ORDER BY sortval ASC
[1] Using template: /templates/content/_social_links.html
[1] SELECT groupID FROM perch2_navigation WHERE groupSlug='admin' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch2_pages p, perch2_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/training-and-courses/product.php' LIMIT 1
[4] Using template: /templates/navigation/item.html
Using template: /templates/search/search-form.html
[26] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/training-and-courses/product.php' LIMIT 1
[1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-019', '000') ORDER BY pageTreePosition DESC
[7] Using template: /templates/navigation/item.html
[1] SELECT groupID FROM perch2_navigation WHERE groupSlug='mobile' LIMIT 1
[10] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=6 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch2_pages p, perch2_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=6 AND p.pagePath='/training-and-courses/product.php' LIMIT 1
[10] Using template: /templates/navigation/item.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/training-and-courses/product.php' OR pageSortPath='/training-and-courses/product.php' LIMIT 1
[nil] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-019%' AND pageDepth >=1 AND pageDepth<=4 ORDER BY pageTreePosition ASC
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='sidebar widgets' AND (regionPage='/training-and-courses/product.php' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=726 AND idx.itemRev=0)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval ORDER BY sortval ASC
Using template: /templates/content/_sidebar_widgets.html
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/training-and-courses/product.php' OR pageSortPath='/training-and-courses/product.php' LIMIT 1
[nil] SELECT * FROM perch2_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-019', '000') ORDER BY pageTreePosition
[] Using template: /templates/navigation/breadcrumbs.html
[nil] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='page subheading' AND (regionPage='/training-and-courses/product.php' OR regionPage='*')
No matching content regions found. Check region name (page subheading) and page path options.
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE idx.regionID IS NULL AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval ORDER BY sortval ASC
Using template: /templates/content/_page_subheading.html
[37] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
[1] SELECT p.* FROM perch2_shop_products p WHERE productStatus='Live' AND productSlug='first-aid'
Array
(
    [0] => Array
        (
            [productID] => 15
            [productCode] => FirstAid18/9/16
            [productTitle] => First aid
            [productSlug] => first-aid
            [productDescRaw] => 
            [productDescHTML] => 
            [productDynamicFields] => {"date":null,"productImage":null}
            [productStatus] => Live
            [productCount] => 9
            [productPrice] => 65.00
            [productCourse] => 18
            [productDate] => 
            [isFinished] => 0
            [dateDate] => 2016-09-18
            [coursedateDate] => 2016-07-31 00:00:00
        )

)
[nil] SELECT optionID, optionKey, optionValues FROM perch2_shop_product_options WHERE productID = 15
[] Using template: /templates/shop/product_options.html
[1] Using template: /templates/shop/product.html
[nil] SELECT c.* FROM perch2_shop_categories c, perch2_shop_products_to_categories p2c WHERE c.categoryID=p2c.categoryID AND p2c.productID='15'
[37] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
[nil] SELECT c.categoryID, c.categoryTitle, c.categorySlug, COUNT(p2c.productID) AS qty FROM perch2_shop_categories c, perch2_shop_products_to_categories p2c, perch2_shop_products p WHERE p2c.categoryID=c.categoryID AND p2c.productID=p.productID AND p.productStatus='Live' GROUP BY c.categoryID ORDER BY c.categoryTitle ASC
[] Using template: /templates/shop/category_link.html
Array
(
    [type] => 8
    [message] => Use of undefined constant mobile - assumed 'mobile'
    [file] => /var/www/vhosts/thirdfloordigital.net/ag.thirdfloordigital.net/inc/header.php
    [line] => 125
)

Hi all,

It's started working again this morning, according to the client.

Thanks for the help.