Support » Plugin: WooCommerce » WordPress database error Unknown column ‘nonce_action’ in ‘field list’

  • Resolved Tayyab Chaudhary

    (@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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support 3 Sons Development – a11n

    (@3sonsdevelopment)

    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)

    Hi @3sonsdevelopment

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

    Thanks again

    Thread Starter Tayyab Chaudhary

    (@mtachaudhary770)

    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)

    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 gabrielfuentes

    (@gabrielfuentes)

    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)

    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)
  • You must be logged in to reply to this topic.