Title: WordPress database error Table
Last modified: February 2, 2024

---

# WordPress database error Table

 *  Resolved [kaboemnld](https://wordpress.org/support/users/kaboemnld/)
 * (@kaboemnld)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/)
 * I have updated to the latest version, i want to clean old analysis data, i uses
   tools option but i get this error
 * WordPress database error Table ‘wp_seopress_content_analysis’ doesn’t exist for
   query DELETE FROM `wp_seopress_content_analysis` made by do_action(‘admin_init’),
   WP_Hook->do_action, WP_Hook->apply_filters, seopress_clean_content_scans
 * Thanks

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

 *  Plugin Author [Benjamin Denis](https://wordpress.org/support/users/rainbowgeek/)
 * (@rainbowgeek)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17399434)
 * Hi,
 * try to edit this file:
 * `wp-seopress/inc/functions/options-import-export.php`
 * Line 64, replace the code by this one:
 *     ```wp-block-code
       // Delete all content scans
   
       function seopress_clean_content_scans() {
   
       if (empty($_POST['seopress_action']) || 'clean_content_scans' != $_POST['seopress_action']) {
   
       return;
   
       }
   
       if (!wp_verify_nonce($_POST['seopress_clean_content_scans_nonce'], 'seopress_clean_content_scans_nonce')) {
   
       return;
   
       }
   
       if (!current_user_can(seopress_capability('manage_options', 'cleaning'))) {
   
       return;
   
       }
   
       // Delete cache option
   
       delete_option('seopress_content_analysis_api_in_progress');
   
       global $wpdb;
   
       // Clean our post metas
   
       $sql = 'DELETE FROM ' . $wpdb->prefix . 'postmeta WHERE meta_key IN ( \'_seopress_analysis_data\', \'_seopress_content_analysis_api\', \'_seopress_analysis_data_oxygen\', \'_seopress_content_analysis_api_in_progress\')';
   
       $sql = $wpdb->prepare($sql);
   
       $wpdb->query($sql);
   
       // Clean custom table if it exists
   
       if ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}seopress_content_analysis'") === $wpdb->prefix . 'seopress_content_analysis') {
   
       $sql = 'DELETE FROM ' . $wpdb->prefix . 'seopress_content_analysis';
   
       $sql = $wpdb->prepare($sql);
   
       $wpdb->query($sql);
   
       }
   
       wp_safe_redirect(admin_url('admin.php?page=seopress-import-export'));
   
       exit;
   
       }
   
       add_action('admin_init', 'seopress_clean_content_scans');
       ```
   
 * Is it better?
 * Please let us know, thanks!
 *  Thread Starter [kaboemnld](https://wordpress.org/support/users/kaboemnld/)
 * (@kaboemnld)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17401227)
 * I get a error after editing
 * fatal error: uncaught error: syntax error, unexpected token “return”on line 70
 * Thanks
 *  Plugin Author [Benjamin Denis](https://wordpress.org/support/users/rainbowgeek/)
 * (@rainbowgeek)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17402961)
 * Can you paste / host on a Drive the complete edited file please?
 * Thanks
 *  Thread Starter [kaboemnld](https://wordpress.org/support/users/kaboemnld/)
 * (@kaboemnld)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17406464)
 * <?php
 * defined(‘ABSPATH’) or exit(‘Please don’t call the plugin directly. Thanks :)’);
 * ///////////////////////////////////////////////////////////////////////////////////////////////////
   //
   Import / Exports settings page/////////////////////////////////////////////////////////////////////////////////////////////////////
   Export SEOPress Settings to JSONfunction seopress_export_settings() {if (empty(
   $_POST[‘seopress_action’]) || ‘export_settings’ != $_POST[‘seopress_action’]){
   return;}if ( ! wp_verify_nonce($_POST[‘seopress_export_nonce’], ‘seopress_export_nonce’)){
   return;}if ( ! current_user_can(seopress_capability(‘manage_options’, ‘export_settings’))){
   return;}
 *     ```wp-block-code
       $settings = seopress_get_service('ExportSettings')->handle();
   
       ignore_user_abort(true);
       nocache_headers();
       header('Content-Type: application/json; charset=utf-8');
       header('Content-Disposition: attachment; filename=seopress-settings-export-' . date('m-d-Y') . '.json');
       header('Expires: 0');
       echo json_encode($settings);
       exit;
       ```
   
 * }
   add_action(‘admin_init’, ‘seopress_export_settings’);
 * //Import SEOPress Settings from JSON
   function seopress_import_settings() {if (
   empty($_POST[‘seopress_action’]) || ‘import_settings’ != $_POST[‘seopress_action’]){
   return;}if ( ! wp_verify_nonce($_POST[‘seopress_import_nonce’], ‘seopress_import_nonce’)){
   return;}if ( ! current_user_can(seopress_capability(‘manage_options’, ‘import_settings’))){
   return;}
 *     ```wp-block-code
       $extension = pathinfo($_FILES['import_file']['name'], PATHINFO_EXTENSION);
   
       if ('json' != $extension) {
           wp_die(__('Please upload a valid .json file', 'wp-seopress'));
       }
       $import_file = $_FILES['import_file']['tmp_name'];
   
       if (empty($import_file)) {
           wp_die(__('Please upload a file to import', 'wp-seopress'));
       }
   
       $settings = (array) json_decode(seopress_remove_utf8_bom(file_get_contents($import_file)), true);
   
       seopress_get_service('ImportSettings')->handle($settings);
   
       wp_safe_redirect(admin_url('admin.php?page=seopress-import-export&success=true'));
       exit;
       ```
   
 * }
   add_action(‘admin_init’, ‘seopress_import_settings’);
 * //Delete all content scans
   function seopress_clean_content_scans() {if (empty(
   $_POST[‘seopress_action’]) || ‘clean_content_scans’ != $_POST[‘seopress_action’]){
   return;}if ( ! wp_verify_nonce($_POST[‘seopress_clean_content_scans_nonce’], ‘
   seopress_clean_content_scans_nonce’)) {return;}if ( ! current_user_can(seopress_capability(‘
   manage_options’, ‘cleaning’))) {return;}
 *     ```wp-block-code
       // Delete cache option
       delete_option('seopress_content_analysis_api_in_progress');
   
       global $wpdb;
   
       // Clean our post metas
       $sql = 'DELETE FROM ' . $wpdb->prefix . 'postmeta    WHERE meta_key IN ( \'_seopress_analysis_data\', \'_seopress_content_analysis_api\', \'_seopress_analysis_data_oxygen\', \'_seopress_content_analysis_api_in_progress\')';
   
       $sql = $wpdb->prepare($sql);
   
       $wpdb->query($sql);
   
       // Clean custom table
       $sql = 'DELETE FROM ' . $wpdb->prefix . 'seopress_content_analysis';
   
       $sql = $wpdb->prepare($sql);
   
       $wpdb->query($sql);
   
       wp_safe_redirect(admin_url('admin.php?page=seopress-import-export'));
       exit;
       ```
   
 * }
   add_action(‘admin_init’, ‘seopress_clean_content_scans’);
 * //Reset SEOPress Notices Settings
   function seopress_reset_notices_settings() {
   if (empty($_POST[‘seopress_action’]) || ‘reset_notices_settings’ != $_POST[‘seopress_action’]){
   return;}if ( ! wp_verify_nonce($_POST[‘seopress_reset_notices_nonce’], ‘seopress_reset_notices_nonce’)){
   return;}if ( ! current_user_can(seopress_capability(‘manage_options’, ‘reset_settings’))){
   return;}
 *     ```wp-block-code
       global $wpdb;
   
       $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE 'seopress_notices' ");
   
       wp_safe_redirect(admin_url('admin.php?page=seopress-import-export'));
       exit;
       ```
   
 * }
   add_action(‘admin_init’, ‘seopress_reset_notices_settings’);
 * //Reset SEOPress Settings
   function seopress_reset_settings() {if (empty($_POST[‘
   seopress_action’]) || ‘reset_settings’ != $_POST[‘seopress_action’]) {return;}
   if ( ! wp_verify_nonce($_POST[‘seopress_reset_nonce’], ‘seopress_reset_nonce’)){
   return;}if ( ! current_user_can(seopress_capability(‘manage_options’, ‘reset_settings’))){
   return;}
 *     ```wp-block-code
       global $wpdb;
   
       $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE 'seopress_%' ");
   
       wp_safe_redirect(admin_url('admin.php?page=seopress-import-export'));
       exit;
       ```
   
 * }
   add_action(‘admin_init’, ‘seopress_reset_settings’);
 *  Plugin Author [Benjamin Denis](https://wordpress.org/support/users/rainbowgeek/)
 * (@rainbowgeek)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17408938)
 *     ```wp-block-code
       <?php
   
       defined('ABSPATH') or exit('Please don&rsquo;t call the plugin directly. Thanks :)');
   
       ///////////////////////////////////////////////////////////////////////////////////////////////////
       //Import / Exports settings page
       ///////////////////////////////////////////////////////////////////////////////////////////////////
       //Export SEOPress Settings to JSON
       function seopress_export_settings() {
           if (empty($_POST['seopress_action']) || 'export_settings' != $_POST['seopress_action']) {
               return;
           }
           if ( ! wp_verify_nonce($_POST['seopress_export_nonce'], 'seopress_export_nonce')) {
               return;
           }
           if ( ! current_user_can(seopress_capability('manage_options', 'export_settings'))) {
               return;
           }
   
           $settings = seopress_get_service('ExportSettings')->handle();
   
           ignore_user_abort(true);
           nocache_headers();
           header('Content-Type: application/json; charset=utf-8');
           header('Content-Disposition: attachment; filename=seopress-settings-export-' . date('m-d-Y') . '.json');
           header('Expires: 0');
           echo json_encode($settings);
           exit;
       }
       add_action('admin_init', 'seopress_export_settings');
   
       //Import SEOPress Settings from JSON
       function seopress_import_settings() {
           if (empty($_POST['seopress_action']) || 'import_settings' != $_POST['seopress_action']) {
               return;
           }
           if ( ! wp_verify_nonce($_POST['seopress_import_nonce'], 'seopress_import_nonce')) {
               return;
           }
           if ( ! current_user_can(seopress_capability('manage_options', 'import_settings'))) {
               return;
           }
   
           $extension = pathinfo($_FILES['import_file']['name'], PATHINFO_EXTENSION);
   
           if ('json' != $extension) {
               wp_die(__('Please upload a valid .json file', 'wp-seopress'));
           }
           $import_file = $_FILES['import_file']['tmp_name'];
   
           if (empty($import_file)) {
               wp_die(__('Please upload a file to import', 'wp-seopress'));
           }
   
           $settings = (array) json_decode(seopress_remove_utf8_bom(file_get_contents($import_file)), true);
   
           seopress_get_service('ImportSettings')->handle($settings);
   
           wp_safe_redirect(admin_url('admin.php?page=seopress-import-export&success=true'));
           exit;
       }
       add_action('admin_init', 'seopress_import_settings');
   
       // Delete all content scans
       function seopress_clean_content_scans() {
           if (empty($_POST['seopress_action']) || 'clean_content_scans' != $_POST['seopress_action']) {
               return;
           }
           if (!wp_verify_nonce($_POST['seopress_clean_content_scans_nonce'], 'seopress_clean_content_scans_nonce')) {
               return;
           }
           if (!current_user_can(seopress_capability('manage_options', 'cleaning'))) {
               return;
           }
   
           // Delete cache option
           delete_option('seopress_content_analysis_api_in_progress');
   
           global $wpdb;
   
           // Clean our post metas
           $sql = 'DELETE FROM ' . $wpdb->prefix . 'postmeta WHERE meta_key IN ( \'_seopress_analysis_data\', \'_seopress_content_analysis_api\', \'_seopress_analysis_data_oxygen\', \'_seopress_content_analysis_api_in_progress\')';
           $sql = $wpdb->prepare($sql);
           $wpdb->query($sql);
   
           // Clean custom table if it exists
           if ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}seopress_content_analysis'") === $wpdb->prefix . 'seopress_content_analysis') {
               $sql = 'DELETE FROM ' . $wpdb->prefix . 'seopress_content_analysis';
               $sql = $wpdb->prepare($sql);
               $wpdb->query($sql);
           }
   
           wp_safe_redirect(admin_url('admin.php?page=seopress-import-export'));
           exit;
       }
       add_action('admin_init', 'seopress_clean_content_scans');
   
   
       //Reset SEOPress Notices Settings
       function seopress_reset_notices_settings() {
           if (empty($_POST['seopress_action']) || 'reset_notices_settings' != $_POST['seopress_action']) {
               return;
           }
           if ( ! wp_verify_nonce($_POST['seopress_reset_notices_nonce'], 'seopress_reset_notices_nonce')) {
               return;
           }
           if ( ! current_user_can(seopress_capability('manage_options', 'reset_settings'))) {
               return;
           }
   
           global $wpdb;
   
           $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE 'seopress_notices' ");
   
           wp_safe_redirect(admin_url('admin.php?page=seopress-import-export'));
           exit;
       }
       add_action('admin_init', 'seopress_reset_notices_settings');
   
       //Reset SEOPress Settings
       function seopress_reset_settings() {
           if (empty($_POST['seopress_action']) || 'reset_settings' != $_POST['seopress_action']) {
               return;
           }
           if ( ! wp_verify_nonce($_POST['seopress_reset_nonce'], 'seopress_reset_nonce')) {
               return;
           }
           if ( ! current_user_can(seopress_capability('manage_options', 'reset_settings'))) {
               return;
           }
   
           global $wpdb;
   
           $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE 'seopress_%' ");
   
           wp_safe_redirect(admin_url('admin.php?page=seopress-import-export'));
           exit;
       }
       add_action('admin_init', 'seopress_reset_settings');
       ```
   
 * Try to copy / paste the all file (wp-seopress/inc/functions/options-import-export.
   php).
 * You should not encounter any error.
 * May I know your PHP version? WP version? SEOPress?
 * Thx
 *  Thread Starter [kaboemnld](https://wordpress.org/support/users/kaboemnld/)
 * (@kaboemnld)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17411308)
 * Thanks, the error has gone.
 * Php version: 8.0.30
   wp version: 6.4.3seopress: 7.4
 * But still after cleaning analysis data, the refresh analysis button in product
   edit is not working, i see only duplicate analysis data when i update with save
   draft button,
 * Thanks
 *  Plugin Author [Benjamin Denis](https://wordpress.org/support/users/rainbowgeek/)
 * (@rainbowgeek)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17411850)
 * Hi,
 * thank you for this update.
 * Can you take a screenshot / video of the issue please?
 * I’m not sure to understand what you mean.
 * Thx
 *  Plugin Author [Benjamin Denis](https://wordpress.org/support/users/rainbowgeek/)
 * (@rainbowgeek)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17452603)
 * Due to inactivity, we’re now closing this topic.
 * Thank you for your understanding.

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

The topic ‘WordPress database error Table’ is closed to new replies.

 * ![](https://ps.w.org/wp-seopress/assets/icon-128x128.gif?rev=3158903)
 * [SEOPress - AI SEO Plugin & On-site SEO](https://wordpress.org/plugins/wp-seopress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-seopress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-seopress/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-seopress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-seopress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-seopress/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 8 replies
 * 2 participants
 * Last reply from: [Benjamin Denis](https://wordpress.org/support/users/rainbowgeek/)
 * Last activity: [2 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-16/#post-17452603)
 * Status: resolved