• Resolved traffichunter

    (@traffichunter)


    Hey,
    I have a really annoying issue with my site. Our orders page has gone down. No access to page one of the orders via the backend nav. I Can use history to get pages 2 and above. I Passed values through the url to view orders by number so i started typing numbers in and managed to narrow-down 2 orders that serve this error also when trying to view their details the internal error page is shown. A possible link to the problem is the orders causing the problem both paid via PayPal Express plugin.I Tried deleting the orders from the db but still causing same issue. Turned off all plugins and the problem is still there. Updated plugins and woocom but the issue is still there. The problem was there before I did any updates. I was working on the site adding manual orders which was the area where I first started investigating thinking I had caused a bug. I can view the orders added manually fine. Not sure whats going on. I have tried debug logs but nothing is listed. Here are my server access logs, error log and website message.

    Internal Server Error
    The server encountered an internal error or misconfiguration and was unable to complete your request.
    Please contact the server administrator at admin@stackcp.com to inform them of the time this error occurred, and the actions you performed just before this error.
    More information about this error may be available in the server error log.

    Error logs
    [21/Mar/2018:21:17:04 +0000] “POST /shop/wp-admin/admin-ajax.php HTTP/1.1” 200 103 “https://website.co.uk/shop/wp-admin/post.php?post=608&action=edit” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/604.5.6 (KHTML, like Gecko) Version/11.0.3 Safari/604.5.6”

    [Wed Mar 21 21:16:43 2018] [error] [client myip:33502] End of script output before headers: edit.php

    i’m using store front theme

Viewing 3 replies - 1 through 3 (of 3 total)
  • Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    Need some more information, as the 500 error in the logs vaguely means an error in the server happened.

    Could you contact your web hosts and ask them for the PHP error logs, ideally with stack traces.

    Thread Starter traffichunter

    (@traffichunter)

    This has been driving me nuts and i have found the issue but not why the issue was there to begin with. It was two particular orders with PayPal express as the gateway, basically the the value of _transaction_id in the wp_postmeta table is “”O:8:”WC_Order”:1:{s:5:”�*�id”;i:5137;}” which is clearly not what it should be. I placed the real value from PayPal in there and I can now access my orders and the problem orders. Can i tell you why this happened, no. I have no idea cannot find much on the topic either.

    Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    It looks like a serialized array/object got saved to the database instead of the transaction ID.

    I’ve not heard of this happening before, so my guess is that something else got involved and caused a conflict (like another plugin).

    It is pretty straightforward how the transaction ID is added to the DB: https://github.com/woocommerce/woocommerce/blob/8b06e0e43259ff918af0db86d02c8d3216255fe9/includes/gateways/paypal/class-wc-gateway-paypal.php#L380. PayPal first sends the Completed payment status, then we set the TRANSACTIONID from that response.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Internal Error 500’ is closed to new replies.