500 Error during admin actions, No order notification emails

  • Resolved bluepointdigital

    (@bluepointdigital)


    5 years, 10 months ago

    I updated to the lates 3.6.1 hoping it would solve the 500 errors I was experiencing in the admin.

    3.6 completely broke my admin actions, order updates caused a 500 error, trying to resend order notifications (because emails completely stopped sending upon new orders) caused a 500 error.

    luckily I had updraftplus and reverted back to my previous version.

    I have a question for WooCommerce staff:

    will the database update that was performed on the 3.6 upgrade cause any issues with me reverting back to the previous version? I have a database backup, but we’ve received orders since the upgrade, so I need to decide what my restore process will be if I need to restore the old database as well.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Peter Fabian

    (@peterfabian1000)

    Hi,

    The database upgrade performs the following operations:
    1. populates a new product meta lookup table used for faster sorting and filtering of products in 3.6 code
    2. updates term meta ordering meta_key (from ‘order_pa_XYZ’ to ‘order’)
    3. adds index to woocommerce_downloadable_product_permissions for faster searching

    I’m not 100% sure if no 2 wouldn’t cause any problems (the background for the change can be found in github: https://github.com/woocommerce/woocommerce/pull/22570), would have to look into the code in more detail. By a quick look, it seems that at least term ordering might be affected.

    Changes 1 & 3 should be safe for you.

    Can you please elaborate on the 500 errors you are getting? Is it in all screens in admin or some of them? Have you tried to perform conflict analysis to rule out potential problems with other plugins? What server configuration do you use? (e.g. what hosting provider, web server, PHP version, etc.)

    Thanks.

    Thread Starter bluepointdigital

    (@bluepointdigital)

    The 500 errors were occurring on certain admin actions.

    We stopped receiving order notifications, so I tried to re-send an order notification and it caused a 500 error.

    Changing order status from order list or from the order summary page also caused this. I didn’t test more because it’s a live site.

    We have quite a few plugins (too many to be honest) but MOST are official WooCommerce plugins.

    I read that it should be a safe upgrade from anything using 3.5 and later, so I didn’t test on the staging server first (my mistake here). But I may upgrade there to test and give some feedback once I’m done with some other tasks.

    WordPress environment
    Home URL: ————–
    Site URL: ————–
    WooCommerce version: 3.5.7
    Log directory writable: ————–
    WordPress version: 5.1.1
    WordPress multisite: –
    WordPress memory limit: 8 GB
    WordPress debug mode: –
    WordPress cron:
    Language: en_US
    External object cache: –
    Server environment
    Server info: Apache/2.4.18
    PHP version: 7.0.33-0ubuntu0.16.04.3 – We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP post max size: 64 MB
    PHP time limit: 600
    PHP max input vars: 1000
    cURL version: 7.47.0, OpenSSL/1.0.2g
    SUHOSIN installed: –
    MySQL version: 5.7.25-0ubuntu0.16.04.2
    Max upload size: 64 MB

    Plugin Contributor Peter Fabian

    (@peterfabian1000)

    Please let us know if manage to find steps to reproduce on your staging site.
    Thanks.

    dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @bluepointdigital

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thanks,

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘500 Error during admin actions, No order notification emails’ is closed to new replies.