Boeing news layoffs,Win888 pub login app.Recharge Every day and Get Bonus up-to 50%!

Resolved dhb1989
(@dhb1989)

3 years, 1 month ago

Hello there,

I have upgraded latest WooCommerce on date: 13th Jan 2022. after upgraded it generating error logs with missing field in database tables.

You can check below error which i got in error_log file
[15-Jan-2022 10:36:17 UTC] 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 <a href=\"https://docs.woocommerce.com/document/stripe/?_ga=2.90941597.642705274.1635776464-1391993999.1621950839#apple-pay\">enable Apple Pay with Stripe</a> and easy to communicate it with this <a href=\"https://developer.apple.com/apple-pay/marketing/\">marketing guide</a>.',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2021-11-11 11:05:50',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '59' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Install::check_version, do_action('woocommerce_admin_updated'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\RemoteInboxNotifications\RemoteInboxNotificationsEngine::run_on_woocommerce_admin_updated, Automattic\WooCommerce\Admin\RemoteInboxNotifications\RemoteInboxNotificationsEngine::run, Automattic\WooCommerce\Admin\RemoteInboxNotifications\SpecRunner::run_spec, WC_Data->save, WC_Data_Store->update, Automattic\WooCommerce\Admin\Notes\DataStore->update

And also getting too much time to load wp-admin panel after upgrade this plugin.

Can you please help me on this?

Regards,
Dharmesh

Viewing 5 replies - 16 through 20 (of 20 total)

← 1 2

strarsis
(@strarsis)

2 years, 11 months ago
@ihereira: I have the exact same issue.
‘Thank you’ button after successful database update leads to an empty/white page.
PHP error logged: https://gist.github.com/strarsis/1d0307704a29294a28ce03f77d5c0cd8
- This reply was modified 2 years, 11 months ago by strarsis.
- This reply was modified 2 years, 11 months ago by strarsis.
Plugin Support nathvi V. a11n
(@nathvi)

2 years, 11 months ago

Hi @dhb1989

I’d be glad to help.

Can you please try a conflict test on the site to rule out something else interfering? Below are the steps:

1) Temporarily switch your theme to Storefront
2) Disable all plugins except for WooCommerce

If this is not possible on your live site, you can create a staging site and perform the tests there.

You can find a more detailed explanation on how to do a conflict test here.

I’d also like to better understand your site. 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 in your response.

Once we have that information, we’ll be in a better place to help.

Thread Starter dhb1989
(@dhb1989)

2 years, 11 months ago

Hello @nathvi,

Thanks for your advice but now it was fixed.

Regards,
Dharmesh
blauweb
(@blauweb)

2 years, 11 months ago
Hi @dhb1989

What was the solution? I am having the same error. Thanks!

(edit)
Nevermind – I saw it in the thread – adding the database table manually. I don’t like this solution, but for now it’s OK.

Regards,
Martin
- This reply was modified 2 years, 11 months ago by blauweb.
Margaret S. woo-hc
(@margaretwporg)

2 years, 11 months ago

Hi @blauweb

Thanks for posting your comment here, and great that you applied a temporary solution.

If you need help, kindly create a new thread so that your issue can be looked at individually: https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0

This is in line with the forum guidelines on posting on related threads / existing threads with similar issues.

Viewing 5 replies - 16 through 20 (of 20 total)

← 1 2

The topic ‘database error Unknown column ‘is_read’ in ‘field list’’ is closed to new replies.