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

  • Resolved Tayyab Chaudhary

    (@mtachaudhary770)


    4 years ago

    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.

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

    (@3sonsdevelopment)

    3 years, 12 months 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)

    3 years, 12 months ago

    Hi @3sonsdevelopment

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

    Thanks again

    Thread Starter Tayyab Chaudhary

    (@mtachaudhary770)

    3 years, 11 months ago

    Hi @3sonsdevelopment

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

    3 Sons Development

    (@3sonsdevelopment)

    3 years, 11 months 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 – a11n

    (@gabrielfuentes)

    3 years, 11 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)

    3 years, 11 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.