Hi @travelavenger , to confirm, are you trying to update the email under WooCommerce > Settings > Emails in the field “From” address? Or are you updating it elsewhere? Could you please clarify to us a bit more of what you mean by updating an email on your account?
Hi there,
Thank you for the follow up,
i just go to “profile” and change the contact email, however the apache error line has the following at the end:
WP_Screen->set_current_screen, do_action(‘current_screen’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Notes_Run_Db_Update::show_reminder, WC_Notes_Run_Db_Update::update_done_notice, WC_Data->save, WC_Data_Store->update, Automattic\\WooCommerce\\Admin\\Notes\\DataStore->update, Automattic\\WooCommerce\\Admin\\Notes\\DataStore->save_actions, Automattic\\WooCommerce\\Admin\\Notes\\DataStore->read_actions, referer: >>>>some_url<<<<
that is why I thought it might be related to woocommerce,
please advise, thank you!!
Hi @travelavenger
Thanks for providing that additional information about what you’ve been seeing it is a big help.
Can you please check if your browser is up to date? You’ll find a list of the latest browsers at Browse Happy.
http://browsehappy.com/
I would also try clearing your browser cache to see if that helps solve the issue.
https://en.support.wordpress.com/browser-issues/#clearing-your-browser-cache
Once done, please attempt to update your e-mail again, if the problem persists can you send us a screenshot of what you see? I recommend https://snipboard.io/ for easily sharing screenshots – please follow the instructions on the page, then paste the URL in your reply.
Hi there,
thank you for the follow up.
I think clear the cashe might not solve the issue
The apache error log shows that it is a sql issue with unknown column ‘nonce_action’ at the table ‘field list’.
i did a search on the entire folder of woocommerce plugin and found out that the following file contains ‘nonce_action’:
file 1 : woocommerce\includes\admin\notes\class-wc-notes-run-db-update.php
file 2: woocommerce\packages\woocommerce-admin\src\API\Notes.php
file 3:
and in file woocommerce\packages\woocommerce-admin\src\Notes\DataStore.php
there is a sql with column ‘nonce_action’
Line 220: “SELECT action_id, name, label, query, status, is_primary, actioned_text, nonce_action, nonce_name
file 4: \woocommerce\packages\woocommerce-admin\src\Notes\Note.php
I think most likely file 3, the sql causes the error because column ‘nonce_action’ does not exist.
Please see if the sql has issue, or advise a way to rebuild the table, btw I have tried the woocommerce -> status->tool-> “update database” or “Verify base database tables” cannot rebuild the column.
Thank you!
Hello @travelavenger
Thank you for your feedback. I did some research this issue and found two possible solutions.
Force a database update
Your database will not update if it believes that it is up to date. This could explain why your attempts to force this in <b>WooCommerce</b> > <b>Status</b> > <b>Tools</b> didn’t produce a result. A possible workaround is to test following on a cloned staging site:
- Head to
/wp-admin/options.php and check for the version number for woocommerce_admin_version;
- If the value is
3.0.3, try changing that value to 0;
- Save the changes, and then head back to <b>WooCommerce</b> > <b>Status</b> > <b>Tools</b> and run the
Update database tool.
If this resolved the issue on the staging site, you can apply the same changes to your production site. Please be sure to make a complete backup of your site and database beforehand in case this doesn’t work.
Manually add the columns
This issue also seems similar to a report here: https://github.com/woocommerce/woocommerce-admin/pull/6726
In this Pull Request, there is a suggestion to manually add specific entries to your database using SQL.
Again, I recommend testing this on a staging site first, and only applying changes to your production site if this seems to work, and after you have created a complete backup of your site and database.
-
This reply was modified 2 years, 2 months ago by
Paul J a11n.
-
This reply was modified 2 years, 2 months ago by Paul J a11n. Reason: Removing embedded code that isn't rendering correctly
-
This reply was modified 2 years, 2 months ago by Paul J a11n.
-
This reply was modified 2 years, 2 months ago by Paul J a11n. Reason: Cleaning up poorly rendering syntax
Hello Paul,
Thank you for the solution, by using sql to alter the table and add the missing column should fix the issue.
Just a suggestion if woocommerce could add a checking module in the future versions and check/fix the table schema after a fresh update. for the user have no programming background, it is a good way to fix the issue for them.
Thank you!
Hi there,
Thank you for your suggestions! It would be great to have you add them to the Ideas Board, which is where developers go to look for future plugin features and improvements.
I’m going to close this thread now. Feel free to start a new thread if you have any more questions.
Cheers.
