WC 6.1 DB issue

  • Resolved ethereumicoio

    (@ethereumicoio)


    4 years, 5 months ago

    After the last WooCommerce update the 502 Error is shown after login to my site. I’ve downgraded to 5.9 version to fix it.

    A lot of errors like that in my error.log file:

    2022/01/12 21:16:56 [error] 932#932: *406135 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'is_read' in 'field list' for query UPDATEwp_wc_admin_notesSETname= 'stripe_applepay_holiday2021',type= 'marketing',locale= 'en_US',title= 'Boost sales this holiday season with Apple Pay!',content= 'Increase your conversion rate by letting your customers know that you accept Apple Pay. It’s seamless to enable Apple Pay with Stripe and easy to communicate it with this marketing guide.',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2021-11-12 02:42:24',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '72' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php...PHP message: WordPress database error Unknown column 'is_read' in 'field list' for query UPDATEwp_wc_admin_notesSETname= 'square_applepay_holiday2021',type= 'marketing',locale= 'en_US',title= 'Boost sales this holiday season with Apple Pay!',content= 'Increase your conversion rate by letting your customers know that you accept Apple Pay. It’s seamless to enable Apple Pay with Square and easy to communicate it with this marketing guide.',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2021-11-12 02:42:24',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '73' made by require_once('wp-load.php'`

    • This topic was modified 4 years, 5 months ago by ethereumicoio. Reason: format

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • 3 Sons Development

    (@3sonsdevelopment)

    4 years, 4 months ago

    Hey there,

    It sounds like the database is missing a column, is_read, in the wp_wc_admin_notes table. If I check my test sites, I do see that column in the table.

    You could try disabling WooCommerce temporarily, then update the plugin and activate it again. That should trigger it to check the database tables for errors like that.

    Let us know how that goes. If you still have trouble, could you please send me a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it here.

    Thanks!

    MayKato

    (@maykato)

    4 years, 4 months ago

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem! If you have further questions, please feel free to open a new topic.

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

The topic ‘WC 6.1 DB issue’ is closed to new replies.

Tags