WordPress database error Unknown column ‘nonce_action’ in ‘field list’

Resolved

(@mtachaudhary770)

Hi Support,

I am facing an issue. When I create a new Page, Post, or edit Order then it shows a 500 Internal Server Error. But when I disable the WooCommerce plugin, it works fine.

I checked the debug.log file and I found the following error in a log file.

WordPress database error Unknown column 'nonce_action' in 'field list' for query SELECT action_id, name, label, query, status, is_primary, actioned_text, nonce_action, nonce_name
				FROM wp_wc_admin_note_actions
				WHERE note_id = 9 made by require_once('wp-admin/admin.php'), set_current_screen, WP_Screen->set_current_screen, do_action('current_screen'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Notes_Run_Db_Update::show_reminder, Automattic\WooCommerce\Admin\Notes\Note->__construct, WC_Data_Store->read, Automattic\WooCommerce\Admin\Notes\DataStore->read, Automattic\WooCommerce\Admin\Notes\DataStore->read_actions

Please help me to fix this error.

This topic was modified 1 year ago by Tayyab Chaudhary.

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

Plugin Support 3 Sons Development – a11n
(@3sonsdevelopment)

1 year ago

Hi @mtachaudhary770,

That is an unusual error. It appears that the wp_wc_admin_note_actions table in the WordPress database is missing one of its columns, nonce_action. I checked the structure of this table on one of my test sites and I do see this column.

Let’s do this. In your WordPress dashboard, go to WooCommerce > Status > Tools and run the tool to validate the database tables. See if that adds this missing column and clears up the errors for you.

Let us know how this goes.

Thanks

Thread Starter Tayyab Chaudhary
(@mtachaudhary770)

1 year ago

Hi @3sonsdevelopment

Thanks for your response. Let me try your suggested solution.

Thanks again

Thread Starter Tayyab Chaudhary
(@mtachaudhary770)

1 year ago

Hi @3sonsdevelopment

I have tried your suggested fix. But it’s not adding the missing column. Should I create that column manually?

Plugin Support 3 Sons Development – a11n
(@3sonsdevelopment)

1 year ago

Hey @mtachaudhary770,

Sorry to hear that didn’t add it in for you. In that case, try adding it manually and see if that will clear things up. Let us know if you still have trouble.

Plugin Support Gabriel F. a11n
(@gabrielfuentes)

12 months ago

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.

Thread Starter Tayyab Chaudhary
(@mtachaudhary770)

12 months ago

Hello @3sonsdevelopment,

I haven’t created the nonce_action column manually, but I have fixed the 500 Internal Server Error while creating a new page and post.

The solution is, I disabled the Classic Editor plugin and then everything is working fine now.

Now just editing the Orders showing the same error. Maybe, it’s due to the missing nonce_action column from the wp_wc_admin_note_actions database table.

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

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

Views