fatal error after upgrading to version 4.3

Resolved travelavenger
(@travelavenger)

4 years, 9 months ago
Dear Sir,

After upgrading to version 4.3, my site has stop working and apache error has the following:

PHP Fatal error: Uncaught Exception: Invalid data store for admin note. in {some_link}/woocommerce/packages/woocommerce-admin/src/Notes/DataStore.php:127

I covered the actual link with {some_link} for security reason.

I had to restore woocommerce back to 4.2.2 in order to get my site back on,

please advise, thank you!
- This topic was modified 4 years, 9 months ago by travelavenger.

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

skychemist5
(@skychemist5)

4 years, 9 months ago

I received the same error within the last hour of this post. I contacted my host and had them restore the site. I then updated plugins one by one – “Woocommerce Admin” turned out to be the plugin tossing the error for me. I had the site restored a second time and then “deactivated” and “deleted” the plugin. You should also be able to do this from with in the “plugins” folder on your site.

I’ve deleted the “Woocommerce Admin” plugin from every one of my sites and updated without issue. YMMV – best of wishes and hope you are able to get your site back up.

Plugin Contributor Niels Lange
(@nielslange)

4 years, 9 months ago

Hello @travelavenger,

Issues like that one that you are facing are often caused by theme and plugin conflicts. I suggest conduction test as described on https://docs.woocommerce.com/document/how-to-test-for-conflicts/.

Thread Starter travelavenger
(@travelavenger)

4 years, 9 months ago

Thank you for @skychemist5 and @nielslange solution and suggestion.

However to Niels Lange I would like to point out that many people is having the same issue with version 4.3, at least 2 of us here and another similar topic at the forum which woocommerce should take a look. Specially version 4.3 is conflicting with “woocommerce admin” which is made by the same company.

We are using woocommce for business purpose, which some plugin is very important and cannot just stop and delete them because the business is running. Plugin such as “woocommece admin”

Perhap 4.3.1 or later version could apply the fix, in the mean while 4.2.2 is the stable one.

Thank you!

Timmy Crawford
(@timmydcrawford)

4 years, 9 months ago

Hello @travelavenger sorry you encountered an error with the update. We did test out the scenario of older versions of WooCommerce Admin being present during the 4.3 upgrade and we didn’t encounter the error you shared above.

Could you provide anymore details around your site to see if we could look into a cause of the error? Specifically what version of WooCommerce Admin you had installed, and how you updated to WooCommerce 4.3 would be quite helpful.

Additionally a copy of your System Status report would be informative too ( https://docs.woocommerce.com/document/understanding-the-woocommerce-system-status-report/ )

Thanks much, and again sorry you encountered this issue.

Thread Starter travelavenger
(@travelavenger)

4 years, 9 months ago

Hi Timmy Crawford,

thank you for your reply, I am just pointing the issue of @skychemist5 encounter with woocommerce admin, you could reference from the conversation.

I am using other plugins and have the same fatal error

my apache error log of PHP

PHP Fatal error: Uncaught Exception: Invalid data store for admin note. in {plugin folder}/woocommerce/packages/woocommerce-admin/src/Notes/DataStore.php:127

I suggest your tech team could do a little investigation on it.

the function at file woocommerce/packages/woocommerce-admin/src/Notes/DataStore.php causes the error

the function name is

public function read( &$note )

it missed all the condition and landed at the last “else” condition caused the fatal error

} else {
throw new \Exception( __( ‘Invalid data store for admin note.’, ‘woocommerce’ ) );
}

mbabin
(@mbabin)

4 years, 9 months ago

Same problem, fresh install, Twenty Twenty theme, no other plugins.

Problem appears to be on line 76 in DataStore.php

“SELECT name, type, locale, title, content, content_data, status, source, date_created, date_reminder, is_snoozable, layout, image FROM {$wpdb->prefix}wc_admin_notes WHERE note_id = %d LIMIT 1”,

Database table in wc_admin_notes doesn’t have layout or image column, therefore $note_row returns empty and error is thrown.

If you change line 76 to
“SELECT name, type, locale, title, content, content_data, status, source, date_created, date_reminder, is_snoozable FROM {$wpdb->prefix}wc_admin_notes WHERE note_id = %d LIMIT 1”,

Then all is well.
Thread Starter travelavenger
(@travelavenger)

4 years, 9 months ago
Hello mbabin,

Thank you for the solution, I think your solution is correct if columns are missing, it does fall into the exception.

If any woocommence representative has read this, please notice that version 4.3 has sql issue, it might not just has plugin compatibility issue. And hopefully could apply the fix and release a new version as soon as possible.

Thank you!
- This reply was modified 4 years, 9 months ago by travelavenger.
Azure11
(@azure11)

4 years, 9 months ago

I’ve just had this issue too. Deleted the Woocommerce admin plugin via CPanel File Manager and site is now working.

Plugin Support EastOfWest a11n
(@eastofwest)

4 years, 9 months ago

Hi all 👋🏼 Thanks for flagging this. It’s an open issue, a fix for which is in the works:

https://github.com/woocommerce/woocommerce-admin/issues/4823

Plugin Support EastOfWest a11n
(@eastofwest)

4 years, 9 months ago

It’s been a while since there’s been any replies on this, so I’ll go head and mark it as resolved. If you have any further questions, you can always start a new thread.