Support » Plugin: WooCommerce » BROKEN /wp-admin/edit.php?post_type=shop_order

  • Resolved deanMKD

    (@deanmkd)


    Hi Woo

    Recently noticed that Orders link is not accessible from WP Dashboard. When try to access, simply got Error 404, Resource not found. What i tryed to debug:

    – Switch to default theme –> No changes
    – Deactivated all plugins and keep just a Woo –> No changes
    – Checked the Console and found just this error, in red:

    Failed to load resource: the server responded with a status of 404 ()

    Searched on google and found that there is many notices about this issue. Interesting is that when use valid Order ID from database, and load URL directly like:

    https://wisconsinfan.com/wp-admin/post.php?post=5004&action=edit

    Order is load normally, and can make edits. 5004 is valid order ID in my case. What to do to resolve this?

    The page I need help with: [log in to see the link]

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Support Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi,

    The edit.php?post_type=shop_order hitting 404s could be a server related issue, such as low memory (especially if you have large amounts of orders).

    Please see if increasing your memory helps resolve the issue — you can follow the steps here to make the increase:

    https://docs.woocommerce.com/document/increasing-the-wordpress-memory-limit/

    Cheers!

    I dont thins so that memory is issue. See configuration:

    https://i.imgur.com/9xg8IjW.png?1

    https://i.imgur.com/3Qg3Ivv.png?1

    Having about 20 orders.

    What you say?

    • This reply was modified 9 months, 4 weeks ago by  deanMKD.
    • This reply was modified 9 months, 4 weeks ago by  deanMKD.
    Plugin Support Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi, @deanmkd!

    I’ve noticed that you posted here https://wordpress.org/support/topic/broken-wp-admin-edit-phppost_typeshop_order/#post-10617118 .. does that mean the Paypal plugin is the culprit causing the 404 on ?post_type=shop_order ? Have you disabled that plugin to see?

    Cheers!

    IT IS NOT a server issue !
    It is a plugin issue.
    The plugin in question in dangerous and should be taken off wordpress directory.
    And if you have a way to contact the author, please do it, as he didn’t reply to any support request, you should not allow this on WP !

    It fuxxed 5 of my shops until I disabled it, and now the orders list page is still broken.

    I made all tests possible and since I changed from Automatik paypal express plugin, not more problem, but the orders list page isn’t back, can you help with this ?

    Please do something about it !

    Thanks !

    • This reply was modified 9 months, 4 weeks ago by  blliem.
    • This reply was modified 9 months, 4 weeks ago by  blliem.

    @rynald0s @blliem yes as i have writen disabled that plugin, but issue with non accessible orders persisted. Maybe plugin made some changes to DB schema causing to generate 404. i dont know what to do more..

    Plugin Support Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi, @deanmkd | @blliem

    See if refreshing the permalinks, from “Settings > Permalinks” page helps. If it doesn’t help, then disable and re-enable the WooCommerce plugin and see if that helps

    Cheers!

    @rynald0s just tryed both things.. No changes. 🙁

    Many Woo sites seems affected from this badly coded plugin. Hope so someone will found a sollution, because our shops are in non working state.

    Yes I tried EVERYTHING, trust me, nothing has restored the orders list ! Please help !

    Plugin Support Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi, @deanmkd | @blliem!

    OK, it looks like the plugin in question is getting some bad data into _transaction_id post meta for your orders. The only way you’d be able to clear it out is to do so manually, using something like https://wordpress.org/plugins/ari-adminer/. Here’s what it looks like:

    Screen Shot 2018 08 24 at 10 14 25

    Once you’ve cleared the value/s you see there or remove the row/s, then it should start working again

    Again, please be sure to report it to the plugin author!

    Cheers!

    • This reply was modified 9 months, 3 weeks ago by  Rynald0s.

    Oh thank you ! you are so great !
    Do we really have to use this plugin or can we delete the data in database ?

    We have to search for
    _transaction_id
    in post_meta table ?

    I will wait for your confirmation to do it !
    Thanks again !

    Plugin Support Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi, @blliem!

    Yes, and then look through each one manually and remove the rogue meta_value or delete the row/s. It’s a bit of a manual process, unfortunately

    And no, you don’t have to use that plugin — there are many other available. In fact, we have one here https://wordpress.org/plugins/woocommerce-gateway-paypal-express-checkout/

    Cheers!

    I got every orders ID from wp_woocommerce_order_items table, and after that seached by that ID into wp_postmeta. Found some values into meta_value and removed it all one by one data from that row, but again not able to access orders from wp dashboard. Some help?

    I have this exact same issue. Would deleting all the past orders maybe fix the issue? If so how does one delete all the old order data?

    Plugin Support John Coy

    (@johndcoy)

    Automattic Happiness Engineer

    Because the issue has been confirmed to be caused by a third-party plugin and it requires combing through and cleaning the database, we are going to resolve this problem as it’s not related to WooCommerce.

    You can try switching back to a default theme like Twenty Seventeen and disabling all plugins except for WooCommerce to see if this resolves the issue. If not, use the above suggestions or contact your host for database support.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘BROKEN /wp-admin/edit.php?post_type=shop_order’ is closed to new replies.